eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: PA.PA_COST_DISTRIBUTION_LINES_AL#

Source

View Text - Preformatted


select EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID, LINE_NUM LINE_NUM, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, TRANSFER_STATUS_CODE TRANSFER_STATUS_CODE, AMOUNT#1 AMOUNT, QUANTITY#1 QUANTITY, BILLABLE_FLAG BILLABLE_FLAG, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PA_DATE PA_DATE, DR_CODE_COMBINATION_ID DR_CODE_COMBINATION_ID, GL_DATE GL_DATE, TRANSFERRED_DATE TRANSFERRED_DATE, TRANSFER_REJECTION_REASON TRANSFER_REJECTION_REASON, BATCH_NAME BATCH_NAME, ACCUMULATED_FLAG ACCUMULATED_FLAG, REVERSED_FLAG REVERSED_FLAG, LINE_NUM_REVERSED LINE_NUM_REVERSED, SYSTEM_REFERENCE1 SYSTEM_REFERENCE1, SYSTEM_REFERENCE2 SYSTEM_REFERENCE2, SYSTEM_REFERENCE3 SYSTEM_REFERENCE3, CR_CODE_COMBINATION_ID CR_CODE_COMBINATION_ID, IND_COMPILED_SET_ID IND_COMPILED_SET_ID, LINE_TYPE LINE_TYPE, BURDENED_COST#1 BURDENED_COST, RESOURCE_ACCUMULATED_FLAG RESOURCE_ACCUMULATED_FLAG, FUNCTION_TRANSACTION_CODE FUNCTION_TRANSACTION_CODE, ORG_ID ORG_ID, CODE_COMBINATION_ID CODE_COMBINATION_ID, BURDEN_SUM_SOURCE_RUN_ID BURDEN_SUM_SOURCE_RUN_ID, BURDEN_SUM_REJECTION_CODE BURDEN_SUM_REJECTION_CODE, DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE, DENOM_RAW_COST DENOM_RAW_COST, DENOM_BURDENED_COST DENOM_BURDENED_COST, ACCT_CURRENCY_CODE ACCT_CURRENCY_CODE, ACCT_RATE_DATE ACCT_RATE_DATE, ACCT_RATE_TYPE ACCT_RATE_TYPE, ACCT_EXCHANGE_RATE ACCT_EXCHANGE_RATE, ACCT_RAW_COST ACCT_RAW_COST, ACCT_BURDENED_COST ACCT_BURDENED_COST, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE, PROJECT_RATE_DATE PROJECT_RATE_DATE, PROJECT_RATE_TYPE PROJECT_RATE_TYPE, PROJECT_EXCHANGE_RATE PROJECT_EXCHANGE_RATE, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, PRC_GENERATED_FLAG PRC_GENERATED_FLAG, RECVR_PA_DATE RECVR_PA_DATE, RECVR_GL_DATE RECVR_GL_DATE, UTIL_SUMMARIZED_FLAG UTIL_SUMMARIZED_FLAG, LIQUIDATE_ENCUM_FLAG LIQUIDATE_ENCUM_FLAG, ENCUMBRANCE_BATCH_NAME ENCUMBRANCE_BATCH_NAME, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID, ENCUM_TRANSFER_REJ_REASON ENCUM_TRANSFER_REJ_REASON, BUDGET_CCID BUDGET_CCID, ENCUMBRANCE_AMOUNT ENCUMBRANCE_AMOUNT, PROJFUNC_COST_EXCHANGE_RATE PROJFUNC_COST_EXCHANGE_RATE, PROJECT_RAW_COST PROJECT_RAW_COST, PROJECT_BURDENED_COST PROJECT_BURDENED_COST, WORK_TYPE_ID WORK_TYPE_ID, GL_PERIOD_NAME GL_PERIOD_NAME, RECVR_GL_PERIOD_NAME RECVR_GL_PERIOD_NAME, PA_PERIOD_NAME PA_PERIOD_NAME, PROJFUNC_COST_RATE_TYPE PROJFUNC_COST_RATE_TYPE, PROJFUNC_COST_RATE_DATE PROJFUNC_COST_RATE_DATE, RECVR_PA_PERIOD_NAME RECVR_PA_PERIOD_NAME, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE, SYSTEM_REFERENCE4 SYSTEM_REFERENCE4, PJI_SUMMARIZED_FLAG PJI_SUMMARIZED_FLAG, ORG_LABOR_SCH_RULE_ID ORG_LABOR_SCH_RULE_ID, COST_RATE_SCH_ID COST_RATE_SCH_ID, DENOM_BURDENED_CHANGE DENOM_BURDENED_CHANGE, PROJECT_BURDENED_CHANGE PROJECT_BURDENED_CHANGE, PROJFUNC_BURDENED_CHANGE PROJFUNC_BURDENED_CHANGE, ACCT_BURDENED_CHANGE ACCT_BURDENED_CHANGE, PARENT_LINE_NUM PARENT_LINE_NUM, PREV_IND_COMPILED_SET_ID PREV_IND_COMPILED_SET_ID, SI_ASSETS_ADDITION_FLAG SI_ASSETS_ADDITION_FLAG, SYSTEM_REFERENCE5 SYSTEM_REFERENCE5, ACCT_EVENT_ID ACCT_EVENT_ID, ACCT_SOURCE_CODE ACCT_SOURCE_CODE, BUDGET_LINE_ID BUDGET_LINE_ID, BUDGET_VERSION_ID BUDGET_VERSION_ID, COSTING_METHOD COSTING_METHOD, RATE_SOURCE_CODE RATE_SOURCE_CODE, PAYROLL_ACCRUAL_FLAG PAYROLL_ACCRUAL_FLAG, CBS_ELEMENT_ID CBS_ELEMENT_ID from "PA"."PA_COST_DISTRIBUTION_LINES_ALL"

