APPS.AHL_COMPLEX_MX_RWSC_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 639: FROM MTL_SYSTEM_ITEMS_VL MTL, CSI_ITEM_INSTANCES CSI

635: SELECT 'U' FROM AHL_UNIT_CONFIG_HEADERS WHERE csi_item_instance_id = c_instance_id;
636:
637: CURSOR get_part_info(c_instance_id NUMBER) IS
638: SELECT MTL.inventory_item_id,MTL.concatenated_segments,CSI.instance_number,CSI.serial_number, CSI.quantity
639: FROM MTL_SYSTEM_ITEMS_VL MTL, CSI_ITEM_INSTANCES CSI
640: WHERE CSI.instance_id = c_instance_id
641: AND CSI.inventory_item_id = MTL.inventory_item_id
642: AND CSI.inv_master_organization_id = MTL.organization_id;
643:

Line 1018: FROM MTL_SYSTEM_ITEMS_VL MTL, CSI_ITEM_INSTANCES CSI

1014: SELECT (NVL(MAX(visit_ir_uc_id),0) + 1) from ahl_visit_ir_uc_details;
1015:
1016: CURSOR get_part_info(c_instance_id NUMBER) IS
1017: SELECT MTL.inventory_item_id,MTL.concatenated_segments,CSI.instance_number,CSI.serial_number, CSI.quantity
1018: FROM MTL_SYSTEM_ITEMS_VL MTL, CSI_ITEM_INSTANCES CSI
1019: WHERE CSI.instance_id = c_instance_id
1020: AND CSI.inventory_item_id = MTL.inventory_item_id
1021: AND CSI.inv_master_organization_id = MTL.organization_id;
1022: