DBA Data[Home] [Help]

APPS.CZ_CF_API dependencies on CZ_EXV_MTL_SYSTEM_ITEMS

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

3988: dp_org_id IN VARCHAR2,
3989: p_inventory_item_id IN VARCHAR2) AS
3990:
3991: CURSOR C_GETMODELS(Org_ID NUMBER) IS
3992: SELECT A.ASSEMBLY_ITEM_ID FROM CZ_EXV_BILL_OF_MATERIALS A,CZ_EXV_MTL_SYSTEM_ITEMS B
3993: WHERE A.ASSEMBLY_ITEM_ID=B.INVENTORY_ITEM_ID
3994: AND A.ORGANIZATION_ID=B.ORGANIZATION_ID
3995: AND B.BOM_ITEM_TYPE=1
3996: AND A.ORGANIZATION_ID= Org_ID

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

4091: dp_org_id IN VARCHAR2,
4092: p_inventory_item_id IN VARCHAR2) AS
4093:
4094: CURSOR C_GETMODELS(Org_ID NUMBER) IS
4095: SELECT A.ASSEMBLY_ITEM_ID FROM CZ_EXV_BILL_OF_MATERIALS A,CZ_EXV_MTL_SYSTEM_ITEMS B
4096: WHERE A.ASSEMBLY_ITEM_ID=B.INVENTORY_ITEM_ID
4097: AND A.ORGANIZATION_ID=B.ORGANIZATION_ID
4098: AND B.BOM_ITEM_TYPE=1
4099: AND A.ORGANIZATION_ID= Org_ID