DBA Data[Home] [Help]

APPS.AHL_MM_MTL_MGT_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 601: oe_order_headers_all ORDER_HEAD,

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

Line 2402: OE_ORDER_HEADERS_ALL OOHA,

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

Line 3113: FROM oe_order_headers_all

3109: source_document_type_id
3110: INTO l_customer_id,
3111: l_order_type_id,
3112: l_document_set_id
3113: FROM oe_order_headers_all
3114: WHERE header_id = p_order_header_id;
3115:
3116: -- get the defaults from picking rule.
3117: -- Auto pick confirm flag will be always set to N in this API

Line 5932: || ' OE_ORDER_HEADERS_ALL OOHA,'

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,'
5936: || ' WSH_DELIVERY_DETAILS WDD,'