APPS.BOMPCEXP dependencies on BOM_EXPLOSION_TEMP

Line 14: | use value from sequence bom_explosion_temp_s|

10: | to join to cst_default_cost_view to get the costing |
11: | attributes. |
12: | Parameters: org_id organization_id |
13: | grp_id unique value to identify current explosion |
14: | use value from sequence bom_explosion_temp_s|
15: | cst_type_id cost type id |
16: | err_msg error message out buffer |
17: | error_code error code out. returns sql error code |
18: | History: |

Line 84: BOM_EXPLOSION_TEMP BET_MUST_HAVE,

80: BET.TOP_BILL_SEQUENCE_ID,
81: BET.ROWID
82: FROM CST_ITEM_COSTS CIC,
83: CST_ITEM_COSTS CIC_DEF,
84: BOM_EXPLOSION_TEMP BET_MUST_HAVE,
85: BOM_EXPLOSION_TEMP BET1,
86: BOM_EXPLOSION_TEMP BET
87: WHERE BET1.GROUP_ID = c_grp_id
88: AND BET1.TOP_BILL_SEQUENCE_ID = BET.TOP_BILL_SEQUENCE_ID

Line 85: BOM_EXPLOSION_TEMP BET1,

81: BET.ROWID
82: FROM CST_ITEM_COSTS CIC,
83: CST_ITEM_COSTS CIC_DEF,
84: BOM_EXPLOSION_TEMP BET_MUST_HAVE,
85: BOM_EXPLOSION_TEMP BET1,
86: BOM_EXPLOSION_TEMP BET
87: WHERE BET1.GROUP_ID = c_grp_id
88: AND BET1.TOP_BILL_SEQUENCE_ID = BET.TOP_BILL_SEQUENCE_ID
89: AND BET1.SORT_ORDER =

Line 86: BOM_EXPLOSION_TEMP BET

82: FROM CST_ITEM_COSTS CIC,
83: CST_ITEM_COSTS CIC_DEF,
84: BOM_EXPLOSION_TEMP BET_MUST_HAVE,
85: BOM_EXPLOSION_TEMP BET1,
86: BOM_EXPLOSION_TEMP BET
87: WHERE BET1.GROUP_ID = c_grp_id
88: AND BET1.TOP_BILL_SEQUENCE_ID = BET.TOP_BILL_SEQUENCE_ID
89: AND BET1.SORT_ORDER =
90: SUBSTR(BET.SORT_ORDER, 1, c_counter*c_X_SortWidth)

Line 202: UPDATE BOM_EXPLOSION_TEMP BET

198: ** need to update certain columns dependent on the cost rollup
199: ** update level 0 seperately
200: */
201:
202: UPDATE BOM_EXPLOSION_TEMP BET
203: SET (ITEM_COST, BASED_ON_ROLLUP_FLAG, EXTEND_COST_FLAG,
204: ACTUAL_COST_TYPE_ID, SHRINKAGE_RATE, INVENTORY_ASSET_FLAG) =
205: (SELECT /*+ ORDERED
206: INDEX (CIC,CST_ITEM_COSTS_U1)

Line 234: FROM BOM_EXPLOSION_TEMP

230: AND PLAN_LEVEL = 0;
231:
232: SELECT nvl(MAX(PLAN_LEVEL), 0)
233: INTO exploded_levels
234: FROM BOM_EXPLOSION_TEMP
235: WHERE GROUP_ID = grp_id;
236:
237: SELECT DEFAULT_COST_TYPE_ID
238: INTO l_default_cost_type_id

Line 288: UPDATE BOM_EXPLOSION_TEMP BET

284:
285:
286: FORALL i IN 1..loop_count_val
287:
288: UPDATE BOM_EXPLOSION_TEMP BET
289: SET ITEM_COST = l_item_cost(i),
290: BASED_ON_ROLLUP_FLAG = l_rollup(i),
291: SHRINKAGE_RATE = l_shrinkage(i),
292: EXTENDED_QUANTITY = l_extnd_qty(i),

Line 310: UPDATE BOM_EXPLOSION_TEMP BET

306: /* Bug 2566842 */
307:
308: /*
309: FOR counter IN 1..exploded_levels LOOP
310: UPDATE BOM_EXPLOSION_TEMP BET
311: SET (ITEM_COST,
312: BASED_ON_ROLLUP_FLAG,
313: SHRINKAGE_RATE,
314: EXTENDED_QUANTITY,

Line 345: BOM_EXPLOSION_TEMP BET_MUST_HAVE,

341: nvl(CIC.INVENTORY_ASSET_FLAG,
342: nvl(CIC_DEF.INVENTORY_ASSET_FLAG, 2))
343: FROM CST_ITEM_COSTS CIC,
344: CST_ITEM_COSTS CIC_DEF,
345: BOM_EXPLOSION_TEMP BET_MUST_HAVE,
346: BOM_EXPLOSION_TEMP BET1
347: WHERE BET1.GROUP_ID = grp_id
348: AND BET1.TOP_BILL_SEQUENCE_ID = BET.TOP_BILL_SEQUENCE_ID
349: AND BET1.SORT_ORDER =

Line 346: BOM_EXPLOSION_TEMP BET1

342: nvl(CIC_DEF.INVENTORY_ASSET_FLAG, 2))
343: FROM CST_ITEM_COSTS CIC,
344: CST_ITEM_COSTS CIC_DEF,
345: BOM_EXPLOSION_TEMP BET_MUST_HAVE,
346: BOM_EXPLOSION_TEMP BET1
347: WHERE BET1.GROUP_ID = grp_id
348: AND BET1.TOP_BILL_SEQUENCE_ID = BET.TOP_BILL_SEQUENCE_ID
349: AND BET1.SORT_ORDER =
350: SUBSTR(BET.SORT_ORDER, 1, counter*X_SortWidth)