APPS.INV_MGD_MVT_SO_MDTR dependencies on HZ_CUST_SITE_USES_ALL

Line 102: , HZ_CUST_SITE_USES_ALL ras

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
106: AND ol.header_id = oh.header_id

Line 139: , HZ_CUST_SITE_USES_ALL ras

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
143: AND ol.header_id = oh.header_id

Line 175: , HZ_CUST_SITE_USES_ALL ras

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
179: AND wdd.source_line_id = ol.line_id

Line 266: --and hz_cust_site_uses_all

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
270: --org_id is the correct column to get operating unit