DBA Data[Home] [Help]

APPS.FLM_MMM_CALCULATION dependencies on OE_INSTALL

Line 211: AND OE_INSTALL.GET_ACTIVE_PRODUCT = 'ONT'

207: AND SL1.ORDERED_QUANTITY > 0
208: AND SL1.VISIBLE_DEMAND_FLAG = 'Y'
209: AND SL1.OPEN_FLAG = 'Y'
210: AND SL1.ITEM_TYPE_CODE in ('STANDARD', 'CONFIG', 'INCLUDED', 'OPTION')
211: AND OE_INSTALL.GET_ACTIVE_PRODUCT = 'ONT'
212: AND wl.organization_id = sl1.ship_from_org_id
213: AND wl.line_id in (select line_id
214: from bom_operational_routings bor2
215: where bor2.assembly_item_id = sl1.inventory_item_id