APPS.CZ_IMP_ALL dependencies on CZ_EXV_MTL_SYSTEM_ITEMS

Line 838: FROM cz_exv_mtl_system_items

834: SELECT ORGANIZATION_ID INTO nOrg_ID FROM CZ_EXV_ORGANIZATIONS
835: WHERE ORGANIZATION_CODE = sOrg_ID;
836:
837: SELECT inventory_item_id INTO nTop_ID
838: FROM cz_exv_mtl_system_items
839: WHERE bom_item_type = 1
840: AND organization_id = nOrg_ID
841: AND concatenated_segments = sTop_ID
842: AND rownum = 1;

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