APPS.INV_MGD_MVT_SO_MDTR dependencies on OE_ORDER_HEADERS_ALL

Line 101: , OE_ORDER_HEADERS_ALL oh

97: , wsh_delivery_assignments_v wda
98: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
99: , hr_organization_information hoi
100: , OE_ORDER_LINES_ALL ol
101: , OE_ORDER_HEADERS_ALL oh
102: , HZ_CUST_SITE_USES_ALL ras
103: WHERE wnd.delivery_id = wda.delivery_id
104: AND wda.delivery_detail_id = wdd.delivery_detail_id
105: AND wdd.source_line_id = ol.line_id

Line 137: , OE_ORDER_HEADERS_ALL oh

133: , wsh_delivery_assignments_v wda
134: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
135: , hr_organization_information hoi
136: , OE_ORDER_LINES_ALL ol
137: , OE_ORDER_HEADERS_ALL oh
138: , HZ_CUST_SITE_USES_ALL ras
139: WHERE wnd.delivery_id = wda.delivery_id
140: AND wda.delivery_detail_id = wdd.delivery_detail_id
141: AND wdd.source_line_id = ol.line_id

Line 172: , OE_ORDER_HEADERS_ALL oh

168: WSH_NEW_DELIVERIES_OB_GRP_V wnd
169: , wsh_delivery_assignments_v wda
170: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
171: , OE_ORDER_LINES_ALL ol
172: , OE_ORDER_HEADERS_ALL oh
173: , HZ_CUST_SITE_USES_ALL ras
174: , hr_organization_information hoi
175: WHERE wnd.delivery_id = wda.delivery_id
176: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 262: --Fix performance bug2812364, remove table oe_order_headers_all and

258: IF sot_crsr%ISOPEN THEN
259: CLOSE sot_crsr;
260: END IF;
261:
262: --Fix performance bug2812364, remove table oe_order_headers_all and
263: --and hz_cust_site_uses_all
264: --R12 Legal entity uptake, replace hr_operating_units base tables with XLE package
265: --because this view is not existed anymore
266: --Fix bug 5443301, replace ol.sold_from_org_id with ol.org_id

Line 380: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;

376: IS
377: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
378: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
379: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
380: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;
381: l_error_code NUMBER;
382: l_return_status VARCHAR2(1);
383: l_item_type_code oe_order_lines_all.item_type_code%TYPE;
384: l_order_uom OE_ORDER_LINES_ALL.order_Quantity_Uom%TYPE;

Line 434: OE_ORDER_HEADERS_ALL ooha

430: , wnd.name
431: , oola.item_type_code
432: , oola.order_quantity_uom
433: FROM
434: OE_ORDER_HEADERS_ALL ooha
435: , OE_ORDER_LINES_ALL oola
436: , wsh_delivery_details_ob_grp_v wdd
437: , wsh_new_deliveries_ob_grp_v wnd
438: , wsh_delivery_assignments_v wda