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.

[Home] [Help]

View: PAY_COST_ALLOCATIONS_D

Product:	PAY - Payroll
Description:	Used by DateTrack History
Implementation/DBA Data:	APPS.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