|
SELECT A.BUSINESS_UNIT ,A.CM_BOOK ,A.INV_ITEM_ID , A.COST_ELEMENT ,A.CM_UNIT_COST FROM PS_CM_PERRAVG_COST A WHERE A.CM_DUMMY_FLG = 'N' AND A.DT_TIMESTAMP = ( SELECT MAX(AA.DT_TIMESTAMP) FROM PS_CM_PERRAVG_COST AA WHERE %Join(COMMON_KEYS, CM_PERRAVG_COST A, CM_PERRAVG_COST AA, PROCESS_INSTANCE, DT_TIMESTAMP) AND AA.DT_TIMESTAMP <= %CurrentDateTimeIn ) AND A.CM_SEQ_COST = ( SELECT MAX(BB.CM_SEQ_COST) FROM PS_CM_PERRAVG_COST BB WHERE %Join(COMMON_KEYS, CM_PERRAVG_COST A, CM_PERRAVG_COST BB, PROCESS_INSTANCE, DT_TIMESTAMP) AND A.DT_TIMESTAMP = BB.DT_TIMESTAMP)
|