DBA Data[Home] [Help]

APPS.INV_MGD_MVT_PO_MDTR dependencies on OE_ORDER_HEADERS_ALL

Line 782: OE_ORDER_HEADERS_ALL ooha

778: --Bugfix 9676611: customer_number should come from HZ_CUST_ACCOUNTS
779: --, rac.party_number
780: , hzc.account_number
781: FROM
782: OE_ORDER_HEADERS_ALL ooha
783: , OE_ORDER_LINES_ALL oola
784: , HZ_PARTIES rac
785: , HZ_CUST_ACCOUNTS hzc
786: , MTL_SYSTEM_ITEMS si

Line 1343: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;

1339: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_RMA_Details';
1340:
1341: /*bug 8435314 Add logic for config Item in RMA*/
1342: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
1343: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;
1344: l_error_code NUMBER;
1345: l_return_status VARCHAR2(1);
1346: l_item_type_code OE_ORDER_LINES_ALL.Item_Type_Code%TYPE;
1347: l_So_line_Id NUMBER;

Line 1389: , OE_ORDER_HEADERS_ALL ooha

1385: FROM
1386: RCV_TRANSACTIONS po
1387: , RCV_SHIPMENT_HEADERS rsh
1388: , RCV_SHIPMENT_LINES rsl
1389: , OE_ORDER_HEADERS_ALL ooha
1390: , OE_ORDER_LINES_ALL oola
1391: --, MTL_SYSTEM_ITEMS si
1392: --, CST_ITEM_COSTS_FOR_GL_VIEW cst
1393: WHERE po.shipment_header_id = rsh.shipment_header_id

Line 1719: , oe_order_headers_all orha

1715: FROM
1716: rcv_transactions rcv
1717: , po_requisition_lines_all prla
1718: , po_requisition_headers_all prha
1719: , oe_order_headers_all orha
1720: , hr_organization_information hoi
1721: WHERE rcv.requisition_line_id = prla.requisition_line_id
1722: AND prla.requisition_header_id = prha.requisition_header_id
1723: AND prha.requisition_header_id = orha.source_document_id

Line 1786: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;

1782: l_mvt_stat_status rcv_transactions.mvt_stat_status%TYPE;
1783:
1784: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
1785: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
1786: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;
1787: l_error_code NUMBER;
1788: l_return_status VARCHAR2(1);
1789: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_IO_Arrival_Details';
1790:

Line 1852: , OE_ORDER_HEADERS_ALL ooha

1848: FROM
1849: WSH_NEW_DELIVERIES_OB_GRP_V wnd
1850: , wsh_delivery_assignments_v wda
1851: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
1852: , OE_ORDER_HEADERS_ALL ooha
1853: , OE_ORDER_LINES_ALL oola
1854: , HZ_PARTIES rac
1855: , HZ_CUST_ACCOUNTS hzc
1856: WHERE wnd.delivery_id = wda.delivery_id