APPS.BOMPCEXP dependencies on BOM_SMALL_EXPL_TEMP

Line 131: BOM_SMALL_EXPL_TEMP BET_MUST_HAVE,

127: BET.ROWID
128: FROM
129: CST_ITEM_COSTS CIC,
130: CST_ITEM_COSTS CIC_DEF,
131: BOM_SMALL_EXPL_TEMP BET_MUST_HAVE,
132: BOM_SMALL_EXPL_TEMP BET1,
133: BOM_SMALL_EXPL_TEMP BET
134: WHERE BET1.GROUP_ID = c_grp_id
135: AND BET1.TOP_BILL_SEQUENCE_ID = BET.TOP_BILL_SEQUENCE_ID

Line 132: BOM_SMALL_EXPL_TEMP BET1,

128: FROM
129: CST_ITEM_COSTS CIC,
130: CST_ITEM_COSTS CIC_DEF,
131: BOM_SMALL_EXPL_TEMP BET_MUST_HAVE,
132: BOM_SMALL_EXPL_TEMP BET1,
133: BOM_SMALL_EXPL_TEMP BET
134: WHERE BET1.GROUP_ID = c_grp_id
135: AND BET1.TOP_BILL_SEQUENCE_ID = BET.TOP_BILL_SEQUENCE_ID
136: AND BET1.SORT_ORDER = SUBSTR(BET.SORT_ORDER, 1, c_counter*c_X_SortWidth)

Line 133: BOM_SMALL_EXPL_TEMP BET

129: CST_ITEM_COSTS CIC,
130: CST_ITEM_COSTS CIC_DEF,
131: BOM_SMALL_EXPL_TEMP BET_MUST_HAVE,
132: BOM_SMALL_EXPL_TEMP BET1,
133: BOM_SMALL_EXPL_TEMP BET
134: WHERE BET1.GROUP_ID = c_grp_id
135: AND BET1.TOP_BILL_SEQUENCE_ID = BET.TOP_BILL_SEQUENCE_ID
136: AND BET1.SORT_ORDER = SUBSTR(BET.SORT_ORDER, 1, c_counter*c_X_SortWidth)
137: AND BET_MUST_HAVE.ROWID = BET.ROWID

Line 369: UPDATE BOM_SMALL_EXPL_TEMP BET

365:
366: */
367: else
368:
369: UPDATE BOM_SMALL_EXPL_TEMP BET
370: SET (ITEM_COST, BASED_ON_ROLLUP_FLAG, EXTEND_COST_FLAG,
371: ACTUAL_COST_TYPE_ID, SHRINKAGE_RATE, INVENTORY_ASSET_FLAG) =
372: (SELECT /*+ ORDERED
373: INDEX (CIC,CST_ITEM_COSTS_U1)

Line 401: FROM BOM_SMALL_EXPL_TEMP

397: AND PLAN_LEVEL = 0;
398:
399: SELECT nvl(MAX(PLAN_LEVEL), 0)
400: INTO exploded_levels
401: FROM BOM_SMALL_EXPL_TEMP
402: WHERE GROUP_ID = grp_id;
403: /*
404: FOR counter IN 1..exploded_levels LOOP
405: UPDATE BOM_SMALL_EXPL_TEMP BET

Line 405: UPDATE BOM_SMALL_EXPL_TEMP BET

401: FROM BOM_SMALL_EXPL_TEMP
402: WHERE GROUP_ID = grp_id;
403: /*
404: FOR counter IN 1..exploded_levels LOOP
405: UPDATE BOM_SMALL_EXPL_TEMP BET
406: SET (ITEM_COST,
407: BASED_ON_ROLLUP_FLAG,
408: SHRINKAGE_RATE,
409: EXTENDED_QUANTITY,

Line 438: BOM_SMALL_EXPL_TEMP BET_MUST_HAVE,

434: nvl(CIC.INVENTORY_ASSET_FLAG,
435: nvl(CIC_DEF.INVENTORY_ASSET_FLAG, 2))
436: FROM CST_ITEM_COSTS CIC,
437: CST_ITEM_COSTS CIC_DEF,
438: BOM_SMALL_EXPL_TEMP BET_MUST_HAVE,
439: BOM_SMALL_EXPL_TEMP BET1
440: WHERE BET1.GROUP_ID = grp_id
441: AND BET1.TOP_BILL_SEQUENCE_ID = BET.TOP_BILL_SEQUENCE_ID
442: AND BET1.SORT_ORDER =

Line 439: BOM_SMALL_EXPL_TEMP BET1

435: nvl(CIC_DEF.INVENTORY_ASSET_FLAG, 2))
436: FROM CST_ITEM_COSTS CIC,
437: CST_ITEM_COSTS CIC_DEF,
438: BOM_SMALL_EXPL_TEMP BET_MUST_HAVE,
439: BOM_SMALL_EXPL_TEMP BET1
440: WHERE BET1.GROUP_ID = grp_id
441: AND BET1.TOP_BILL_SEQUENCE_ID = BET.TOP_BILL_SEQUENCE_ID
442: AND BET1.SORT_ORDER =
443: SUBSTR(BET.SORT_ORDER, 1, counter*X_SortWidth)

Line 505: UPDATE BOM_SMALL_EXPL_TEMP BET SET

501: CLOSE Explosion_small;
502:
503: FORALL i IN 1..loop_count_val
504:
505: UPDATE BOM_SMALL_EXPL_TEMP BET SET
506: ITEM_COST = l_item_cost(i),
507: BASED_ON_ROLLUP_FLAG = l_rollup(i),
508: SHRINKAGE_RATE = l_shrinkage(i),
509: EXTENDED_QUANTITY = l_extnd_qty(i),