DBA Data[Home] [Help]

APPS.AHL_MM_MTL_MGT_PVT dependencies on OE_ORDER_LINES_ALL

Line 602: oe_order_lines_all ORDER_LINE,

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
605: AND ORDER_HEAD.header_id = ORDER_LINE.header_id
606: AND POREQ_HEAD.requisition_header_id = POREQ_LINE.requisition_header_id

Line 2403: OE_ORDER_LINES_ALL OOLA

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
2406: AND OOHA.HEADER_ID = OOLA.HEADER_ID;
2407: EXCEPTION