[Home] [Help]
View: PAY_COST_ALLOCATIONS_D
View Text
SELECT PCOST.COST_ALLOCATION_ID
, PCOST.EFFECTIVE_START_DATE
, PCOST.EFFECTIVE_END_DATE
, ROUND ((PCOST.PROPORTION *100)
, 2)
, CKEY.CONCATENATED_SEGMENTS
, PCOST.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM PAY_COST_ALLOCATIONS_F PCOST
, PAY_COST_ALLOCATION_KEYFLEX CKEY
, FND_USER FUSER
WHERE PCOST.COST_ALLOCATION_KEYFLEX_ID = CKEY.COST_ALLOCATION_KEYFLEX_ID
AND FUSER.USER_ID (+)= PCOST.LAST_UPDATED_BY
Columns
Name |
COST_ALLOCATION_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
PROPORTION |
COST_CODE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |