APPS.FLM_SUPPLY_DEMAND dependencies on BOM_EXPLOSIONS

Line 1339: BOM_EXPLOSIONS BE ,

1335: F.bom_revision_date bom_revision_date,
1336: F.alternate_bom_designator alternate_bom_designator
1337: FROM WIP_FLOW_SCHEDULES F,
1338: BOM_BILL_OF_MATERIALS BOM ,
1339: BOM_EXPLOSIONS BE ,
1340: BOM_CALENDAR_DATES C,
1341: MTL_PARAMETERS P,
1342: MTL_SYSTEM_ITEMS I,
1343: MTL_ATP_RULES R,

Line 1654: FROM bom_explosions be

1650: l_total_qty NUMBER := 0;
1651:
1652: CURSOR find_comps (l_top_bill_seq_id NUMBER) IS
1653: SELECT sort_order
1654: FROM bom_explosions be
1655: WHERE be.top_bill_sequence_id = l_top_bill_seq_id
1656: and be.organization_id = p_organization_id
1657: and be.component_item_id = p_component_item_id
1658: and be.explosion_type = 'ALL'

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;