APPS.BOMPCEXP dependencies on CST_COST_TYPES

Line 189: FROM CST_COST_TYPES

185: ** select COMPONENT_YIELD_FLAG
186: */
187: SELECT COMPONENT_YIELD_FLAG
188: INTO l_comp_yield_flag
189: FROM CST_COST_TYPES
190: WHERE COST_TYPE_ID = cst_type_id;
191:
192: /*
193: ** for non-inquiry calls use the bigger temp table

Line 207: INDEX (CCT,CST_COST_TYPES_U1)

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),
211: DECODE(CIC.INVENTORY_ASSET_FLAG, 2, 2,

Line 217: CST_COST_TYPES CCT

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
221: (SELECT 'X' FROM CST_ITEM_COSTS CIC2

Line 239: FROM cst_cost_types

235: WHERE GROUP_ID = grp_id;
236:
237: SELECT DEFAULT_COST_TYPE_ID
238: INTO l_default_cost_type_id
239: FROM cst_cost_types
240: WHERE COST_TYPE_ID = cst_type_id;
241:
242: /* Bug 2566842 */
243:

Line 378: INDEX (CCT,CST_COST_TYPES_U1)

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),
382: DECODE(CIC.INVENTORY_ASSET_FLAG, 2, 2,

Line 388: CST_COST_TYPES CCT

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
392: (SELECT 'X' FROM CST_ITEM_COSTS CIC2