DBA Data[Home] [Help]

APPS.CSM_ITEM_INSTANCE_EVENT_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 853: FROM CSI_ITEM_INSTANCES cii, MTL_SYSTEM_ITEMS_B si

849: p_party_id NUMBER )
850: IS
851: SELECT cii.instance_id,cii.inventory_item_id inv_item_id,
852: NVL(cii.LAST_VLD_ORGANIZATION_ID,cii.inv_master_organization_id) org_id
853: FROM CSI_ITEM_INSTANCES cii, MTL_SYSTEM_ITEMS_B si
854: WHERE si.inventory_item_id = cii.inventory_item_id
855: AND si.organization_id = NVL( cii.LAST_VLD_ORGANIZATION_ID,
856: cii.inv_master_organization_id )
857: AND cii.instance_id NOT IN