APPS.INV_MGD_MVT_SO_MDTR dependencies on OE_INSTALL

Line 111: AND OE_INSTALL.Get_Active_Product = 'ONT'

107: AND wdd.source_code = 'OE'
108: AND wnd.organization_id = hoi.organization_id --fix perf bug 4912552
109: AND hoi.org_information_context = 'Accounting Information'
110: AND ol.ship_to_org_id = ras.site_use_id
111: AND OE_INSTALL.Get_Active_Product = 'ONT'
112: AND oh.order_source_id = 10
113: AND wdd.shipped_quantity > 0
114: AND wnd.status_code in ('IT','CL')
115: AND wdd.mvt_stat_status in ('NEW','MODIFIED')

Line 147: AND OE_INSTALL.Get_Active_Product = 'ONT'

143: AND wdd.source_code = 'OE'
144: AND wnd.organization_id = hoi.organization_id --fix perf bug2812364
145: AND hoi.org_information_context = 'Accounting Information'
146: AND ol.ship_to_org_id = ras.site_use_id
147: AND OE_INSTALL.Get_Active_Product = 'ONT'
148: AND wdd.shipped_quantity > 0
149: AND wnd.status_code in ('IT','CL')
150: AND wdd.mvt_stat_status in ('NEW','MODIFIED','FORDISP')
151: --AND ol.item_type_code <> 'INCLUDED' --Fix bug4185582

Line 183: AND OE_INSTALL.Get_Active_Product = 'ONT'

179: AND wdd.source_code = 'OE'
180: AND wnd.organization_id = hoi.organization_id --fix perf bug2812364
181: AND hoi.org_information_context = 'Accounting Information'
182: AND ol.ship_to_org_id = ras.site_use_id
183: AND OE_INSTALL.Get_Active_Product = 'ONT'
184: AND wdd.shipped_quantity > 0
185: AND wnd.status_code in ('IT','CL')
186: AND wdd.mvt_stat_status in ('NEW','MODIFIED','FORDISP')
187: --AND ol.item_type_code <> 'INCLUDED' --Fix bug4185582

Line 289: AND OE_INSTALL.Get_Active_Product = 'ONT'

285: WHERE wnd.delivery_id = wda.delivery_id
286: AND wda.delivery_detail_id = wdd.delivery_detail_id
287: AND wdd.source_line_id = ol.line_id
288: AND wdd.source_code = 'OE'
289: AND OE_INSTALL.Get_Active_Product = 'ONT'
290: AND wdd.shipped_quantity > 0
291: AND ol.order_source_id <> 10
292: AND wnd.status_code in ('IT','CL')
293: AND wdd.mvt_stat_status in ('NEW','MODIFIED','FORARVL')