VIEW: PA.PA_CC_DIST_LINES_ALL#

Source

View Text - Preformatted

select CC_DIST_LINE_ID CC_DIST_LINE_ID, EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID, LINE_NUM LINE_NUM, LINE_TYPE LINE_TYPE, CROSS_CHARGE_CODE CROSS_CHARGE_CODE, ACCT_CURRENCY_CODE ACCT_CURRENCY_CODE, AMOUNT AMOUNT, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, REQUEST_ID REQUEST_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ORG_ID ORG_ID, LINE_NUM_REVERSED LINE_NUM_REVERSED, DIST_LINE_ID_REVERSED DIST_LINE_ID_REVERSED, REVERSED_FLAG REVERSED_FLAG, DENOM_TP_CURRENCY_CODE DENOM_TP_CURRENCY_CODE, DENOM_TRANSFER_PRICE DENOM_TRANSFER_PRICE, ACCT_TP_RATE_TYPE ACCT_TP_RATE_TYPE, ACCT_TP_RATE_DATE ACCT_TP_RATE_DATE, ACCT_TP_EXCHANGE_RATE ACCT_TP_EXCHANGE_RATE, DR_CODE_COMBINATION_ID DR_CODE_COMBINATION_ID, CR_CODE_COMBINATION_ID CR_CODE_COMBINATION_ID, PA_DATE PA_DATE, GL_DATE GL_DATE, GL_BATCH_NAME GL_BATCH_NAME, TRANSFER_STATUS_CODE TRANSFER_STATUS_CODE, TRANSFERRED_DATE TRANSFERRED_DATE, TRANSFER_REJECTION_CODE TRANSFER_REJECTION_CODE, MARKUP_CALC_BASE_CODE MARKUP_CALC_BASE_CODE, IND_COMPILED_SET_ID IND_COMPILED_SET_ID, BILL_RATE BILL_RATE, TP_BASE_AMOUNT TP_BASE_AMOUNT, BILL_MARKUP_PERCENTAGE BILL_MARKUP_PERCENTAGE, SCHEDULE_LINE_PERCENTAGE SCHEDULE_LINE_PERCENTAGE, RULE_PERCENTAGE RULE_PERCENTAGE, REFERENCE_1 REFERENCE_1, REFERENCE_2 REFERENCE_2, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REFERENCE_3 REFERENCE_3, TP_JOB_ID TP_JOB_ID, PROJFUNC_TP_EXCHANGE_RATE PROJFUNC_TP_EXCHANGE_RATE, PROJFUNC_TRANSFER_PRICE PROJFUNC_TRANSFER_PRICE, TP_AMT_TYPE_CODE TP_AMT_TYPE_CODE, PROJFUNC_TP_RATE_TYPE PROJFUNC_TP_RATE_TYPE, PROJFUNC_TP_RATE_DATE PROJFUNC_TP_RATE_DATE, GL_PERIOD_NAME GL_PERIOD_NAME, PA_PERIOD_NAME PA_PERIOD_NAME, 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_TP_EXCHANGE_RATE PROJECT_TP_EXCHANGE_RATE, PROJECT_TRANSFER_PRICE PROJECT_TRANSFER_PRICE, PROJFUNC_TP_CURRENCY_CODE PROJFUNC_TP_CURRENCY_CODE, ACCT_EVENT_ID ACCT_EVENT_ID, ACCT_SOURCE_CODE ACCT_SOURCE_CODE from "PA"."PA_CC_DIST_LINES_ALL"

View Text - HTML Formatted

SELECT CC_DIST_LINE_ID CC_DIST_LINE_ID
, EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID
, LINE_NUM LINE_NUM
, LINE_TYPE LINE_TYPE
, CROSS_CHARGE_CODE CROSS_CHARGE_CODE
, ACCT_CURRENCY_CODE ACCT_CURRENCY_CODE
, AMOUNT AMOUNT
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, REQUEST_ID REQUEST_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ORG_ID ORG_ID
, LINE_NUM_REVERSED LINE_NUM_REVERSED
, DIST_LINE_ID_REVERSED DIST_LINE_ID_REVERSED
, REVERSED_FLAG REVERSED_FLAG
, DENOM_TP_CURRENCY_CODE DENOM_TP_CURRENCY_CODE
, DENOM_TRANSFER_PRICE DENOM_TRANSFER_PRICE
, ACCT_TP_RATE_TYPE ACCT_TP_RATE_TYPE
, ACCT_TP_RATE_DATE ACCT_TP_RATE_DATE
, ACCT_TP_EXCHANGE_RATE ACCT_TP_EXCHANGE_RATE
, DR_CODE_COMBINATION_ID DR_CODE_COMBINATION_ID
, CR_CODE_COMBINATION_ID CR_CODE_COMBINATION_ID
, PA_DATE PA_DATE
, GL_DATE GL_DATE
, GL_BATCH_NAME GL_BATCH_NAME
, TRANSFER_STATUS_CODE TRANSFER_STATUS_CODE
, TRANSFERRED_DATE TRANSFERRED_DATE
, TRANSFER_REJECTION_CODE TRANSFER_REJECTION_CODE
, MARKUP_CALC_BASE_CODE MARKUP_CALC_BASE_CODE
, IND_COMPILED_SET_ID IND_COMPILED_SET_ID
, BILL_RATE BILL_RATE
, TP_BASE_AMOUNT TP_BASE_AMOUNT
, BILL_MARKUP_PERCENTAGE BILL_MARKUP_PERCENTAGE
, SCHEDULE_LINE_PERCENTAGE SCHEDULE_LINE_PERCENTAGE
, RULE_PERCENTAGE RULE_PERCENTAGE
, REFERENCE_1 REFERENCE_1
, REFERENCE_2 REFERENCE_2
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REFERENCE_3 REFERENCE_3
, TP_JOB_ID TP_JOB_ID
, PROJFUNC_TP_EXCHANGE_RATE PROJFUNC_TP_EXCHANGE_RATE
, PROJFUNC_TRANSFER_PRICE PROJFUNC_TRANSFER_PRICE
, TP_AMT_TYPE_CODE TP_AMT_TYPE_CODE
, PROJFUNC_TP_RATE_TYPE PROJFUNC_TP_RATE_TYPE
, PROJFUNC_TP_RATE_DATE PROJFUNC_TP_RATE_DATE
, GL_PERIOD_NAME GL_PERIOD_NAME
, PA_PERIOD_NAME PA_PERIOD_NAME
, 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_TP_EXCHANGE_RATE PROJECT_TP_EXCHANGE_RATE
, PROJECT_TRANSFER_PRICE PROJECT_TRANSFER_PRICE
, PROJFUNC_TP_CURRENCY_CODE PROJFUNC_TP_CURRENCY_CODE
, ACCT_EVENT_ID ACCT_EVENT_ID
, ACCT_SOURCE_CODE ACCT_SOURCE_CODE
FROM "PA"."PA_CC_DIST_LINES_ALL"