VIEW: APPS.PA_RESOURCE_LIST_USE_CODES_V

Source

View Text - Preformatted

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))

View Text - HTML Formatted

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))