DBA Data[Home] [Help]

APPS.OE_PROCESS_OPTIONS_PVT dependencies on BOM_EXPLOSIONS

Line 1243: FROM bom_explosions be

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

Line 1641: FROM bom_explosions

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