APPS.AHL_MM_MTL_MGT_PVT dependencies on MTL_RESERVATIONS

Line 157: FROM MTL_RESERVATIONS MRV

153: CURSOR RESERVED_QTY_CSR(P_SCHEDULE_MATERIAL_ID NUMBER)
154: IS
155: SELECT DEMAND_SOURCE_LINE_DETAIL,
156: NVL(SUM(MRV.PRIMARY_RESERVATION_QUANTITY),0) RESERVED_QTY
157: FROM MTL_RESERVATIONS MRV
158: WHERE DEMAND_SOURCE_LINE_DETAIL = P_SCHEDULE_MATERIAL_ID
159: AND MRV. EXTERNAL_SOURCE_CODE = 'AHL'
160: GROUP BY DEMAND_SOURCE_LINE_DETAIL;
161:

Line 304: FROM MTL_RESERVATIONS MRV

300: CURSOR RESERVED_QTY_CSR(P_SCHEDULE_MATERIAL_ID NUMBER)
301: IS
302: SELECT DEMAND_SOURCE_LINE_DETAIL,
303: NVL(SUM(MRV.PRIMARY_RESERVATION_QUANTITY),0) RESERVED_QTY
304: FROM MTL_RESERVATIONS MRV
305: WHERE DEMAND_SOURCE_LINE_DETAIL = P_SCHEDULE_MATERIAL_ID
306: AND MRV. EXTERNAL_SOURCE_CODE = 'AHL'
307: GROUP BY DEMAND_SOURCE_LINE_DETAIL;
308:

Line 590: FROM mtl_reservations RESERVATION

586: (
587: --Inventory Reservation
588: SELECT sysdate AVAILABLE_DATE,
589: RESERVATION.reservation_quantity RESERVED_QTY
590: FROM mtl_reservations RESERVATION
591: WHERE RESERVATION.supply_source_type_id = 13 /*g_source_type_inv = 13*/
592: AND RESERVATION.demand_source_line_detail = p_scheduled_material_id
593:
594: UNION ALL

Line 603: mtl_reservations RESERVATION

599: FROM po_requisition_headers_all POREQ_HEAD,
600: po_requisition_lines_all POREQ_LINE,
601: oe_order_headers_all ORDER_HEAD,
602: oe_order_lines_all ORDER_LINE,
603: mtl_reservations RESERVATION
604: WHERE POREQ_HEAD.requisition_header_id = ORDER_HEAD.source_document_id
605: AND ORDER_HEAD.header_id = ORDER_LINE.header_id
606: AND POREQ_HEAD.requisition_header_id = POREQ_LINE.requisition_header_id
607: AND POREQ_LINE.item_id = RESERVATION.inventory_item_id

Line 616: FROM mtl_reservations RESERVATION,

612:
613: --WO to WO
614: SELECT WIP.scheduled_completion_date AVAILABLE_DATE,
615: RESERVATION.reservation_quantity RESERVED_QTY
616: FROM mtl_reservations RESERVATION,
617: wip_discrete_jobs WIP
618: WHERE WIP.wip_entity_id = RESERVATION.supply_source_header_id
619: AND RESERVATION.supply_source_type_id = 5 /*g_source_type_wip = 5*/
620: AND RESERVATION.demand_source_line_detail = p_scheduled_material_id

Line 3384: FROM mtl_reservations mr

3380: IF l_reservable_flag = 1 THEN
3381: BEGIN
3382: SELECT reservation_id
3383: INTO l_reservation_id
3384: FROM mtl_reservations mr
3385: WHERE mr.demand_source_line_id = l_order_line_id
3386: AND NVL(staged_flag,'N') = 'N';
3387: EXCEPTION
3388: WHEN no_data_found THEN

Line 5917: || ' FROM MTL_RESERVATIONS MR,'

5913:
5914: --Base criteria for existing reservations
5915: l_base_query := l_base_query || ' AND SERIALS.serial_number IN'
5916: || ' (SELECT UNIQUE NVL(MSN.SERIAL_NUMBER, NVL(WO_RESERV.SERIAL_NUMBER, ISO_RESERV.SERIAL_NUMBER))'
5917: || ' FROM MTL_RESERVATIONS MR,'
5918: || ' MTL_SERIAL_NUMBERS MSN,'
5919: || ' (SELECT CSIII.serial_number,'
5920: || ' WO.WIP_ENTITY_ID'
5921: || ' FROM AHL_WORKORDERS WO,'

Line 6014: || ' FROM MTL_RESERVATIONS RESERV, CSI_ITEM_INSTANCES CSIII'

6010: --Reservations filter
6011: IF(p_demand_Record.Filter_Reservations = 'Y') THEN
6012: l_base_query := l_base_query || ' AND EXISTS '
6013: || ' (SELECT 1'
6014: || ' FROM MTL_RESERVATIONS RESERV, CSI_ITEM_INSTANCES CSIII'
6015: || ' WHERE CSIII.instance_id = NVL(TSK.instance_id, VST.item_instance_id)'
6016: || ' AND RESERV.SUPPLY_SOURCE_HEADER_ID = WO.WIP_ENTITY_ID'
6017: || ' AND RESERV.SUPPLY_SOURCE_TYPE_ID = 5)';
6018: END IF;