error while compiling the invalid objects
HI ALL
when i'm comiling the invalid objects in the database i'm getting the following error:
Failed to compile: ORA-00979: not a GROUP BY expression
invalid object: APPS.CST_LAYER_ACTUAL_COST_DTLS_V
object query:
SELECT CLACD.TRANSACTION_ID, CLACD.ORGANIZATION_ID, CLACD.LAYER_ID, CLACD.INV_LAYER_ID, CLACD.LAYER_QUANTITY, CLACD.TRANSACTION_SOURCE_TYPE_NAME, CLACD.TRANSACTION_SOURCE_TYPE_ID, CLACD.MATERIAL_COST, CLACD.MATERIAL_OVERHEAD_COST, CLACD.RESOURCE_COST, CLACD.OUTSIDE_PROCESSING_COST, CLACD.OVERHEAD_COST, CLACD.TOTAL_UNIT_COST, CLACD.TRANSACTION_SOURCE_ID, CLACD.TRANSACTION_SOURCE_NAME FROM ( SELECT MCLACD.TRANSACTION_ID , MCLACD.ORGANIZATION_ID , MCLACD.LAYER_ID , MCLACD.INV_LAYER_ID , MCLACD.LAYER_QUANTITY , MTST.TRANSACTION_SOURCE_TYPE_NAME , CIL.TRANSACTION_SOURCE_TYPE_ID , SUM(DECODE(MCLACD.COST_ELEMENT_ID , 1 , NVL(DECODE(MMT.TRANSACTION_ACTION_ID,24,MCLACD.ACTUAL_COST,MCLACD.LAYER_COST) , 0) , 0)) MATERIAL_COST , SUM(DECODE(MCLACD.COST_ELEMENT_ID , 2 , NVL(DECODE(MMT.TRANSACTION_ACTION_ID,24,MCLACD.ACTUAL_COST,MCLACD.LAYER_COST) , 0) , 0)) MATERIAL_OVERHEAD_COST , SUM(DECODE(MCLACD.COST_ELEMENT_ID , 3 , NVL(DECODE(MMT.TRANSACTION_ACTION_ID,24,MCLACD.ACTUAL_COST,MCLACD.LAYER_COST) , 0) , 0)) RESOURCE_COST , SUM(DECODE(MCLACD.COST_ELEMENT_ID , 4 , NVL(DECODE(MMT.TRANSACTION_ACTION_ID,24,MCLACD.ACTUAL_COST,MCLACD.LAYER_COST) , 0) , 0)) OUTSIDE_PROCESSING_COST , SUM(DECODE(MCLACD.COST_ELEMENT_ID , 5 , NVL(DECODE(MMT.TRANSACTION_ACTION_ID,24,MCLACD.ACTUAL_COST,MCLACD.LAYER_COST) , 0) , 0)) OVERHEAD_COST , SUM(NVL(DECODE(MMT.TRANSACTION_ACTION_ID,24,MCLACD.ACTUAL_COST,MCLACD.LAYER_COST) , 0)) TOTAL_UNIT_COST , CIL.TRANSACTION_SOURCE_ID , CIL.TRANSACTION_SOURCE TRANSACTION_SOURCE_NAME , MMT.TRANSACTION_ACTION_ID FROM