View Text - HTML Formatted

SELECT EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID
, LINE_NUM LINE_NUM
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, TRANSFER_STATUS_CODE TRANSFER_STATUS_CODE
, AMOUNT#1 AMOUNT
, QUANTITY#1 QUANTITY
, BILLABLE_FLAG BILLABLE_FLAG
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PA_DATE PA_DATE
, DR_CODE_COMBINATION_ID DR_CODE_COMBINATION_ID
, GL_DATE GL_DATE
, TRANSFERRED_DATE TRANSFERRED_DATE
, TRANSFER_REJECTION_REASON TRANSFER_REJECTION_REASON
, BATCH_NAME BATCH_NAME
, ACCUMULATED_FLAG ACCUMULATED_FLAG
, REVERSED_FLAG REVERSED_FLAG
, LINE_NUM_REVERSED LINE_NUM_REVERSED
, SYSTEM_REFERENCE1 SYSTEM_REFERENCE1
, SYSTEM_REFERENCE2 SYSTEM_REFERENCE2
, SYSTEM_REFERENCE3 SYSTEM_REFERENCE3
, CR_CODE_COMBINATION_ID CR_CODE_COMBINATION_ID
, IND_COMPILED_SET_ID IND_COMPILED_SET_ID
, LINE_TYPE LINE_TYPE
, BURDENED_COST#1 BURDENED_COST
, RESOURCE_ACCUMULATED_FLAG RESOURCE_ACCUMULATED_FLAG
, FUNCTION_TRANSACTION_CODE FUNCTION_TRANSACTION_CODE
, ORG_ID ORG_ID
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, BURDEN_SUM_SOURCE_RUN_ID BURDEN_SUM_SOURCE_RUN_ID
, BURDEN_SUM_REJECTION_CODE BURDEN_SUM_REJECTION_CODE
, DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE
, DENOM_RAW_COST DENOM_RAW_COST
, DENOM_BURDENED_COST DENOM_BURDENED_COST
, ACCT_CURRENCY_CODE ACCT_CURRENCY_CODE
, ACCT_RATE_DATE ACCT_RATE_DATE
, ACCT_RATE_TYPE ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE ACCT_EXCHANGE_RATE
, ACCT_RAW_COST ACCT_RAW_COST
, ACCT_BURDENED_COST ACCT_BURDENED_COST
, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE
, PROJECT_RATE_DATE PROJECT_RATE_DATE
, PROJECT_RATE_TYPE PROJECT_RATE_TYPE
, PROJECT_EXCHANGE_RATE PROJECT_EXCHANGE_RATE
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, PRC_GENERATED_FLAG PRC_GENERATED_FLAG
, RECVR_PA_DATE RECVR_PA_DATE
, RECVR_GL_DATE RECVR_GL_DATE
, UTIL_SUMMARIZED_FLAG UTIL_SUMMARIZED_FLAG
, LIQUIDATE_ENCUM_FLAG LIQUIDATE_ENCUM_FLAG
, ENCUMBRANCE_BATCH_NAME ENCUMBRANCE_BATCH_NAME
, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, ENCUM_TRANSFER_REJ_REASON ENCUM_TRANSFER_REJ_REASON
, BUDGET_CCID BUDGET_CCID
, ENCUMBRANCE_AMOUNT ENCUMBRANCE_AMOUNT
, PROJFUNC_COST_EXCHANGE_RATE PROJFUNC_COST_EXCHANGE_RATE
, PROJECT_RAW_COST PROJECT_RAW_COST
, PROJECT_BURDENED_COST PROJECT_BURDENED_COST
, WORK_TYPE_ID WORK_TYPE_ID
, GL_PERIOD_NAME GL_PERIOD_NAME
, RECVR_GL_PERIOD_NAME RECVR_GL_PERIOD_NAME
, PA_PERIOD_NAME PA_PERIOD_NAME
, PROJFUNC_COST_RATE_TYPE PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_RATE_DATE PROJFUNC_COST_RATE_DATE
, RECVR_PA_PERIOD_NAME RECVR_PA_PERIOD_NAME
, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE
, SYSTEM_REFERENCE4 SYSTEM_REFERENCE4
, PJI_SUMMARIZED_FLAG PJI_SUMMARIZED_FLAG
, ORG_LABOR_SCH_RULE_ID ORG_LABOR_SCH_RULE_ID
, COST_RATE_SCH_ID COST_RATE_SCH_ID
, DENOM_BURDENED_CHANGE DENOM_BURDENED_CHANGE
, PROJECT_BURDENED_CHANGE PROJECT_BURDENED_CHANGE
, PROJFUNC_BURDENED_CHANGE PROJFUNC_BURDENED_CHANGE
, ACCT_BURDENED_CHANGE ACCT_BURDENED_CHANGE
, PARENT_LINE_NUM PARENT_LINE_NUM
, PREV_IND_COMPILED_SET_ID PREV_IND_COMPILED_SET_ID
, SI_ASSETS_ADDITION_FLAG SI_ASSETS_ADDITION_FLAG
, SYSTEM_REFERENCE5 SYSTEM_REFERENCE5
, ACCT_EVENT_ID ACCT_EVENT_ID
, ACCT_SOURCE_CODE ACCT_SOURCE_CODE
, BUDGET_LINE_ID BUDGET_LINE_ID
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, COSTING_METHOD COSTING_METHOD
, RATE_SOURCE_CODE RATE_SOURCE_CODE
, PAYROLL_ACCRUAL_FLAG PAYROLL_ACCRUAL_FLAG
, CBS_ELEMENT_ID CBS_ELEMENT_ID
FROM "PA"."PA_COST_DISTRIBUTION_LINES_ALL"