VIEW: PA.PA_MC_CC_DIST_LINES_AR#

Source

View Text - Preformatted

select PURGE_BATCH_ID PURGE_BATCH_ID, PURGE_RELEASE PURGE_RELEASE, PURGE_PROJECT_ID PURGE_PROJECT_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, PRC_ASSIGNMENT_ID PRC_ASSIGNMENT_ID, CC_DIST_LINE_ID CC_DIST_LINE_ID, EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID, LINE_NUM LINE_NUM, LINE_TYPE LINE_TYPE, ACCT_CURRENCY_CODE ACCT_CURRENCY_CODE, AMOUNT AMOUNT, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, TRANSFER_STATUS_CODE TRANSFER_STATUS_CODE, ACCT_TP_RATE_TYPE ACCT_TP_RATE_TYPE, ACCT_TP_RATE_DATE ACCT_TP_RATE_DATE, ACCT_TP_EXCHANGE_RATE ACCT_TP_EXCHANGE_RATE, GL_BATCH_NAME GL_BATCH_NAME, TRANSFERRED_DATE TRANSFERRED_DATE, TRANSFER_REJECTION_CODE TRANSFER_REJECTION_CODE from "PA"."PA_MC_CC_DIST_LINES_AR"

View Text - HTML Formatted

SELECT PURGE_BATCH_ID PURGE_BATCH_ID
, PURGE_RELEASE PURGE_RELEASE
, PURGE_PROJECT_ID PURGE_PROJECT_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, PRC_ASSIGNMENT_ID PRC_ASSIGNMENT_ID
, CC_DIST_LINE_ID CC_DIST_LINE_ID
, EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID
, LINE_NUM LINE_NUM
, LINE_TYPE LINE_TYPE
, ACCT_CURRENCY_CODE ACCT_CURRENCY_CODE
, AMOUNT AMOUNT
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, TRANSFER_STATUS_CODE TRANSFER_STATUS_CODE
, ACCT_TP_RATE_TYPE ACCT_TP_RATE_TYPE
, ACCT_TP_RATE_DATE ACCT_TP_RATE_DATE
, ACCT_TP_EXCHANGE_RATE ACCT_TP_EXCHANGE_RATE
, GL_BATCH_NAME GL_BATCH_NAME
, TRANSFERRED_DATE TRANSFERRED_DATE
, TRANSFER_REJECTION_CODE TRANSFER_REJECTION_CODE
FROM "PA"."PA_MC_CC_DIST_LINES_AR"