eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOMPCEXP dependencies on CST_ITEM_COSTS

Line 82: FROM CST_ITEM_COSTS CIC,

78: nvl(CIC.INVENTORY_ASSET_FLAG,
79: nvl(CIC_DEF.INVENTORY_ASSET_FLAG, 2)),
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

Line 83: CST_ITEM_COSTS CIC_DEF,

79: nvl(CIC_DEF.INVENTORY_ASSET_FLAG, 2)),
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

Line 131: CST_ITEM_COSTS CIC,

127: nvl(CIC.INVENTORY_ASSET_FLAG,nvl(CIC_DEF.INVENTORY_ASSET_FLAG, 2)),
128: BET.TOP_BILL_SEQUENCE_ID,
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

Line 132: CST_ITEM_COSTS CIC_DEF,

128: BET.TOP_BILL_SEQUENCE_ID,
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

Line 206: INDEX (CIC,CST_ITEM_COSTS_U1)

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)
207: INDEX (CCT,CST_COST_TYPES_U1)
208: USE_NL (CIC CCT) */
209: nvl(CIC.ITEM_COST,0),
210: nvl(CIC.BASED_ON_ROLLUP_FLAG, 2),

Line 216: FROM CST_ITEM_COSTS CIC,

212: DECODE(CIC.BASED_ON_ROLLUP_FLAG, 1, 1, 2)),
213: nvl(CIC.COST_TYPE_ID, cst_type_id),
214: nvl(CIC.SHRINKAGE_RATE,0),
215: nvl(CIC.INVENTORY_ASSET_FLAG, 2)
216: FROM CST_ITEM_COSTS CIC,
217: CST_COST_TYPES CCT
218: Where CIC.ORGANIZATION_ID=NVL(CCT.ORGANIZATION_ID,CIC.ORGANIZATION_ID)
219: AND (((CIC.COST_TYPE_ID = CCT.DEFAULT_COST_TYPE_ID)
220: AND (NOT EXISTS

Line 221: (SELECT 'X' FROM CST_ITEM_COSTS CIC2

217: CST_COST_TYPES CCT
218: Where CIC.ORGANIZATION_ID=NVL(CCT.ORGANIZATION_ID,CIC.ORGANIZATION_ID)
219: AND (((CIC.COST_TYPE_ID = CCT.DEFAULT_COST_TYPE_ID)
220: AND (NOT EXISTS
221: (SELECT 'X' FROM CST_ITEM_COSTS CIC2
222: WHERE CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
223: AND CIC2.ORGANIZATION_ID = CIC.ORGANIZATION_ID
224: AND CIC2.COST_TYPE_ID = CCT.COST_TYPE_ID)))
225: OR (CIC.COST_TYPE_ID = CCT.COST_TYPE_ID))

Line 343: FROM CST_ITEM_COSTS CIC,

339: nvl(CIC.COST_TYPE_ID,
340: nvl(CIC_DEF.COST_TYPE_ID, BET1.ACTUAL_COST_TYPE_ID)),
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

Line 344: CST_ITEM_COSTS CIC_DEF,

340: nvl(CIC_DEF.COST_TYPE_ID, BET1.ACTUAL_COST_TYPE_ID)),
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

Line 377: INDEX (CIC,CST_ITEM_COSTS_U1)

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)
378: INDEX (CCT,CST_COST_TYPES_U1)
379: USE_NL (CIC CCT) */
380: nvl(CIC.ITEM_COST,0),
381: nvl(CIC.BASED_ON_ROLLUP_FLAG, 2),

Line 387: FROM CST_ITEM_COSTS CIC,

383: DECODE(CIC.BASED_ON_ROLLUP_FLAG, 1, 1, 2)),
384: nvl(CIC.COST_TYPE_ID, cst_type_id),
385: nvl(CIC.SHRINKAGE_RATE,0),
386: nvl(CIC.INVENTORY_ASSET_FLAG, 2)
387: FROM CST_ITEM_COSTS CIC,
388: CST_COST_TYPES CCT
389: Where CIC.ORGANIZATION_ID=NVL(CCT.ORGANIZATION_ID,CIC.ORGANIZATION_ID)
390: AND (((CIC.COST_TYPE_ID = CCT.DEFAULT_COST_TYPE_ID)
391: AND (NOT EXISTS

Line 392: (SELECT 'X' FROM CST_ITEM_COSTS CIC2

388: CST_COST_TYPES CCT
389: Where CIC.ORGANIZATION_ID=NVL(CCT.ORGANIZATION_ID,CIC.ORGANIZATION_ID)
390: AND (((CIC.COST_TYPE_ID = CCT.DEFAULT_COST_TYPE_ID)
391: AND (NOT EXISTS
392: (SELECT 'X' FROM CST_ITEM_COSTS CIC2
393: WHERE CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
394: AND CIC2.ORGANIZATION_ID = CIC.ORGANIZATION_ID
395: AND CIC2.COST_TYPE_ID = CCT.COST_TYPE_ID)))
396: OR (CIC.COST_TYPE_ID = CCT.COST_TYPE_ID))

Line 442: FROM CST_ITEM_COSTS CIC,

438: nvl(CIC.COST_TYPE_ID,
439: nvl(CIC_DEF.COST_TYPE_ID, BET1.ACTUAL_COST_TYPE_ID)),
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

Line 443: CST_ITEM_COSTS CIC_DEF,

439: nvl(CIC_DEF.COST_TYPE_ID, BET1.ACTUAL_COST_TYPE_ID)),
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