|
SELECT A.BUSINESS_UNIT ,A.CM_BOOK ,A.INV_ITEM_ID ,A.COST_ELEMENT ,A.CM_UNIT_COST FROM PS_CM_ACTUAL_COSTB A WHERE A.EFF_STATUS = 'A' AND A.DT_TIMESTAMP = ( SELECT MAX(AA.DT_TIMESTAMP) FROM PS_CM_ACTUAL_COSTB AA WHERE %Join(COMMON_KEYS, CM_ACTUAL_COSTB A, CM_ACTUAL_COSTB AA, PROCESS_INSTANCE, DT_TIMESTAMP) AND AA.DT_TIMESTAMP <= %CurrentDateTimeIn) AND A.CM_SEQ_COST = ( SELECT MAX(BB.CM_SEQ_COST) FROM PS_CM_ACTUAL_COSTB BB WHERE %Join(COMMON_KEYS, CM_ACTUAL_COST A, CM_ACTUAL_COST BB, PROCESS_INSTANCE, DT_TIMESTAMP) AND A.DT_TIMESTAMP = BB.DT_TIMESTAMP) GROUP BY A.BUSINESS_UNIT, A.CM_BOOK, A.INV_ITEM_ID, A.COST_ELEMENT, A.CM_UNIT_COST
|