DBA Data[Home] [Help]

APPS.MRP_SCATP_PUB dependencies on BOM_EXPLOSIONS

Line 148: bom_explosions be,

144: mdi.supply_header_id
145: FROM mtl_system_items msi,
146: mtl_parameters mp,
147: wip_parameters wp,
148: bom_explosions be,
149: bom_bill_of_materials bom,
150: mtl_demand_interface mdi
151: WHERE mdi.atp_group_id = l_atp_group_id
152: AND bom.assembly_item_id = mdi.inventory_item_id

Line 370: BOM_EXPLOSIONS BE

366: -- so we need to make sure all the parents are not model/oc.
367: SELECT '1'
368: INTO l_required
369: FROM BOM_INVENTORY_COMPONENTS BIC,
370: BOM_EXPLOSIONS BE
371: WHERE BE.TOP_BILL_SEQUENCE_ID = p_top_bill_seq_id
372: AND BE.COMPONENT_CODE = l_component_code
373: AND BE.PLAN_LEVEL = i
374: AND BE.explosion_type = 'ALL'