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 138: , HZ_CUST_SITE_USES_ALL ras

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

Line 173: , HZ_CUST_SITE_USES_ALL ras

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

Line 263: --and hz_cust_site_uses_all

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