View: PA_RESOURCE_LIST_USE_CODES_V

Product:	PA - Projects
Description:	View of resource list uses
Implementation/DBA Data:	APPS.PA_RESOURCE_LIST_USE_CODES_V

View Text

SELECT BUDGET_TYPE_CODE
, BUDGET_TYPE
, 'Y'
FROM PA_BUDGET_TYPES
WHERE TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE)) UNION ALL SELECT LOOKUP_CODE
, MEANING
, 'N'
FROM PA_LOOKUPS
WHERE LOOKUP_TYPE = 'RESOURCE_LIST_USES'
AND TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE)) UNION ALL SELECT TO_CHAR(FIN_PLAN_TYPE_ID)
, NAME
, 'Y'
FROM PA_FIN_PLAN_TYPES_VL
WHERE TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE))

Columns