DBA Data[Home] [Help]

APPS.AHL_MM_MTL_MGT_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 600: po_requisition_lines_all POREQ_LINE,

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
604: WHERE POREQ_HEAD.requisition_header_id = ORDER_HEAD.source_document_id

Line 2312: -- step 9 - Call the Requisition Import concurrent program to populate PO_REQUISTION_HEADERS_ALL and PO_REQUISITION_LINES_ALL table

2308: );
2309: COMMIT;
2310:
2311:
2312: -- step 9 - Call the Requisition Import concurrent program to populate PO_REQUISTION_HEADERS_ALL and PO_REQUISITION_LINES_ALL table
2313: fnd_request.set_org_id (l_destination_ou ) ;
2314: L_REQUEST_ID := FND_REQUEST.SUBMIT_REQUEST ( 'PO', 'REQIMPORT', null, null, false,'AHL', null, 'ALL', null ,'N', 'Y' , CHR(0),
2315: null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null,
2316: null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null,

Line 2343: PO_REQUISITION_LINES_ALL PRLA

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
2347: WHEN NO_DATA_FOUND THEN