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 82: BOM_EXPLOSION_TEMP BET_MUST_HAVE,

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

Line 83: BOM_EXPLOSION_TEMP BET1,

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

Line 84: BOM_EXPLOSION_TEMP BET

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

Line 200: UPDATE BOM_EXPLOSION_TEMP BET

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

Line 232: FROM BOM_EXPLOSION_TEMP

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

Line 286: UPDATE BOM_EXPLOSION_TEMP BET

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

Line 308: UPDATE BOM_EXPLOSION_TEMP BET

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

Line 341: BOM_EXPLOSION_TEMP BET_MUST_HAVE,

337: nvl(CIC.INVENTORY_ASSET_FLAG,
338: nvl(CIC_DEF.INVENTORY_ASSET_FLAG, 2))
339: FROM CST_ITEM_COSTS CIC,
340: CST_ITEM_COSTS CIC_DEF,
341: BOM_EXPLOSION_TEMP BET_MUST_HAVE,
342: BOM_EXPLOSION_TEMP BET1
343: WHERE BET1.GROUP_ID = grp_id
344: AND BET1.TOP_BILL_SEQUENCE_ID = BET.TOP_BILL_SEQUENCE_ID
345: AND BET1.SORT_ORDER =

Line 342: BOM_EXPLOSION_TEMP BET1

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