DBA Data[Home] [Help]

APPS.OE_PROCESS_OPTIONS_PVT dependencies on BOM_EXPLOSIONS

Line 1244: FROM bom_explosions be

1240: p_x_options_tbl(I).sort_order,
1241: p_x_options_tbl(I).order_quantity_uom,
1242: p_x_options_tbl(I).ordered_quantity,
1243: p_x_options_tbl(I).bom_item_type
1244: FROM bom_explosions be
1245: WHERE be.explosion_type = OE_Config_Util.OE_BMX_OPTION_COMPS
1246: AND be.top_bill_sequence_id = p_top_bill_sequence_id
1247: AND be.plan_level > 0
1248: AND be.effectivity_date <= p_effective_date

Line 1642: FROM bom_explosions

1638: BEGIN
1639:
1640: SELECT 1
1641: INTO l_disable_code
1642: FROM bom_explosions
1643: WHERE component_item_id = opt_rec.inventory_item_id
1644: AND explosion_type = Oe_Config_Util.OE_BMX_OPTION_COMPS
1645: AND top_bill_sequence_id = l_top_bill_sequence_id
1646: AND effectivity_date <= l_config_effective_date