DBA Data[Home] [Help]

APPS.AHL_COMPLEX_MX_PVT dependencies on MTL_ITEM_LOCATIONS

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: