VIEW: PA.PA_DRAFT_INV_DETS_AR#

Source

View Text - Preformatted

select PURGE_BATCH_ID PURGE_BATCH_ID, ACCT_CURRENCY_CODE ACCT_CURRENCY_CODE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LINE_NUM LINE_NUM, LINE_NUM_REVERSED LINE_NUM_REVERSED, MARKUP_CALC_BASE_CODE MARKUP_CALC_BASE_CODE, ORG_ID ORG_ID, ORIG_DRAFT_INVOICE_LINE_NUM ORIG_DRAFT_INVOICE_LINE_NUM, ORIG_DRAFT_INVOICE_NUM ORIG_DRAFT_INVOICE_NUM, OUTPUT_TAX_EXEMPT_FLAG OUTPUT_TAX_EXEMPT_FLAG, OUTPUT_TAX_EXEMPT_NUMBER OUTPUT_TAX_EXEMPT_NUMBER, OUTPUT_TAX_EXEMPT_REASON_CODE OUTPUT_TAX_EXEMPT_REASON_CODE, OUTPUT_VAT_TAX_ID OUTPUT_VAT_TAX_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROJACCT_BILL_AMOUNT PROJACCT_BILL_AMOUNT, PROJACCT_COST_AMOUNT PROJACCT_COST_AMOUNT, PROJACCT_CURRENCY_CODE PROJACCT_CURRENCY_CODE, PROJECT_ID PROJECT_ID, PROJECT_TP_CURRENCY_CODE PROJECT_TP_CURRENCY_CODE, PROJECT_TP_RATE_DATE PROJECT_TP_RATE_DATE, PROJECT_TP_RATE_TYPE PROJECT_TP_RATE_TYPE, PROJECT_TRANSFER_PRICE PROJECT_TRANSFER_PRICE, PROJFUNC_TP_CURRENCY_CODE PROJFUNC_TP_CURRENCY_CODE, PROJFUNC_TP_EXCHANGE_RATE PROJFUNC_TP_EXCHANGE_RATE, PROJFUNC_TP_RATE_DATE PROJFUNC_TP_RATE_DATE, PROJFUNC_TP_RATE_TYPE PROJFUNC_TP_RATE_TYPE, PROJFUNC_TRANSFER_PRICE PROJFUNC_TRANSFER_PRICE, PROV_PROJ_BILL_JOB_ID PROV_PROJ_BILL_JOB_ID, PURGE_PROJECT_ID PURGE_PROJECT_ID, PURGE_RELEASE PURGE_RELEASE, REQUEST_ID REQUEST_ID, REVERSED_FLAG REVERSED_FLAG, REV_CODE_COMBINATION_ID REV_CODE_COMBINATION_ID, RULE_PERCENTAGE RULE_PERCENTAGE, SCHEDULE_LINE_PERCENTAGE SCHEDULE_LINE_PERCENTAGE, TP_AMT_TYPE_CODE TP_AMT_TYPE_CODE, TP_JOB_ID TP_JOB_ID, ACCT_EXCHANGE_RATE ACCT_EXCHANGE_RATE, ACCT_RATE_DATE ACCT_RATE_DATE, ACCT_RATE_TYPE ACCT_RATE_TYPE, BASE_AMOUNT BASE_AMOUNT, BILL_AMOUNT BILL_AMOUNT, BILL_MARKUP_PERCENTAGE BILL_MARKUP_PERCENTAGE, BILL_RATE BILL_RATE, CC_PROJECT_ID CC_PROJECT_ID, CC_TAX_TASK_ID CC_TAX_TASK_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, DENOM_BILL_AMOUNT DENOM_BILL_AMOUNT, DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE, DETAIL_ID_REVERSED DETAIL_ID_REVERSED, DRAFT_INVOICE_DETAIL_ID DRAFT_INVOICE_DETAIL_ID, DRAFT_INVOICE_LINE_NUM DRAFT_INVOICE_LINE_NUM, DRAFT_INVOICE_NUM DRAFT_INVOICE_NUM, EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID, IND_COMPILED_SET_ID IND_COMPILED_SET_ID, INVOICED_FLAG INVOICED_FLAG, LAST_UPDATED_BY LAST_UPDATED_BY, PROJECT_TP_EXCHANGE_RATE PROJECT_TP_EXCHANGE_RATE, OUTPUT_TAX_CLASSIFICATION_CODE OUTPUT_TAX_CLASSIFICATION_CODE from "PA"."PA_DRAFT_INV_DETS_AR"

View Text - HTML Formatted

SELECT PURGE_BATCH_ID PURGE_BATCH_ID
, ACCT_CURRENCY_CODE ACCT_CURRENCY_CODE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LINE_NUM LINE_NUM
, LINE_NUM_REVERSED LINE_NUM_REVERSED
, MARKUP_CALC_BASE_CODE MARKUP_CALC_BASE_CODE
, ORG_ID ORG_ID
, ORIG_DRAFT_INVOICE_LINE_NUM ORIG_DRAFT_INVOICE_LINE_NUM
, ORIG_DRAFT_INVOICE_NUM ORIG_DRAFT_INVOICE_NUM
, OUTPUT_TAX_EXEMPT_FLAG OUTPUT_TAX_EXEMPT_FLAG
, OUTPUT_TAX_EXEMPT_NUMBER OUTPUT_TAX_EXEMPT_NUMBER
, OUTPUT_TAX_EXEMPT_REASON_CODE OUTPUT_TAX_EXEMPT_REASON_CODE
, OUTPUT_VAT_TAX_ID OUTPUT_VAT_TAX_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROJACCT_BILL_AMOUNT PROJACCT_BILL_AMOUNT
, PROJACCT_COST_AMOUNT PROJACCT_COST_AMOUNT
, PROJACCT_CURRENCY_CODE PROJACCT_CURRENCY_CODE
, PROJECT_ID PROJECT_ID
, PROJECT_TP_CURRENCY_CODE PROJECT_TP_CURRENCY_CODE
, PROJECT_TP_RATE_DATE PROJECT_TP_RATE_DATE
, PROJECT_TP_RATE_TYPE PROJECT_TP_RATE_TYPE
, PROJECT_TRANSFER_PRICE PROJECT_TRANSFER_PRICE
, PROJFUNC_TP_CURRENCY_CODE PROJFUNC_TP_CURRENCY_CODE
, PROJFUNC_TP_EXCHANGE_RATE PROJFUNC_TP_EXCHANGE_RATE
, PROJFUNC_TP_RATE_DATE PROJFUNC_TP_RATE_DATE
, PROJFUNC_TP_RATE_TYPE PROJFUNC_TP_RATE_TYPE
, PROJFUNC_TRANSFER_PRICE PROJFUNC_TRANSFER_PRICE
, PROV_PROJ_BILL_JOB_ID PROV_PROJ_BILL_JOB_ID
, PURGE_PROJECT_ID PURGE_PROJECT_ID
, PURGE_RELEASE PURGE_RELEASE
, REQUEST_ID REQUEST_ID
, REVERSED_FLAG REVERSED_FLAG
, REV_CODE_COMBINATION_ID REV_CODE_COMBINATION_ID
, RULE_PERCENTAGE RULE_PERCENTAGE
, SCHEDULE_LINE_PERCENTAGE SCHEDULE_LINE_PERCENTAGE
, TP_AMT_TYPE_CODE TP_AMT_TYPE_CODE
, TP_JOB_ID TP_JOB_ID
, ACCT_EXCHANGE_RATE ACCT_EXCHANGE_RATE
, ACCT_RATE_DATE ACCT_RATE_DATE
, ACCT_RATE_TYPE ACCT_RATE_TYPE
, BASE_AMOUNT BASE_AMOUNT
, BILL_AMOUNT BILL_AMOUNT
, BILL_MARKUP_PERCENTAGE BILL_MARKUP_PERCENTAGE
, BILL_RATE BILL_RATE
, CC_PROJECT_ID CC_PROJECT_ID
, CC_TAX_TASK_ID CC_TAX_TASK_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, DENOM_BILL_AMOUNT DENOM_BILL_AMOUNT
, DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE
, DETAIL_ID_REVERSED DETAIL_ID_REVERSED
, DRAFT_INVOICE_DETAIL_ID DRAFT_INVOICE_DETAIL_ID
, DRAFT_INVOICE_LINE_NUM DRAFT_INVOICE_LINE_NUM
, DRAFT_INVOICE_NUM DRAFT_INVOICE_NUM
, EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID
, IND_COMPILED_SET_ID IND_COMPILED_SET_ID
, INVOICED_FLAG INVOICED_FLAG
, LAST_UPDATED_BY LAST_UPDATED_BY
, PROJECT_TP_EXCHANGE_RATE PROJECT_TP_EXCHANGE_RATE
, OUTPUT_TAX_CLASSIFICATION_CODE OUTPUT_TAX_CLASSIFICATION_CODE
FROM "PA"."PA_DRAFT_INV_DETS_AR"