APPS.AHL_MM_MTL_MGT_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 599: FROM po_requisition_headers_all POREQ_HEAD,

595:
596: --ISO
597: SELECT ORDER_LINE.schedule_arrival_date AVAILABLE_DATE,
598: RESERVATION.reservation_quantity RESERVED_QTY
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

Line 2342: FROM PO_REQUISITION_HEADERS_ALL PRHA,

2338: PRLA.REQUISITION_LINE_ID -- req line id
2339: INTO X_REQUISITION_NUM,
2340: X_REQUISITION_HDR_ID,
2341: X_REQUISITION_LINE_ID
2342: FROM PO_REQUISITION_HEADERS_ALL PRHA,
2343: PO_REQUISITION_LINES_ALL PRLA
2344: WHERE PRHA.REQUISITION_HEADER_ID = PRLA.REQUISITION_HEADER_ID
2345: AND INTERFACE_SOURCE_LINE_ID = L_PRODUCT_TXN_ID;
2346: EXCEPTION

Line 2352: update PO_REQUISITION_HEADERS_ALL set INTERFACE_SOURCE_LINE_ID = P_SCH_MTL_ID where REQUISITION_HEADER_ID = X_REQUISITION_HDR_ID;

2348: RAISE CREATE_IR_EXC;
2349: END;
2350:
2351: -- update INTERFACE_SOURCE_LINE_ID to track which IR got created for which Scheduled material ID
2352: update PO_REQUISITION_HEADERS_ALL set INTERFACE_SOURCE_LINE_ID = P_SCH_MTL_ID where REQUISITION_HEADER_ID = X_REQUISITION_HDR_ID;
2353:
2354:
2355: IF (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) THEN
2356: FND_LOG.STRING( l_log_statement, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'For Internal Requisition, x_requisition_num = ' || X_REQUISITION_NUM ||

Line 2401: FROM PO_REQUISITION_HEADERS_ALL PRHA,

2397: OOLA.LINE_ID -- order line id
2398: INTO X_INT_ORDER_HDR_ID,
2399: X_INT_ORDER_NUM,
2400: X_INT_ORDER_LINE_ID
2401: FROM PO_REQUISITION_HEADERS_ALL PRHA,
2402: OE_ORDER_HEADERS_ALL OOHA,
2403: OE_ORDER_LINES_ALL OOLA
2404: WHERE PRHA.REQUISITION_HEADER_ID = X_REQUISITION_HDR_ID
2405: AND PRHA.REQUISITION_HEADER_ID = OOLA.SOURCE_DOCUMENT_ID

Line 5931: || ' FROM PO_REQUISITION_HEADERS_ALL PRHA,'

5927: || ' AND ATSK.return_to_supply_flag = ''Y'''
5928: || ' AND ATSK.visit_id = AVST.visit_id'
5929: || ' AND CSIII.instance_id = NVL(ATSK.instance_id, AVST.item_instance_id)) WO_RESERV,'
5930: || ' (SELECT CSIII.SERIAL_NUMBER, CSIII.INVENTORY_ITEM_ID, PRHA.REQUISITION_HEADER_ID, AMTI.RESERVATION_ID'
5931: || ' FROM PO_REQUISITION_HEADERS_ALL PRHA,'
5932: || ' OE_ORDER_HEADERS_ALL OOHA,'
5933: || ' MTL_SERIAL_NUMBERS MSN,'
5934: || ' CSI_ITEM_INSTANCES CSIII,'
5935: || ' MTL_SERIAL_NUMBERS_TEMP MSNT,'