APPS.AHL_COMPLEX_MX_PVT dependencies on CSI_ITEM_INSTANCES

Line 81: FROM csi_item_instances

77: -- Cursor to check whether the item in INV or WIP
78: CURSOR c_inst_not_in_inv_wip(c_instance_id IN NUMBER)
79: IS
80: SELECT 'Y'
81: FROM csi_item_instances
82: WHERE instance_id = c_instance_id
83: AND INV_LOCATOR_ID IS NULL
84: AND WIP_JOB_ID IS NULL;
85:

Line 985: --FROM csi_item_instances cii ,mtl_item_locations_kfv mil

981: CURSOR Get_Instance_Attributes(c_instance_id IN NUMBER) IS
982: SELECT cii.instance_id,cii.location_type_code, cii.instance_usage_code,cii.wip_job_id,cii.inv_locator_id,
983: mil.segment19,mil.segment20
984: -- fix for bug 16304850
985: --FROM csi_item_instances cii ,mtl_item_locations_kfv mil
986: FROM csi_item_instances cii ,mtl_item_locations mil
987: -- end fix for bug 16304850
988: WHERE cii.instance_id = c_instance_id
989: and cii.inv_locator_id = mil.inventory_location_id (+);

Line 986: FROM csi_item_instances cii ,mtl_item_locations mil

982: SELECT cii.instance_id,cii.location_type_code, cii.instance_usage_code,cii.wip_job_id,cii.inv_locator_id,
983: mil.segment19,mil.segment20
984: -- fix for bug 16304850
985: --FROM csi_item_instances cii ,mtl_item_locations_kfv mil
986: FROM csi_item_instances cii ,mtl_item_locations mil
987: -- end fix for bug 16304850
988: WHERE cii.instance_id = c_instance_id
989: and cii.inv_locator_id = mil.inventory_location_id (+);
990: