APPS.CZ_IMP_ALL dependencies on CZ_EXV_BILL_OF_MATERIALS

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

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

Line 1051: FROM CZ_EXV_BILL_OF_MATERIALS

1047:
1048: /* Log a message if the bill being imported (not refreshed) refers to a common bill */
1049: SELECT ORGANIZATION_ID, ASSEMBLY_ITEM_ID
1050: INTO commonOrgId, commonInvId
1051: FROM CZ_EXV_BILL_OF_MATERIALS
1052: WHERE BILL_SEQUENCE_ID in
1053: (SELECT COMMON_BILL_SEQUENCE_ID FROM CZ_EXV_BILL_OF_MATERIALS
1054: WHERE ORGANIZATION_ID = nOrg_ID
1055: AND ASSEMBLY_ITEM_ID = nTop_ID);

Line 1053: (SELECT COMMON_BILL_SEQUENCE_ID FROM CZ_EXV_BILL_OF_MATERIALS

1049: SELECT ORGANIZATION_ID, ASSEMBLY_ITEM_ID
1050: INTO commonOrgId, commonInvId
1051: FROM CZ_EXV_BILL_OF_MATERIALS
1052: WHERE BILL_SEQUENCE_ID in
1053: (SELECT COMMON_BILL_SEQUENCE_ID FROM CZ_EXV_BILL_OF_MATERIALS
1054: WHERE ORGANIZATION_ID = nOrg_ID
1055: AND ASSEMBLY_ITEM_ID = nTop_ID);
1056: IF ((commonOrgId <> nOrg_ID) or (commonInvId <> nTop_ID)) THEN
1057: retcode := 1;