VIEW: PA.PA_EXPENDITURES_AR#

Source

View Text - Preformatted

select PURGE_BATCH_ID PURGE_BATCH_ID, PURGE_RELEASE PURGE_RELEASE, PURGE_PROJECT_ID PURGE_PROJECT_ID, REQUEST_ID REQUEST_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, PTE_REFERENCE PTE_REFERENCE, ORG_ID ORG_ID, EXPENDITURE_ID EXPENDITURE_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, EXPENDITURE_STATUS_CODE EXPENDITURE_STATUS_CODE, EXPENDITURE_ENDING_DATE EXPENDITURE_ENDING_DATE, EXPENDITURE_CLASS_CODE EXPENDITURE_CLASS_CODE, INCURRED_BY_PERSON_ID INCURRED_BY_PERSON_ID, INCURRED_BY_ORGANIZATION_ID INCURRED_BY_ORGANIZATION_ID, EXPENDITURE_GROUP EXPENDITURE_GROUP, CONTROL_TOTAL_AMOUNT CONTROL_TOTAL_AMOUNT, ENTERED_BY_PERSON_ID ENTERED_BY_PERSON_ID, DESCRIPTION DESCRIPTION, INITIAL_SUBMISSION_DATE INITIAL_SUBMISSION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE, ACCT_CURRENCY_CODE ACCT_CURRENCY_CODE, ACCT_RATE_DATE ACCT_RATE_DATE, ACCT_RATE_TYPE ACCT_RATE_TYPE, ACCT_EXCHANGE_RATE ACCT_EXCHANGE_RATE, ORIG_EXP_TXN_REFERENCE1 ORIG_EXP_TXN_REFERENCE1, ORIG_EXP_TXN_REFERENCE2 ORIG_EXP_TXN_REFERENCE2, ORIG_EXP_TXN_REFERENCE3 ORIG_EXP_TXN_REFERENCE3, ORIG_USER_EXP_TXN_REFERENCE ORIG_USER_EXP_TXN_REFERENCE, VENDOR_ID VENDOR_ID, OVERRIDING_APPROVER_PERSON_ID OVERRIDING_APPROVER_PERSON_ID, WF_STATUS_CODE WF_STATUS_CODE, TRANSFER_STATUS_CODE TRANSFER_STATUS_CODE, USER_BATCH_NAME USER_BATCH_NAME, PERSON_TYPE PERSON_TYPE from "PA"."PA_EXPENDITURES_AR"

View Text - HTML Formatted

SELECT PURGE_BATCH_ID PURGE_BATCH_ID
, PURGE_RELEASE PURGE_RELEASE
, PURGE_PROJECT_ID PURGE_PROJECT_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, PTE_REFERENCE PTE_REFERENCE
, ORG_ID ORG_ID
, EXPENDITURE_ID EXPENDITURE_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, EXPENDITURE_STATUS_CODE EXPENDITURE_STATUS_CODE
, EXPENDITURE_ENDING_DATE EXPENDITURE_ENDING_DATE
, EXPENDITURE_CLASS_CODE EXPENDITURE_CLASS_CODE
, INCURRED_BY_PERSON_ID INCURRED_BY_PERSON_ID
, INCURRED_BY_ORGANIZATION_ID INCURRED_BY_ORGANIZATION_ID
, EXPENDITURE_GROUP EXPENDITURE_GROUP
, CONTROL_TOTAL_AMOUNT CONTROL_TOTAL_AMOUNT
, ENTERED_BY_PERSON_ID ENTERED_BY_PERSON_ID
, DESCRIPTION DESCRIPTION
, INITIAL_SUBMISSION_DATE INITIAL_SUBMISSION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE
, ACCT_CURRENCY_CODE ACCT_CURRENCY_CODE
, ACCT_RATE_DATE ACCT_RATE_DATE
, ACCT_RATE_TYPE ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE ACCT_EXCHANGE_RATE
, ORIG_EXP_TXN_REFERENCE1 ORIG_EXP_TXN_REFERENCE1
, ORIG_EXP_TXN_REFERENCE2 ORIG_EXP_TXN_REFERENCE2
, ORIG_EXP_TXN_REFERENCE3 ORIG_EXP_TXN_REFERENCE3
, ORIG_USER_EXP_TXN_REFERENCE ORIG_USER_EXP_TXN_REFERENCE
, VENDOR_ID VENDOR_ID
, OVERRIDING_APPROVER_PERSON_ID OVERRIDING_APPROVER_PERSON_ID
, WF_STATUS_CODE WF_STATUS_CODE
, TRANSFER_STATUS_CODE TRANSFER_STATUS_CODE
, USER_BATCH_NAME USER_BATCH_NAME
, PERSON_TYPE PERSON_TYPE
FROM "PA"."PA_EXPENDITURES_AR"