DBA Data[Home] [Help]

APPS.OE_ORDER_PVT dependencies on BOM_EXPLOSIONS

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

2345:
2346: Change Record:
2347:
2348: 1828866: to not raise error if some of the option/class items
2349: are not available in bom_explosions. Populate message and continue.
2350: related changes in : OEXUCFGB.pls, OEXUCPYB.pls
2351:
2352: We will not call the complete_config_line for splits. This is
2353: because split already passes all the columns to be filled

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

11541: ASSUMPTION is classes are not shippable, hence we will not try to order
11542: the way class under a class is saved.
11543:
11544: 1828866: Even if all the required fields are populated on the line,
11545: we have to always do a select from bom_explosions. This is so that
11546: we can figure out nocopy if all the items are currenlty part of the Bill.
11547:
11548:
11549: Should not come here for split lines.

Line 11674: FROM bom_explosions

11670: primary_uom_code, bom_item_type
11671: INTO p_x_line_rec.component_code, p_x_line_rec.component_sequence_id,
11672: p_x_line_rec.sort_order, p_x_line_rec.order_quantity_uom,
11673: l_bom_item_type
11674: FROM bom_explosions
11675: WHERE component_item_id = p_x_line_rec.inventory_item_id
11676: AND explosion_type = Oe_Config_Util.OE_BMX_OPTION_COMPS
11677: AND top_bill_sequence_id = l_model_seq_id
11678: AND effectivity_date <= l_rev_date

Line 11693: FROM bom_explosions

11689: primary_uom_code, bom_item_type
11690: INTO p_x_line_rec.component_code, p_x_line_rec.component_sequence_id,
11691: p_x_line_rec.sort_order, p_x_line_rec.order_quantity_uom,
11692: l_bom_item_type
11693: FROM bom_explosions
11694: WHERE component_item_id = p_x_line_rec.inventory_item_id
11695: AND explosion_type = Oe_Config_Util.OE_BMX_OPTION_COMPS
11696: AND top_bill_sequence_id = l_model_seq_id
11697: AND effectivity_date <= l_rev_date

Line 12050: FROM bom_explosions be

12046: p_x_line_tbl(l_index).sort_order,
12047: p_x_line_tbl(l_index).order_quantity_uom,
12048: p_x_line_tbl(l_index).ordered_quantity,
12049: l_bom_item_type
12050: FROM bom_explosions be
12051: WHERE be.explosion_type = OE_Config_Util.OE_BMX_OPTION_COMPS
12052: AND be.top_bill_sequence_id = l_model_seq_id
12053: AND be.plan_level > 0
12054: AND be.effectivity_date <= l_rev_date