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: PA_ALLOC_RESOURCES_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_ALLOC_RESOURCES_V

View Text

SELECT ASR.ROWID
, ASR.MEMBER_TYPE
, ASR.RULE_ID
, ASR.RESOURCE_LIST_MEMBER_ID
, SUBSTR ( PA_ALLOC_UTILS.RESOURCE_NAME( ASR.MEMBER_TYPE
, ASR.RESOURCE_LIST_MEMBER_ID
, ASR.RULE_ID )
, 1
, 80 )
, ASR.TARGET_EXPND_TYPE
, ASR.OFFSET_EXPND_TYPE
, ASR.RESOURCE_PERCENTAGE
, ASR.EXCLUDE_FLAG
, ASR.CREATED_BY
, ASR.CREATION_DATE
, ASR.LAST_UPDATE_DATE
, ASR.LAST_UPDATED_BY
, ASR.LAST_UPDATE_LOGIN FROM PA_ALLOC_RESOURCES ASR

Columns

Name
ROW_ID
MEMBER_TYPE
RULE_ID
RESOURCE_LIST_MEMBER_ID
RESOURCE_NAME
TARGET_EXPND_TYPE
OFFSET_EXPND_TYPE
RESOURCE_PERCENTAGE
EXCLUDE_FLAG
CREATED_BY
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN