From: fvanbortel@netscape.net   
      
   Onder Kaya wrote:   
      
   > Hello everyone,   
   >   
   > We are trying the compile this package but we get this error.   
   >   
   > PACKAGE BODY APPS.XNC_BOM_PVT   
   > On line:32   
   > PLS-00358:'ASSEMBLY_ITEM_ID' exists in more than one table, use qualifier   
   >   
   > What should we do to solve this   
   >   
   > I appreciate   
   > Thanks   
      
   Edit package body, line 32, and use a table qualifier.   
   E.g. :   
   select e.dept_no, dept_name   
   from employees e, departments d   
   where e.dept_no = d.dept_no;   
      
   dept_no would exist in both the departments and employees   
   tables. The "e" would be an alias, used as qualifier; an other   
   way to write it would be:   
   select employees.dept_no, dept_name   
   from employees, departments   
   where employees.dept_no = departments.dept_no;   
      
   dept_name does not need one, as the column is unique   
   within the above query: it only exists in departments,   
   so no further qualification is needed   
   --   
      
   Regards,   
   Frank van Bortel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)