APPS.OE_CONFIG_UTIL dependencies on BOM_EXPLOSIONS

Line 57: -- Complete Config Config Using the BOM_EXPLOSIONS

53: --
54: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
55: --
56: BEGIN
57: -- Complete Config Config Using the BOM_EXPLOSIONS
58: -- Populate link_to_line_id
59: -- Populate ato_line_id
60: NULL;
61: END;

Line 4219: FROM bom_explosions be

4215: extended_quantity,
4216: component_code,
4217: PRIMARY_UOM_CODE,
4218: sort_order
4219: FROM bom_explosions be
4220: WHERE
4221: be.explosion_type = 'INCLUDED'
4222: AND be.plan_level >= 0
4223: AND be.extended_quantity > 0

Line 4246: FROM oe_order_lines oel, bom_explosions be

4242: p_std_comp_freeze_date IN DATE)
4243: IS
4244: SELECT
4245: oel.line_id, be.extended_quantity * p_top_model_quantity
4246: FROM oe_order_lines oel, bom_explosions be
4247: WHERE oel.top_model_line_id = p_top_model_line_id
4248: AND oel.link_to_line_id = l_parent_line_rec.line_id
4249: AND oel.item_type_code = 'INCLUDED'
4250: AND be.explosion_type = 'INCLUDED'

Line 4274: FROM bom_explosions be

4270: AND l.item_type_code = 'INCLUDED'
4271: AND l.open_flag = 'Y'
4272: AND NOT EXISTS
4273: ( SELECT 'X'
4274: FROM bom_explosions be
4275: WHERE be.component_code = l.component_code
4276: AND be.explosion_type = 'INCLUDED'
4277: AND be.plan_level >= 0
4278: AND be.TOP_BILL_SEQUENCE_ID = p_top_bill_sequence_id

Line 5825: -- Explode the options in Bom_Explosions

5821: RAISE FND_API.G_EXC_ERROR;
5822: END;
5823:
5824:
5825: -- Explode the options in Bom_Explosions
5826: IF l_debug_level > 0 THEN
5827: oe_debug_pub.add('CALL TO EXPLOSION' , 2 );
5828: oe_debug_pub.add('ORG ID: '|| L_VALIDATION_ORG , 2 );
5829: END IF;

Line 5862: FROM bom_explosions

5858:
5859: BEGIN
5860: SELECT bill_sequence_id
5861: into l_model_seq_id
5862: FROM bom_explosions
5863: WHERE COMPONENT_ITEM_ID = l_top_item_id
5864: AND ORGANIZATION_ID = l_validation_org
5865: AND PLAN_LEVEL = 0
5866: AND effectivity_date <= l_rev_date

Line 5890: -- 1st obtain component_code using bom_explosions, if the select

5886: IF l_debug_level > 0 THEN
5887: oe_debug_pub.add('COMPLETE ITEM: '|| LINE_REC.INVENTORY_ITEM_ID , 1);
5888: END IF;
5889:
5890: -- 1st obtain component_code using bom_explosions, if the select
5891: -- statement fetches more than one row, there is ambiguity in the bill
5892: -- we can not set the component_code for that item.
5893: BEGIN
5894:

Line 5904: FROM bom_explosions

5900: SELECT component_code, component_sequence_id, sort_order,
5901: primary_uom_code
5902: INTO l_component_code, l_component_seq_id, l_sort_order,
5903: l_uom_code
5904: FROM bom_explosions
5905: WHERE component_item_id = line_rec.inventory_item_id
5906: AND explosion_type = Oe_Config_Util.OE_BMX_ALL_COMPS
5907: AND top_bill_sequence_id = l_model_seq_id
5908: AND effectivity_date <= l_rev_date

Line 5922: FROM bom_explosions

5918: SELECT component_code, component_sequence_id, sort_order,
5919: primary_uom_code
5920: INTO l_component_code, l_component_seq_id, l_sort_order,
5921: l_uom_code
5922: FROM bom_explosions
5923: WHERE component_item_id = line_rec.inventory_item_id
5924: AND explosion_type = Oe_Config_Util.OE_BMX_ALL_COMPS
5925: AND top_bill_sequence_id = l_model_seq_id
5926: AND effectivity_date <= l_rev_date