APPS.EAM_CONSTRUCTION_EST_PVT dependencies on CST_CG_ITEM_COSTS_VIEW

Line 141: FROM CST_CG_ITEM_COSTS_VIEW CCICV,

137:
138: SELECT ROUND(SUM( 1 * -- 1 TO REPRESENT UNIT MAT QUANTITY
139: 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
140: INTO x_unit_mat_value
141: FROM CST_CG_ITEM_COSTS_VIEW CCICV,
142: MTL_SYSTEM_ITEMS_B MSI
143: WHERE CCICV.INVENTORY_ITEM_ID = p_inv_id
144: AND CCICV.ORGANIZATION_ID = p_org_id
145: AND CCICV.COST_GROUP_ID = DECODE(p_cost_method,1,1, p_cost_group_id)