eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PAY_COST_ALLOCATIONS_D

Source

View Text - Preformatted


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

View Text - HTML Formatted

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