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 138: , OE_ORDER_HEADERS_ALL oh

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

Line 174: , OE_ORDER_HEADERS_ALL oh

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

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

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

Line 388: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;

384: IS
385: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
386: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
387: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
388: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;
389: l_error_code NUMBER;
390: l_return_status VARCHAR2(1);
391: l_item_type_code oe_order_lines_all.item_type_code%TYPE;
392: l_order_uom OE_ORDER_LINES_ALL.order_Quantity_Uom%TYPE;

Line 444: OE_ORDER_HEADERS_ALL ooha

440: , wnd.name
441: , oola.item_type_code
442: , oola.order_quantity_uom
443: FROM
444: OE_ORDER_HEADERS_ALL ooha
445: , OE_ORDER_LINES_ALL oola
446: , wsh_delivery_details_ob_grp_v wdd
447: , wsh_new_deliveries_ob_grp_v wnd
448: , wsh_delivery_assignments_v wda