VIEW: APPS.PA_EXPENDITURE_TYPES_RES_V

Source

View Text - Preformatted

SELECT EXPT.EXPENDITURE_TYPE , EXPT.DESCRIPTION , EXPT.EXPENDITURE_CATEGORY , EXPT.REVENUE_CATEGORY_CODE , decode ( expsl1.expenditure_type, NULL, 'N', 'Y') , EXPT.UNIT_OF_MEASURE , 'Y' FROM PA_EXPENDITURE_TYPES EXPT, PA_EXPEND_TYP_SYS_LINKS EXPSL1 WHERE EXPSL1.EXPENDITURE_TYPE (+) = EXPT.EXPENDITURE_TYPE AND EXPSL1.SYSTEM_LINKAGE_FUNCTION (+) = 'ST' AND DECODE (PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES, 'Y',EXPT.START_DATE_ACTIVE,TRUNC(SYSDATE)) BETWEEN EXPT.START_DATE_ACTIVE AND NVL(EXPT.END_DATE_ACTIVE,TRUNC(SYSDATE))

View Text - HTML Formatted

SELECT EXPT.EXPENDITURE_TYPE
, EXPT.DESCRIPTION
, EXPT.EXPENDITURE_CATEGORY
, EXPT.REVENUE_CATEGORY_CODE
, DECODE ( EXPSL1.EXPENDITURE_TYPE
, NULL
, 'N'
, 'Y')
, EXPT.UNIT_OF_MEASURE
, 'Y'
FROM PA_EXPENDITURE_TYPES EXPT
, PA_EXPEND_TYP_SYS_LINKS EXPSL1
WHERE EXPSL1.EXPENDITURE_TYPE (+) = EXPT.EXPENDITURE_TYPE
AND EXPSL1.SYSTEM_LINKAGE_FUNCTION (+) = 'ST'
AND DECODE (PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES
, 'Y'
, EXPT.START_DATE_ACTIVE
, TRUNC(SYSDATE)) BETWEEN EXPT.START_DATE_ACTIVE
AND NVL(EXPT.END_DATE_ACTIVE
, TRUNC(SYSDATE))