VIEW: PA.PA_MC_CUST_RDL_ALL#

Source

View Text - Preformatted

select SET_OF_BOOKS_ID SET_OF_BOOKS_ID, EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID, LINE_NUM LINE_NUM, AMOUNT AMOUNT, BILL_AMOUNT BILL_AMOUNT, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, BATCH_NAME BATCH_NAME, RAW_COST RAW_COST, PROJECT_ID PROJECT_ID, DRAFT_REVENUE_NUM DRAFT_REVENUE_NUM, DRAFT_REVENUE_ITEM_LINE_NUM DRAFT_REVENUE_ITEM_LINE_NUM, DRAFT_INVOICE_NUM DRAFT_INVOICE_NUM, DRAFT_INVOICE_ITEM_LINE_NUM DRAFT_INVOICE_ITEM_LINE_NUM, CURRENCY_CODE CURRENCY_CODE, EXCHANGE_RATE EXCHANGE_RATE, CONVERSION_DATE CONVERSION_DATE, PRC_ASSIGNMENT_ID PRC_ASSIGNMENT_ID, RATE_TYPE RATE_TYPE, PROJFUNC_INV_RATE_TYPE PROJFUNC_INV_RATE_TYPE, PROJFUNC_INV_RATE_DATE PROJFUNC_INV_RATE_DATE, PROJFUNC_INV_EXCHANGE_RATE PROJFUNC_INV_EXCHANGE_RATE from "PA"."PA_MC_CUST_RDL_ALL"

View Text - HTML Formatted

SELECT SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID
, LINE_NUM LINE_NUM
, AMOUNT AMOUNT
, BILL_AMOUNT BILL_AMOUNT
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, BATCH_NAME BATCH_NAME
, RAW_COST RAW_COST
, PROJECT_ID PROJECT_ID
, DRAFT_REVENUE_NUM DRAFT_REVENUE_NUM
, DRAFT_REVENUE_ITEM_LINE_NUM DRAFT_REVENUE_ITEM_LINE_NUM
, DRAFT_INVOICE_NUM DRAFT_INVOICE_NUM
, DRAFT_INVOICE_ITEM_LINE_NUM DRAFT_INVOICE_ITEM_LINE_NUM
, CURRENCY_CODE CURRENCY_CODE
, EXCHANGE_RATE EXCHANGE_RATE
, CONVERSION_DATE CONVERSION_DATE
, PRC_ASSIGNMENT_ID PRC_ASSIGNMENT_ID
, RATE_TYPE RATE_TYPE
, PROJFUNC_INV_RATE_TYPE PROJFUNC_INV_RATE_TYPE
, PROJFUNC_INV_RATE_DATE PROJFUNC_INV_RATE_DATE
, PROJFUNC_INV_EXCHANGE_RATE PROJFUNC_INV_EXCHANGE_RATE
FROM "PA"."PA_MC_CUST_RDL_ALL"