VIEW: PA.PA_EXP_TYPES_IT#

Source

View Text - Preformatted

select EXPENDITURE_TYPE EXPENDITURE_TYPE, ALL_EXPENDITURE_TYPES ALL_EXPENDITURE_TYPES, EXPENDITURE_CATEGORY EXPENDITURE_CATEGORY, REVENUE_CATEGORY_CODE REVENUE_CATEGORY_CODE, UNIT_OF_MEASURE UNIT_OF_MEASURE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, DESCRIPTION DESCRIPTION, USER_COL1 USER_COL1, USER_COL2 USER_COL2, USER_COL3 USER_COL3, USER_COL4 USER_COL4, USER_COL5 USER_COL5, USER_COL6 USER_COL6, USER_COL7 USER_COL7, USER_COL8 USER_COL8, USER_COL9 USER_COL9, USER_COL10 USER_COL10, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, STATUS_CODE STATUS_CODE from "PA"."PA_EXP_TYPES_IT"

View Text - HTML Formatted

SELECT EXPENDITURE_TYPE EXPENDITURE_TYPE
, ALL_EXPENDITURE_TYPES ALL_EXPENDITURE_TYPES
, EXPENDITURE_CATEGORY EXPENDITURE_CATEGORY
, REVENUE_CATEGORY_CODE REVENUE_CATEGORY_CODE
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, DESCRIPTION DESCRIPTION
, USER_COL1 USER_COL1
, USER_COL2 USER_COL2
, USER_COL3 USER_COL3
, USER_COL4 USER_COL4
, USER_COL5 USER_COL5
, USER_COL6 USER_COL6
, USER_COL7 USER_COL7
, USER_COL8 USER_COL8
, USER_COL9 USER_COL9
, USER_COL10 USER_COL10
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, STATUS_CODE STATUS_CODE
FROM "PA"."PA_EXP_TYPES_IT"