View: PA_PMC_RESOURCE_LIST_V

Product:	PA - Projects
Description:	This view is being used by WebConnect to retrieve all the resource lists.
Implementation/DBA Data:	APPS.PA_PMC_RESOURCE_LIST_V

View Text

SELECT FP_RESOURCE_LIST_ID RESOURCE_LIST_ID
, BG.NAME RESOURCE_LIST_NAME
, FIN_PLAN_TYPE_ID
, 'PLAN_TYPE' FP_TYPE_CODE
, PROJECT_ID
FROM PA_FP_OPTIONS_RESLISTS_V FP
, PA_RESOURCE_LISTS_ALL_BG BG
WHERE FP_RESOURCE_LIST_ID =BG.RESOURCE_LIST_ID UNION ALL SELECT RESOURCE_LIST_ID
, RESOURCE_LIST_NAME
, -1 FIN_PLAN_TYPE_ID
, 'BUDGET_TYPE' FP_TYPE_CODE
, -1 PROJECT_ID
FROM PA_PMC_RESOURCE_LISTS_V

Columns