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_DIST_LINES_AR#

Source

View Text - Preformatted


select PURGE_BATCH_ID PURGE_BATCH_ID, PURGE_RELEASE PURGE_RELEASE, PURGE_PROJECT_ID PURGE_PROJECT_ID, FUNCTION_TRANSACTION_CODE FUNCTION_TRANSACTION_CODE, ORG_ID ORG_ID, CODE_COMBINATION_ID CODE_COMBINATION_ID, 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 AMOUNT, QUANTITY 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 BURDENED_COST, RESOURCE_ACCUMULATED_FLAG RESOURCE_ACCUMULATED_FLAG, 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, TASK_ID TASK_ID, PRC_GENERATED_FLAG PRC_GENERATED_FLAG, BUDGET_CCID BUDGET_CCID, RECVR_PA_DATE RECVR_PA_DATE, ENCUMBRANCE_AMOUNT ENCUMBRANCE_AMOUNT, BURDEN_SUM_SOURCE_RUN_ID BURDEN_SUM_SOURCE_RUN_ID, PROJFUNC_COST_EXCHANGE_RATE PROJFUNC_COST_EXCHANGE_RATE, RECVR_GL_DATE RECVR_GL_DATE, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID, PA_PERIOD_NAME PA_PERIOD_NAME, ENCUM_TRANSFER_REJ_REASON ENCUM_TRANSFER_REJ_REASON, PROJFUNC_COST_RATE_TYPE PROJFUNC_COST_RATE_TYPE, PROJECT_RAW_COST PROJECT_RAW_COST, BURDEN_SUM_REJECTION_CODE BURDEN_SUM_REJECTION_CODE, PROJFUNC_COST_RATE_DATE PROJFUNC_COST_RATE_DATE, UTIL_SUMMARIZED_FLAG UTIL_SUMMARIZED_FLAG, RECVR_PA_PERIOD_NAME RECVR_PA_PERIOD_NAME, PROJECT_BURDENED_COST PROJECT_BURDENED_COST, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE, LIQUIDATE_ENCUM_FLAG LIQUIDATE_ENCUM_FLAG, PROJECT_ID PROJECT_ID, SYSTEM_REFERENCE4 SYSTEM_REFERENCE4, PJI_SUMMARIZED_FLAG PJI_SUMMARIZED_FLAG, WORK_TYPE_ID WORK_TYPE_ID, ENCUMBRANCE_BATCH_NAME ENCUMBRANCE_BATCH_NAME, GL_PERIOD_NAME GL_PERIOD_NAME, RECVR_GL_PERIOD_NAME RECVR_GL_PERIOD_NAME, 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, CBS_ELEMENT_ID CBS_ELEMENT_ID from "PA"."PA_COST_DIST_LINES_AR"

View Text - HTML Formatted

SELECT PURGE_BATCH_ID PURGE_BATCH_ID
, PURGE_RELEASE PURGE_RELEASE
, PURGE_PROJECT_ID PURGE_PROJECT_ID
, FUNCTION_TRANSACTION_CODE FUNCTION_TRANSACTION_CODE
, ORG_ID ORG_ID
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, 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 AMOUNT
, QUANTITY 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 BURDENED_COST
, RESOURCE_ACCUMULATED_FLAG RESOURCE_ACCUMULATED_FLAG
, 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
, TASK_ID TASK_ID
, PRC_GENERATED_FLAG PRC_GENERATED_FLAG
, BUDGET_CCID BUDGET_CCID
, RECVR_PA_DATE RECVR_PA_DATE
, ENCUMBRANCE_AMOUNT ENCUMBRANCE_AMOUNT
, BURDEN_SUM_SOURCE_RUN_ID BURDEN_SUM_SOURCE_RUN_ID
, PROJFUNC_COST_EXCHANGE_RATE PROJFUNC_COST_EXCHANGE_RATE
, RECVR_GL_DATE RECVR_GL_DATE
, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, PA_PERIOD_NAME PA_PERIOD_NAME
, ENCUM_TRANSFER_REJ_REASON ENCUM_TRANSFER_REJ_REASON
, PROJFUNC_COST_RATE_TYPE PROJFUNC_COST_RATE_TYPE
, PROJECT_RAW_COST PROJECT_RAW_COST
, BURDEN_SUM_REJECTION_CODE BURDEN_SUM_REJECTION_CODE
, PROJFUNC_COST_RATE_DATE PROJFUNC_COST_RATE_DATE
, UTIL_SUMMARIZED_FLAG UTIL_SUMMARIZED_FLAG
, RECVR_PA_PERIOD_NAME RECVR_PA_PERIOD_NAME
, PROJECT_BURDENED_COST PROJECT_BURDENED_COST
, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE
, LIQUIDATE_ENCUM_FLAG LIQUIDATE_ENCUM_FLAG
, PROJECT_ID PROJECT_ID
, SYSTEM_REFERENCE4 SYSTEM_REFERENCE4
, PJI_SUMMARIZED_FLAG PJI_SUMMARIZED_FLAG
, WORK_TYPE_ID WORK_TYPE_ID
, ENCUMBRANCE_BATCH_NAME ENCUMBRANCE_BATCH_NAME
, GL_PERIOD_NAME GL_PERIOD_NAME
, RECVR_GL_PERIOD_NAME RECVR_GL_PERIOD_NAME
, 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
, CBS_ELEMENT_ID CBS_ELEMENT_ID
FROM "PA"."PA_COST_DIST_LINES_AR"