View: PA_BUDG_CONTROL_RES_GRP_V

Product:	PA - Projects
Description:	Base View for Budgetary Controls Form - Resource Group and Resource Block
Implementation/DBA Data:	APPS.PA_BUDG_CONTROL_RES_GRP_V

View Text

SELECT PABC.ROWID
, PABC.PROJECT_ID
, PABC.TASK_ID
, PABC.BUDGETARY_CONTROLS_ID
, PABC.FUNDS_CONTROL_LEVEL_CODE
, PARLM.RESOURCE_LIST_ID
, PABC.RESOURCE_LIST_MEMBER_ID
, PARLM.ALIAS
, PARLM.RESOURCE_ID
, PR.NAME
, PABC.LAST_UPDATED_BY
, PABC.LAST_UPDATE_DATE
, PABC.CREATED_BY
, PABC.CREATION_DATE
, PABC.LAST_UPDATE_LOGIN
, PABC.PARENT_MEMBER_ID
, PABC.BUDGET_TYPE_CODE
, NVL(PARL.GROUP_RESOURCE_TYPE_ID
, 0)
FROM PA_RESOURCE_LISTS PARL
, PA_RESOURCE_LIST_MEMBERS PARLM
, PA_RESOURCES PR
, PA_BUDGETARY_CONTROLS PABC
WHERE PARL.RESOURCE_LIST_ID = PARLM.RESOURCE_LIST_ID
AND PARLM.RESOURCE_ID = PR.RESOURCE_ID
AND PARLM.RESOURCE_LIST_MEMBER_ID = PABC.RESOURCE_LIST_MEMBER_ID
AND NVL(PARL.MIGRATION_CODE
, 'M') = 'M'
AND NVL(PARLM.MIGRATION_CODE
, 'M') = 'M'

Columns