APPS.BOMPCEXP dependencies on CST_COST_TYPES

Line 187: FROM CST_COST_TYPES

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

Line 205: INDEX (CCT,CST_COST_TYPES_U1)

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

Line 215: CST_COST_TYPES CCT

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

Line 237: FROM cst_cost_types

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

Line 374: INDEX (CCT,CST_COST_TYPES_U1)

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

Line 384: CST_COST_TYPES CCT

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