DBA Data[Home] [Help]

APPS.MRP_WFS_FORM_FLOW_SCHEDULE dependencies on BOM_OPERATIONAL_ROUTINGS

Line 2700: from bom_operational_routings bor2

2696: AND SL1.ITEM_TYPE_CODE in ('STANDARD', 'CONFIG', 'INCLUDED', 'OPTION')
2697: AND OE_INSTALL.GET_ACTIVE_PRODUCT = 'ONT'
2698: AND wl.organization_id = sl1.ship_from_org_id
2699: AND wl.line_id in (select line_id
2700: from bom_operational_routings bor2
2701: where bor2.assembly_item_id = sl1.inventory_item_id
2702: and bor2.organization_id = sl1.ship_from_org_id
2703: and bor2.cfm_routing_flag = 1)
2704: AND SL1.SHIPPED_QUANTITY is NULL

Line 2796: from bom_operational_routings bor2

2792: AND RSI1.BOM_ITEM_TYPE = 4
2793: AND (RSI1.IN_SOURCE_PLAN = 2 OR RSI1.IN_SOURCE_PLAN IS NULL)
2794: AND wl.organization_id = MR1.ORGANIZATION_ID
2795: AND wl.line_id in (select line_id
2796: from bom_operational_routings bor2
2797: where bor2.assembly_item_id = MR1.INVENTORY_ITEM_ID
2798: and bor2.organization_id = MR1.ORGANIZATION_ID
2799: and bor2.cfm_routing_flag = 1)
2800: ) po_orders