APPS.BOMPCEXP dependencies on BOM_SMALL_EXPL_TEMP

Line 133: BOM_SMALL_EXPL_TEMP BET_MUST_HAVE,

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

Line 134: BOM_SMALL_EXPL_TEMP BET1,

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

Line 135: BOM_SMALL_EXPL_TEMP BET

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

Line 373: UPDATE BOM_SMALL_EXPL_TEMP BET

369:
370: */
371: else
372:
373: UPDATE BOM_SMALL_EXPL_TEMP BET
374: SET (ITEM_COST, BASED_ON_ROLLUP_FLAG, EXTEND_COST_FLAG,
375: ACTUAL_COST_TYPE_ID, SHRINKAGE_RATE, INVENTORY_ASSET_FLAG) =
376: (SELECT /*+ ORDERED
377: INDEX (CIC,CST_ITEM_COSTS_U1)

Line 405: FROM BOM_SMALL_EXPL_TEMP

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

Line 409: UPDATE BOM_SMALL_EXPL_TEMP BET

405: FROM BOM_SMALL_EXPL_TEMP
406: WHERE GROUP_ID = grp_id;
407: /*
408: FOR counter IN 1..exploded_levels LOOP
409: UPDATE BOM_SMALL_EXPL_TEMP BET
410: SET (ITEM_COST,
411: BASED_ON_ROLLUP_FLAG,
412: SHRINKAGE_RATE,
413: EXTENDED_QUANTITY,

Line 444: BOM_SMALL_EXPL_TEMP BET_MUST_HAVE,

440: nvl(CIC.INVENTORY_ASSET_FLAG,
441: nvl(CIC_DEF.INVENTORY_ASSET_FLAG, 2))
442: FROM CST_ITEM_COSTS CIC,
443: CST_ITEM_COSTS CIC_DEF,
444: BOM_SMALL_EXPL_TEMP BET_MUST_HAVE,
445: BOM_SMALL_EXPL_TEMP BET1
446: WHERE BET1.GROUP_ID = grp_id
447: AND BET1.TOP_BILL_SEQUENCE_ID = BET.TOP_BILL_SEQUENCE_ID
448: AND BET1.SORT_ORDER =

Line 445: BOM_SMALL_EXPL_TEMP BET1

441: nvl(CIC_DEF.INVENTORY_ASSET_FLAG, 2))
442: FROM CST_ITEM_COSTS CIC,
443: CST_ITEM_COSTS CIC_DEF,
444: BOM_SMALL_EXPL_TEMP BET_MUST_HAVE,
445: BOM_SMALL_EXPL_TEMP BET1
446: WHERE BET1.GROUP_ID = grp_id
447: AND BET1.TOP_BILL_SEQUENCE_ID = BET.TOP_BILL_SEQUENCE_ID
448: AND BET1.SORT_ORDER =
449: SUBSTR(BET.SORT_ORDER, 1, counter*X_SortWidth)

Line 511: UPDATE BOM_SMALL_EXPL_TEMP BET SET

507: CLOSE Explosion_small;
508:
509: FORALL i IN 1..loop_count_val
510:
511: UPDATE BOM_SMALL_EXPL_TEMP BET SET
512: ITEM_COST = l_item_cost(i),
513: BASED_ON_ROLLUP_FLAG = l_rollup(i),
514: SHRINKAGE_RATE = l_shrinkage(i),
515: EXTENDED_QUANTITY = l_extnd_qty(i),