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_RESOURCE_LIST_USES_V

Product:	PA - Projects
Description:	10Sc Only
Implementation/DBA Data:	APPS.PA_RESOURCE_LIST_USES_V

View Text

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

Columns

Name
ROW_ID
RESOURCE_LIST_ASSIGNMENT_ID
RESOURCE_LIST_ID
RESOURCE_LIST_NAME
PROJECT_ID
USE_CODE
USE_CODE_NAME
BUDGET_TYPE_YN
DEFAULT_FLAG
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN