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 80: FROM CST_ITEM_COSTS CIC,

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

Line 81: CST_ITEM_COSTS CIC_DEF,

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

Line 129: CST_ITEM_COSTS CIC,

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

Line 130: CST_ITEM_COSTS CIC_DEF,

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

Line 204: INDEX (CIC,CST_ITEM_COSTS_U1)

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

Line 214: FROM CST_ITEM_COSTS CIC,

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

Line 219: (SELECT 'X' FROM CST_ITEM_COSTS CIC2

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

Line 339: FROM CST_ITEM_COSTS CIC,

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

Line 340: CST_ITEM_COSTS CIC_DEF,

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

Line 373: INDEX (CIC,CST_ITEM_COSTS_U1)

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)
374: INDEX (CCT,CST_COST_TYPES_U1)
375: USE_NL (CIC CCT) */
376: nvl(CIC.ITEM_COST,0),
377: nvl(CIC.BASED_ON_ROLLUP_FLAG, 2),

Line 383: FROM CST_ITEM_COSTS CIC,

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

Line 388: (SELECT 'X' FROM CST_ITEM_COSTS CIC2

384: CST_COST_TYPES CCT
385: Where CIC.ORGANIZATION_ID=NVL(CCT.ORGANIZATION_ID,CIC.ORGANIZATION_ID)
386: AND (((CIC.COST_TYPE_ID = CCT.DEFAULT_COST_TYPE_ID)
387: AND (NOT EXISTS
388: (SELECT 'X' FROM CST_ITEM_COSTS CIC2
389: WHERE CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
390: AND CIC2.ORGANIZATION_ID = CIC.ORGANIZATION_ID
391: AND CIC2.COST_TYPE_ID = CCT.COST_TYPE_ID)))
392: OR (CIC.COST_TYPE_ID = CCT.COST_TYPE_ID))

Line 436: FROM CST_ITEM_COSTS CIC,

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

Line 437: CST_ITEM_COSTS CIC_DEF,

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