APPS.EAM_CONSTRUCTION_EST_PVT dependencies on CST_CG_ITEM_COSTS_VIEW

Line 146: FROM CST_CG_ITEM_COSTS_VIEW CCICV,

142:
143: SELECT ROUND(SUM( 1 * -- 1 TO REPRESENT UNIT MAT QUANTITY
144: DECODE(MSI.EAM_ITEM_TYPE, 3,DECODE(NULL,'Y',0, NVL(CCICV.ITEM_COST,0)), NVL(CCICV.ITEM_COST,0))), p_ext_precision) MAT_VALUE
145: INTO x_unit_mat_value
146: FROM CST_CG_ITEM_COSTS_VIEW CCICV,
147: MTL_SYSTEM_ITEMS_B MSI
148: WHERE CCICV.INVENTORY_ITEM_ID = p_inv_id
149: AND CCICV.ORGANIZATION_ID = p_org_id
150: AND CCICV.COST_GROUP_ID = DECODE(p_cost_method,1,1, p_cost_group_id)