APPS.INV_MGD_MVT_PO_MDTR dependencies on OE_ORDER_HEADERS_ALL

Line 746: OE_ORDER_HEADERS_ALL ooha

742: , ooha.orig_sys_document_ref
743: , rac.party_name
744: , rac.party_number
745: FROM
746: OE_ORDER_HEADERS_ALL ooha
747: , OE_ORDER_LINES_ALL oola
748: , HZ_PARTIES rac
749: , HZ_CUST_ACCOUNTS hzc
750: , MTL_SYSTEM_ITEMS si

Line 1285: , OE_ORDER_HEADERS_ALL ooha

1281: FROM
1282: RCV_TRANSACTIONS po
1283: , RCV_SHIPMENT_HEADERS rsh
1284: , RCV_SHIPMENT_LINES rsl
1285: , OE_ORDER_HEADERS_ALL ooha
1286: , OE_ORDER_LINES_ALL oola
1287: --, MTL_SYSTEM_ITEMS si
1288: --, CST_ITEM_COSTS_FOR_GL_VIEW cst
1289: WHERE po.shipment_header_id = rsh.shipment_header_id

Line 1560: , oe_order_headers_all orha

1556: FROM
1557: rcv_transactions rcv
1558: , po_requisition_lines_all prla
1559: , po_requisition_headers_all prha
1560: , oe_order_headers_all orha
1561: , hr_organization_information hoi
1562: WHERE rcv.requisition_line_id = prla.requisition_line_id
1563: AND prla.requisition_header_id = prha.requisition_header_id
1564: AND prha.requisition_header_id = orha.source_document_id

Line 1627: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;

1623: l_mvt_stat_status rcv_transactions.mvt_stat_status%TYPE;
1624:
1625: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
1626: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
1627: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;
1628: l_error_code NUMBER;
1629: l_return_status VARCHAR2(1);
1630: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_IO_Arrival_Details';
1631:

Line 1691: , OE_ORDER_HEADERS_ALL ooha

1687: FROM
1688: WSH_NEW_DELIVERIES_OB_GRP_V wnd
1689: , wsh_delivery_assignments_v wda
1690: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
1691: , OE_ORDER_HEADERS_ALL ooha
1692: , OE_ORDER_LINES_ALL oola
1693: , HZ_PARTIES rac
1694: , HZ_CUST_ACCOUNTS hzc
1695: WHERE wnd.delivery_id = wda.delivery_id