Onder Kaya wrote:
Hello everyone,
We are trying the compile this package but we get this error.
PACKAGE BODY APPS.XNC_BOM_PV T
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.dep t_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