APPS.OE_BULK_CONFIG_UTIL dependencies on BOM_EXPLOSIONS

Line 2383: -- Load BOM into bom_explosions table if not there already.

2379: );
2380: END IF;
2381:
2382: -- IF Model Line then Set top_model_line_id(I) = line_id(I);
2383: -- Load BOM into bom_explosions table if not there already.
2384: IF l_line_rec.item_type_code(I) = 'MODEL' AND
2385: l_line_rec.top_model_line_ref(I) = l_line_rec.orig_sys_line_ref(I) THEN
2386:
2387: IF l_debug_level > 0 THEN

Line 2443: FROM bom_explosions

2439: l_config_rec.low_quantity(I),
2440: l_config_rec.mutually_exclusive_options(I),
2441: l_config_rec.bom_item_type(I),
2442: l_config_rec.replenish_to_order_flag(I)
2443: FROM bom_explosions
2444: WHERE COMPONENT_ITEM_ID = l_line_rec.inventory_item_id(I)
2445: AND ORGANIZATION_ID = OE_BULK_ORDER_PVT.G_ITEM_ORG
2446: AND PLAN_LEVEL = 0
2447: AND nvl(effectivity_date, sysdate) <= sysdate

Line 2490: -- Also get other BOM attributes from BOM_EXPLOSIONS as

2486: l_line_rec.line_id(l_curr_ato_index);
2487: END IF;
2488:
2489: -- For Child Lines, use following cursor to derive the component_code.
2490: -- Also get other BOM attributes from BOM_EXPLOSIONS as
2491: BEGIN
2492:
2493: SELECT component_code,
2494: component_sequence_id,

Line 2511: FROM bom_explosions

2507: l_config_rec.low_quantity(I),
2508: l_config_rec.mutually_exclusive_options(I),
2509: l_config_rec.bom_item_type(I),
2510: l_config_rec.replenish_to_order_flag(I)
2511: FROM bom_explosions
2512: WHERE component_item_id = l_line_rec.inventory_item_id(I)
2513: AND explosion_type = OE_Config_Util.OE_BMX_OPTION_COMPS
2514: AND top_bill_sequence_id = l_line_rec.top_bill_sequence_id(I)
2515: AND plan_level > 0

Line 2744: FROM BOM_EXPLOSIONS b,

2740: b.mutually_exclusive_options,
2741: b.bom_item_type,
2742: null LOCK_CONTROL,
2743: b.replenish_to_order_flag
2744: FROM BOM_EXPLOSIONS b,
2745: oe_config_details_tmp L
2746: WHERE b.top_bill_sequence_id = L.top_bill_sequence_id
2747: AND L.item_type_code = 'MODEL'
2748: AND L.line_id = L.top_model_line_id