Product: | PA - Projects |
---|---|
Description: | 10Sc Only |
Implementation/DBA Data: | APPS.PA_RESOURCE_LIST_USES_V |
SELECT PAU.ROWID
, PAU.RESOURCE_LIST_ASSIGNMENT_ID
, PA.RESOURCE_LIST_ID
, RL.NAME
, PA.PROJECT_ID
, PAU.USE_CODE
, PARL.LIST_USE_NAME
, PARL.BUDGET_TYPE_YN
, PAU.DEFAULT_FLAG
, PAU.LAST_UPDATE_DATE
, PAU.LAST_UPDATED_BY
, PAU.CREATION_DATE
, PAU.CREATED_BY
, PAU.LAST_UPDATE_LOGIN
FROM PA_RESOURCE_LIST_USES PAU
, PA_RESOURCE_LIST_ASSIGNMENTS PA
, PA_RESOURCE_LISTS RL
, PA_RESOURCE_LIST_USE_CODES_V PARL
WHERE PA.RESOURCE_LIST_ASSIGNMENT_ID = PAU.RESOURCE_LIST_ASSIGNMENT_ID
AND RL.RESOURCE_LIST_ID = PA.RESOURCE_LIST_ID
AND PAU.USE_CODE = PARL.LIST_USE_CODE