VIEW: APPS.PA_COST_DIST_LINES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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