DBA Data[Home] [Help]

APPS.OE_ORDER_PVT dependencies on BOM_EXPLOSIONS

Line 2386: are not available in bom_explosions. Populate message and continue.

2382:
2383: Change Record:
2384:
2385: 1828866: to not raise error if some of the option/class items
2386: are not available in bom_explosions. Populate message and continue.
2387: related changes in : OEXUCFGB.pls, OEXUCPYB.pls
2388:
2389: We will not call the complete_config_line for splits. This is
2390: because split already passes all the columns to be filled

Line 11774: we have to always do a select from bom_explosions. This is so that

11770: ASSUMPTION is classes are not shippable, hence we will not try to order
11771: the way class under a class is saved.
11772:
11773: 1828866: Even if all the required fields are populated on the line,
11774: we have to always do a select from bom_explosions. This is so that
11775: we can figure out nocopy if all the items are currenlty part of the Bill.
11776:
11777:
11778: Should not come here for split lines.

Line 11903: FROM bom_explosions

11899: primary_uom_code, bom_item_type
11900: INTO p_x_line_rec.component_code, p_x_line_rec.component_sequence_id,
11901: p_x_line_rec.sort_order, p_x_line_rec.order_quantity_uom,
11902: l_bom_item_type
11903: FROM bom_explosions
11904: WHERE component_item_id = p_x_line_rec.inventory_item_id
11905: AND explosion_type = Oe_Config_Util.OE_BMX_OPTION_COMPS
11906: AND top_bill_sequence_id = l_model_seq_id
11907: AND effectivity_date <= l_rev_date

Line 11922: FROM bom_explosions

11918: primary_uom_code, bom_item_type
11919: INTO p_x_line_rec.component_code, p_x_line_rec.component_sequence_id,
11920: p_x_line_rec.sort_order, p_x_line_rec.order_quantity_uom,
11921: l_bom_item_type
11922: FROM bom_explosions
11923: WHERE component_item_id = p_x_line_rec.inventory_item_id
11924: AND explosion_type = Oe_Config_Util.OE_BMX_OPTION_COMPS
11925: AND top_bill_sequence_id = l_model_seq_id
11926: AND effectivity_date <= l_rev_date

Line 12279: FROM bom_explosions be

12275: p_x_line_tbl(l_index).sort_order,
12276: p_x_line_tbl(l_index).order_quantity_uom,
12277: p_x_line_tbl(l_index).ordered_quantity,
12278: l_bom_item_type
12279: FROM bom_explosions be
12280: WHERE be.explosion_type = OE_Config_Util.OE_BMX_OPTION_COMPS
12281: AND be.top_bill_sequence_id = l_model_seq_id
12282: AND be.plan_level > 0
12283: AND be.effectivity_date <= l_rev_date