APPS.AHL_CMP_UTIL_PKG dependencies on MTL_ITEM_LOCATIONS

Line 55: CSI_ITEM_INSTANCES CSI, MTL_ITEM_LOCATIONS MTL

51: CURSOR get_rpr_batch_csr (c_visit_id NUMBER,
52: c_instance_id NUMBER) IS
53: SELECT TSK.repair_batch_name
54: FROM AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,
55: CSI_ITEM_INSTANCES CSI, MTL_ITEM_LOCATIONS MTL
56: WHERE TSK.visit_id = c_visit_id
57: AND VST.visit_id = TSK.visit_id
58: AND (
59: MTL.physical_location_id = VST.comp_planning_loc_id

Line 519: MTL_ITEM_LOCATIONS MTL

515: SELECT NVL(SUM(CII.quantity),0)
516: INTO l_planning_qty
517: FROM CSI_ITEM_INSTANCES CII,
518: AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,
519: MTL_ITEM_LOCATIONS MTL
520: WHERE TSK.repair_batch_name = p_repair_batch
521: AND VST.visit_id = TSK.visit_id
522: AND MTL.physical_location_id = VST.comp_planning_loc_id
523: AND MTL.project_id = VST.project_id

Line 539: MTL_ITEM_LOCATIONS MTL

535: SELECT NVL(SUM(CII.quantity),0)
536: INTO l_inrepair_qty
537: FROM CSI_ITEM_INSTANCES CII,
538: AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,
539: MTL_ITEM_LOCATIONS MTL
540: WHERE TSK.repair_batch_name = p_repair_batch
541: AND VST.visit_id = TSK.visit_id
542: AND MTL.physical_location_id = VST.comp_inrepair_loc_id
543: AND MTL.project_id = VST.project_id

Line 658: FROM MTL_ITEM_LOCATIONS MIL,MTL_ITEM_LOCATIONS_KFV MIL_kfv

654: || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
655: || INV_ProjectLocator_PUB.get_project_number(MIL.segment19)
656: || FND_FLEX_EXT.GET_DELIMITER('INV', 'MTLL', 101)
657: || INV_ProjectLocator_PUB.get_task_number(MIL.segment20)) locator_segments
658: FROM MTL_ITEM_LOCATIONS MIL,MTL_ITEM_LOCATIONS_KFV MIL_kfv
659: WHERE MIL_kfv.INVENTORY_LOCATION_ID = MIL.INVENTORY_LOCATION_ID AND
660: MIL_kfv.ORGANIZATION_ID = MIL.ORGANIZATION_ID AND
661: MIL.INVENTORY_LOCATION_ID = p_locator_id;
662:

Line 671: FROM MTL_ITEM_LOCATIONS_KFV MIL

667: || INV_ProjectLocator_PUB.get_project_number(MIL.segment19)
668: || FND_FLEX_EXT.GET_DELIMITER('INV', 'MTLL', 101)
669: || INV_PROJECTLOCATOR_PUB.GET_TASK_NUMBER(MIL.SEGMENT20))
670: INTO l_concat_segs
671: FROM MTL_ITEM_LOCATIONS_KFV MIL
672: WHERE MIL.INVENTORY_LOCATION_ID = p_locator_id;*/
673:
674: OPEN get_locator_segments(p_locator_id);
675: FETCH get_locator_segments INTO l_concat_segs;