DBA Data[Home] [Help]

APPS.FLM_SUPPLY_DEMAND dependencies on BOM_INVENTORY_COMPONENTS

Line 1691: from bom_explosions be, bom_inventory_components bic

1687: l_ext_qty := 1;
1688: WHILE (length(l_sort_order) > l_sort_order_len) LOOP
1689: select NVL(bic.wip_supply_type,WIP_CONSTANTS.PUSH), NVL(bic.basis_type,WIP_CONSTANTS.ITEM_BASED_MTL),be.component_quantity
1690: into l_wip_supply_type,l_basis_type,l_qty
1691: from bom_explosions be, bom_inventory_components bic
1692: where be.top_bill_sequence_id = l_top_bill_sequence_id
1693: and be.explosion_type = 'ALL'
1694: and be.sort_order = l_sort_order
1695: and be.component_sequence_id = bic.component_sequence_id;