APPS.CZ_IMP_ALL dependencies on CZ_EXV_BILL_OF_MATERIALS

Line 862: SELECT A.ASSEMBLY_ITEM_ID FROM CZ_EXV_BILL_OF_MATERIALS A,CZ_EXV_MTL_SYSTEM_ITEMS B

858: sOrg_ID IN VARCHAR2,dsOrg_ID IN VARCHAR2,
859: sFrom IN VARCHAR2,sTo IN VARCHAR,
860: COPY_CHILD_MODELS IN VARCHAR2 DEFAULT '0') IS
861: CURSOR C_GETMODELS(Org_ID NUMBER) IS
862: SELECT A.ASSEMBLY_ITEM_ID FROM CZ_EXV_BILL_OF_MATERIALS A,CZ_EXV_MTL_SYSTEM_ITEMS B
863: WHERE A.ASSEMBLY_ITEM_ID=B.INVENTORY_ITEM_ID
864: AND A.ORGANIZATION_ID=B.ORGANIZATION_ID
865: AND B.BOM_ITEM_TYPE=1
866: AND A.ORGANIZATION_ID=Org_ID

Line 976: FROM CZ_EXV_BILL_OF_MATERIALS

972:
973: /* Log a message if the bill being imported (not refreshed) refers to a common bill */
974: SELECT ORGANIZATION_ID, ASSEMBLY_ITEM_ID
975: INTO commonOrgId, commonInvId
976: FROM CZ_EXV_BILL_OF_MATERIALS
977: WHERE BILL_SEQUENCE_ID in
978: (SELECT COMMON_BILL_SEQUENCE_ID FROM CZ_EXV_BILL_OF_MATERIALS
979: WHERE ORGANIZATION_ID = nOrg_ID
980: AND ASSEMBLY_ITEM_ID = nTop_ID);

Line 978: (SELECT COMMON_BILL_SEQUENCE_ID FROM CZ_EXV_BILL_OF_MATERIALS

974: SELECT ORGANIZATION_ID, ASSEMBLY_ITEM_ID
975: INTO commonOrgId, commonInvId
976: FROM CZ_EXV_BILL_OF_MATERIALS
977: WHERE BILL_SEQUENCE_ID in
978: (SELECT COMMON_BILL_SEQUENCE_ID FROM CZ_EXV_BILL_OF_MATERIALS
979: WHERE ORGANIZATION_ID = nOrg_ID
980: AND ASSEMBLY_ITEM_ID = nTop_ID);
981: IF ((commonOrgId <> nOrg_ID) or (commonInvId <> nTop_ID)) THEN
982: retcode := 1;