eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 4225: FROM bom_explosions be

4221: extended_quantity,
4222: component_code,
4223: PRIMARY_UOM_CODE,
4224: sort_order
4225: FROM bom_explosions be
4226: WHERE
4227: be.explosion_type = 'INCLUDED'
4228: AND be.plan_level >= 0
4229: AND be.extended_quantity > 0

Line 4252: FROM oe_order_lines oel, bom_explosions be

4248: p_std_comp_freeze_date IN DATE)
4249: IS
4250: SELECT
4251: oel.line_id, be.extended_quantity * p_top_model_quantity
4252: FROM oe_order_lines oel, bom_explosions be
4253: WHERE oel.top_model_line_id = p_top_model_line_id
4254: AND oel.link_to_line_id = l_parent_line_rec.line_id
4255: AND oel.item_type_code = 'INCLUDED'
4256: AND be.explosion_type = 'INCLUDED'

Line 4280: FROM bom_explosions be

4276: AND l.item_type_code = 'INCLUDED'
4277: AND l.open_flag = 'Y'
4278: AND NOT EXISTS
4279: ( SELECT 'X'
4280: FROM bom_explosions be
4281: WHERE be.component_code = l.component_code
4282: AND be.explosion_type = 'INCLUDED'
4283: AND be.plan_level >= 0
4284: AND be.TOP_BILL_SEQUENCE_ID = p_top_bill_sequence_id

Line 5832: -- Explode the options in Bom_Explosions

5828: RAISE FND_API.G_EXC_ERROR;
5829: END;
5830:
5831:
5832: -- Explode the options in Bom_Explosions
5833: IF l_debug_level > 0 THEN
5834: oe_debug_pub.add('CALL TO EXPLOSION' , 2 );
5835: oe_debug_pub.add('ORG ID: '|| L_VALIDATION_ORG , 2 );
5836: END IF;

Line 5869: FROM bom_explosions

5865:
5866: BEGIN
5867: SELECT bill_sequence_id
5868: into l_model_seq_id
5869: FROM bom_explosions
5870: WHERE COMPONENT_ITEM_ID = l_top_item_id
5871: AND ORGANIZATION_ID = l_validation_org
5872: AND PLAN_LEVEL = 0
5873: AND effectivity_date <= l_rev_date

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

5893: IF l_debug_level > 0 THEN
5894: oe_debug_pub.add('COMPLETE ITEM: '|| LINE_REC.INVENTORY_ITEM_ID , 1);
5895: END IF;
5896:
5897: -- 1st obtain component_code using bom_explosions, if the select
5898: -- statement fetches more than one row, there is ambiguity in the bill
5899: -- we can not set the component_code for that item.
5900: BEGIN
5901:

Line 5911: FROM bom_explosions

5907: SELECT component_code, component_sequence_id, sort_order,
5908: primary_uom_code
5909: INTO l_component_code, l_component_seq_id, l_sort_order,
5910: l_uom_code
5911: FROM bom_explosions
5912: WHERE component_item_id = line_rec.inventory_item_id
5913: AND explosion_type = Oe_Config_Util.OE_BMX_ALL_COMPS
5914: AND top_bill_sequence_id = l_model_seq_id
5915: AND effectivity_date <= l_rev_date

Line 5929: FROM bom_explosions

5925: SELECT component_code, component_sequence_id, sort_order,
5926: primary_uom_code
5927: INTO l_component_code, l_component_seq_id, l_sort_order,
5928: l_uom_code
5929: FROM bom_explosions
5930: WHERE component_item_id = line_rec.inventory_item_id
5931: AND explosion_type = Oe_Config_Util.OE_BMX_ALL_COMPS
5932: AND top_bill_sequence_id = l_model_seq_id
5933: AND effectivity_date <= l_rev_date

Line 8940: ( component_item_id bom_explosions.component_item_id%TYPE

8936: -- information on OM tables i.e. Link_To_Line_id and Component_Code validation
8937: -- for each INCLUDED items in the BOM definition
8938: --
8939: TYPE Bom_Explosion_Rec IS RECORD
8940: ( component_item_id bom_explosions.component_item_id%TYPE
8941: , component_sequence_id bom_explosions.component_sequence_id%TYPE
8942: , extended_quantity bom_explosions.extended_quantity%TYPE
8943: , component_code bom_explosions.component_code%TYPE
8944: , PRIMARY_UOM_CODE bom_explosions.PRIMARY_UOM_CODE%TYPE

Line 8941: , component_sequence_id bom_explosions.component_sequence_id%TYPE

8937: -- for each INCLUDED items in the BOM definition
8938: --
8939: TYPE Bom_Explosion_Rec IS RECORD
8940: ( component_item_id bom_explosions.component_item_id%TYPE
8941: , component_sequence_id bom_explosions.component_sequence_id%TYPE
8942: , extended_quantity bom_explosions.extended_quantity%TYPE
8943: , component_code bom_explosions.component_code%TYPE
8944: , PRIMARY_UOM_CODE bom_explosions.PRIMARY_UOM_CODE%TYPE
8945: , sort_order bom_explosions.sort_order%TYPE

Line 8942: , extended_quantity bom_explosions.extended_quantity%TYPE

8938: --
8939: TYPE Bom_Explosion_Rec IS RECORD
8940: ( component_item_id bom_explosions.component_item_id%TYPE
8941: , component_sequence_id bom_explosions.component_sequence_id%TYPE
8942: , extended_quantity bom_explosions.extended_quantity%TYPE
8943: , component_code bom_explosions.component_code%TYPE
8944: , PRIMARY_UOM_CODE bom_explosions.PRIMARY_UOM_CODE%TYPE
8945: , sort_order bom_explosions.sort_order%TYPE
8946: , OM_Parent_Line_id oe_order_lines_all.line_id%TYPE

Line 8943: , component_code bom_explosions.component_code%TYPE

8939: TYPE Bom_Explosion_Rec IS RECORD
8940: ( component_item_id bom_explosions.component_item_id%TYPE
8941: , component_sequence_id bom_explosions.component_sequence_id%TYPE
8942: , extended_quantity bom_explosions.extended_quantity%TYPE
8943: , component_code bom_explosions.component_code%TYPE
8944: , PRIMARY_UOM_CODE bom_explosions.PRIMARY_UOM_CODE%TYPE
8945: , sort_order bom_explosions.sort_order%TYPE
8946: , OM_Parent_Line_id oe_order_lines_all.line_id%TYPE
8947: , OM_Parent_Inventory_Item_id oe_order_lines_all.Inventory_Item_id%TYPE

Line 8944: , PRIMARY_UOM_CODE bom_explosions.PRIMARY_UOM_CODE%TYPE

8940: ( component_item_id bom_explosions.component_item_id%TYPE
8941: , component_sequence_id bom_explosions.component_sequence_id%TYPE
8942: , extended_quantity bom_explosions.extended_quantity%TYPE
8943: , component_code bom_explosions.component_code%TYPE
8944: , PRIMARY_UOM_CODE bom_explosions.PRIMARY_UOM_CODE%TYPE
8945: , sort_order bom_explosions.sort_order%TYPE
8946: , OM_Parent_Line_id oe_order_lines_all.line_id%TYPE
8947: , OM_Parent_Inventory_Item_id oe_order_lines_all.Inventory_Item_id%TYPE
8948: );

Line 8945: , sort_order bom_explosions.sort_order%TYPE

8941: , component_sequence_id bom_explosions.component_sequence_id%TYPE
8942: , extended_quantity bom_explosions.extended_quantity%TYPE
8943: , component_code bom_explosions.component_code%TYPE
8944: , PRIMARY_UOM_CODE bom_explosions.PRIMARY_UOM_CODE%TYPE
8945: , sort_order bom_explosions.sort_order%TYPE
8946: , OM_Parent_Line_id oe_order_lines_all.line_id%TYPE
8947: , OM_Parent_Inventory_Item_id oe_order_lines_all.Inventory_Item_id%TYPE
8948: );
8949:

Line 8970: FROM bom_explosions be

8966: sort_order,
8967: null OM_Parent_Line_id,
8968: null OM_Parent_Inventory_Item_id
8969: -- To OM fields, setting the NULL values so as to complete the record structure
8970: FROM bom_explosions be
8971: WHERE
8972: be.explosion_type = OE_GLOBALS.G_ITEM_INCLUDED --'INCLUDED'
8973: AND be.plan_level >= 0
8974: AND be.extended_quantity > 0

Line 9154: -- Validating if the EBS BOM definition in BOM_Explosions table

9150: -- have taken above, without which, there may be tens of many more
9151: -- required validation to be considered but we are safely ignoring
9152: -- them.
9153: --
9154: -- Validating if the EBS BOM definition in BOM_Explosions table
9155: -- and BOM information passed by DOO in OE_order_Lines_All table is same
9156: IF l_included_item_tbl.COUNT <> l_Bom_Explosion_Tbl.COUNT THEN
9157: if l_debug_level > 0 then
9158: oe_debug_pub.add(' The count of Included Items are not same',5);