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_COST_DIST_LINES_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_COST_DIST_LINES_V

View Text

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

Columns

Name
EXPENDITURE_ITEM_ID
LINE_NUM
CREATION_DATE
CREATED_BY
TRANSFER_STATUS_CODE
AMOUNT
QUANTITY
BILLABLE_FLAG
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
PA_DATE
DR_CODE_COMBINATION_ID
GL_DATE
TRANSFERRED_DATE
TRANSFER_REJECTION_REASON
BATCH_NAME
ACCUMULATED_FLAG
REVERSED_FLAG
LINE_NUM_REVERSED
SYSTEM_REFERENCE1
SYSTEM_REFERENCE2
SYSTEM_REFERENCE3
CR_CODE_COMBINATION_ID
IND_COMPILED_SET_ID
LINE_TYPE
BURDENED_COST
RESOURCE_ACCUMULATED_FLAG
FUNCTION_TRANSACTION_CODE
ORG_ID
CODE_COMBINATION_ID
BURDEN_SUM_SOURCE_RUN_ID
BURDEN_SUM_REJECTION_CODE
PROJECT_ID
TASK_ID
DENOM_CURRENCY_CODE
DENOM_RAW_COST
DENOM_BURDENED_COST
ACCT_CURRENCY_CODE
ACCT_RATE_DATE
ACCT_RATE_TYPE
ACCT_EXCHANGE_RATE
ACCT_RAW_COST
ACCT_BURDENED_COST
PROJECT_CURRENCY_CODE
PROJECT_RATE_DATE
PROJECT_RATE_TYPE
PROJECT_EXCHANGE_RATE
PRC_GENERATED_FLAG
RECVR_PA_DATE
RECVR_GL_DATE
UTIL_SUMMARIZED_FLAG
LIQUIDATE_ENCUM_FLAG
ENCUMBRANCE_BATCH_NAME
ENCUMBRANCE_TYPE_ID
ENCUM_TRANSFER_REJ_REASON
BUDGET_CCID
ENCUMBRANCE_AMOUNT
PROJFUNC_COST_EXCHANGE_RATE
PROJECT_RAW_COST
PROJECT_BURDENED_COST
WORK_TYPE_ID
GL_PERIOD_NAME
RECVR_GL_PERIOD_NAME
PA_PERIOD_NAME
PROJFUNC_COST_RATE_TYPE
PROJFUNC_COST_RATE_DATE
RECVR_PA_PERIOD_NAME
PROJFUNC_CURRENCY_CODE
SYSTEM_REFERENCE4
PJI_SUMMARIZED_FLAG
ORG_LABOR_SCH_RULE_ID
COST_RATE_SCH_ID
DENOM_BURDENED_CHANGE
ACCT_BURDENED_CHANGE
PROJECT_BURDENED_CHANGE
PROJFUNC_BURDENED_CHANGE
PARENT_LINE_NUM
PREV_IND_COMPILED_SET_ID
MRC_ACCT_CURRENCY_CODE
MRC_ACCT_RATE_DATE
MRC_ACCT_RATE_TYPE
MRC_ACCT_EXCHANGE_RATE
MRC_ACCT_RAW_COST
MRC_ACCT_BURDENED_COST
MRC_TRANS_STATUS_CODE
MRC_TRANS_DATE
MRC_TRANS_REJECTION_REASON
SI_ASSETS_ADDITION_FLAG
ACCT_EVENT_ID