Product: | PA - Projects |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PA_ALLOC_RESOURCES_V |
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