View: PA_CDL_BURDEN_DETAIL_V

Product:	PA - Projects
Description:	Summarization criteria for burden summarization of expenditure items.This view is based on PA_CDL_BURDEN_DETAIL_V. It is a User customizable view defined over the PA_CDL_BURDEN_DETAIL_V. User can change the columns to be included in summary
Implementation/DBA Data:	APPS.PA_CDL_BURDEN_DETAIL_V

View Text

SELECT PROJECT_ID
, TASK_ID
, ORGANIZATION_ID
, PA_DATE
, PA_PERIOD_NAME
, GTEMP.ATTRIBUTE1
, GTEMP.ATTRIBUTE2
, GTEMP.ATTRIBUTE3
, GTEMP.ATTRIBUTE4
, GTEMP.ATTRIBUTE5
, GTEMP.ATTRIBUTE6
, GTEMP.ATTRIBUTE7
, GTEMP.ATTRIBUTE8
, GTEMP.ATTRIBUTE9
, GTEMP.ATTRIBUTE10
, GTEMP.ATTRIBUTE_CATEGORY
, PERSON_TYPE
, PO_LINE_ID
, SYSTEM_LINKAGE_FUNCTION
, CM.IND_COST_CODE
, EI_EXPENDITURE_TYPE
, (SELECT ICC.EXPENDITURE_TYPE
FROM PA_IND_COST_CODES ICC
WHERE ICC.IND_COST_CODE = CM.IND_COST_CODE) ICC_EXPENDITURE_TYPE
, CM.COST_BASE
, CM.COMPILED_MULTIPLIER
, CM.IND_COMPILED_SET_ID
, EXPENDITURE_ITEM_ID
, LINE_NUM
, EXPENDITURE_ITEM_DATE
, (CDL_AMOUNT * CM.COMPILED_MULTIPLIER) BURDEN_COST
, (CDL_DENOM_RAW_COST * CM.COMPILED_MULTIPLIER) DENOM_BURDENED_COST
, (CDL_ACCT_RAW_COST * CM.COMPILED_MULTIPLIER) ACCT_BURDENED_COST
, (CDL_PROJECT_RAW_COST * CM.COMPILED_MULTIPLIER) PROJECT_BURDENED_COST
, BURDEN_SUM_SOURCE_RUN_ID
, BURDEN_SUM_REJECTION_CODE
, SYSTEM_REFERENCE1
, DENOM_CURRENCY_CODE
, ACCT_CURRENCY_CODE
, PROJECT_CURRENCY_CODE
, PROJFUNC_CURRENCY_CODE
, BILLABLE_FLAG
, GTEMP.REQUEST_ID
, ADJUSTMENT_TYPE
, JOB_ID
, NON_LABOR_RESOURCE
, NON_LABOR_RESOURCE_ORGN_ID
, WIP_RESOURCE_ID
, INCURRED_BY_PERSON_ID
, INVENTORY_ITEM_ID
, ORG_ID
, ACCT_RATE_DATE
, ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE
, PROJECT_RATE_DATE
, PROJECT_RATE_TYPE
, PROJECT_EXCHANGE_RATE
, PROJFUNC_COST_RATE_DATE
, PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_EXCHANGE_RATE
FROM PA_EI_CDL_CM_GTEMP GTEMP
, PA_COMPILED_MULTIPLIERS CM
WHERE CM.IND_COMPILED_SET_ID = GTEMP.IND_COMPILED_SET_ID
AND CM.COST_BASE = GTEMP.COST_BASE
AND CM.COMPILED_MULTIPLIER <> 0
AND GTEMP.BURDEN_SUM_REJECTION_CODE IS NULL
AND PA_BURDEN_COSTING.GET_CURRENT_SPONSORED_FLAG() = 'N' UNION ALL SELECT PROJECT_ID
, TASK_ID
, ORGANIZATION_ID
, PA_DATE
, PA_PERIOD_NAME
, GTEMP.ATTRIBUTE1
, GTEMP.ATTRIBUTE2
, GTEMP.ATTRIBUTE3
, GTEMP.ATTRIBUTE4
, GTEMP.ATTRIBUTE5
, GTEMP.ATTRIBUTE6
, GTEMP.ATTRIBUTE7
, GTEMP.ATTRIBUTE8
, GTEMP.ATTRIBUTE9
, GTEMP.ATTRIBUTE10
, GTEMP.ATTRIBUTE_CATEGORY
, PERSON_TYPE
, PO_LINE_ID
, SYSTEM_LINKAGE_FUNCTION
, CM.IND_COST_CODE
, EI_EXPENDITURE_TYPE
, (SELECT ICC.EXPENDITURE_TYPE
FROM PA_IND_COST_CODES ICC
WHERE ICC.IND_COST_CODE = CM.IND_COST_CODE) ICC_EXPENDITURE_TYPE
, CM.COST_BASE
, CM.COMPILED_MULTIPLIER
, CM.IND_COMPILED_SET_ID
, EXPENDITURE_ITEM_ID
, LINE_NUM
, EXPENDITURE_ITEM_DATE
, ((CDL_AMOUNT * CM.COMPILED_MULTIPLIER)*-1) BURDEN_COST
, ((CDL_DENOM_RAW_COST * CM.COMPILED_MULTIPLIER)*-1) DENOM_BURDENED_COST
, ((CDL_ACCT_RAW_COST * CM.COMPILED_MULTIPLIER)*-1) ACCT_BURDENED_COST
, ((CDL_PROJECT_RAW_COST * CM.COMPILED_MULTIPLIER)*-1) PROJECT_BURDENED_COST
, BURDEN_SUM_SOURCE_RUN_ID
, BURDEN_SUM_REJECTION_CODE
, SYSTEM_REFERENCE1
, DENOM_CURRENCY_CODE
, ACCT_CURRENCY_CODE
, PROJECT_CURRENCY_CODE
, PROJFUNC_CURRENCY_CODE
, BILLABLE_FLAG
, GTEMP.REQUEST_ID
, ADJUSTMENT_TYPE
, JOB_ID
, NON_LABOR_RESOURCE
, NON_LABOR_RESOURCE_ORGN_ID
, WIP_RESOURCE_ID
, INCURRED_BY_PERSON_ID
, INVENTORY_ITEM_ID
, ORG_ID
, ACCT_RATE_DATE
, ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE
, PROJECT_RATE_DATE
, PROJECT_RATE_TYPE
, PROJECT_EXCHANGE_RATE
, PROJFUNC_COST_RATE_DATE
, PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_EXCHANGE_RATE
FROM PA_EI_CDL_CM_GTEMP GTEMP
, PA_COMPILED_MULTIPLIERS CM
WHERE GTEMP.PREV_IND_COMPILED_SET_ID IS NOT NULL
AND CM.IND_COMPILED_SET_ID = GTEMP.PREV_IND_COMPILED_SET_ID
AND CM.COST_BASE = GTEMP.COST_BASE
AND CM.COMPILED_MULTIPLIER <> 0
AND GTEMP.BURDEN_SUM_REJECTION_CODE IS NULL
AND PA_BURDEN_COSTING.GET_CURRENT_SPONSORED_FLAG() = 'N' UNION ALL SELECT GTEMP.PROJECT_ID
, GTEMP.TASK_ID
, GTEMP.ORGANIZATION_ID
, GTEMP.PA_DATE
, GTEMP.PA_PERIOD_NAME
, TO_CHAR(ADL.AWARD_ID)
, GTEMP.ATTRIBUTE2
, GTEMP.ATTRIBUTE3
, GTEMP.ATTRIBUTE4
, GTEMP.ATTRIBUTE5
, GTEMP.ATTRIBUTE6
, GTEMP.ATTRIBUTE7
, GTEMP.ATTRIBUTE8
, GTEMP.ATTRIBUTE9
, GTEMP.ATTRIBUTE10
, GTEMP.ATTRIBUTE_CATEGORY
, GTEMP.PERSON_TYPE
, GTEMP.PO_LINE_ID
, GTEMP.SYSTEM_LINKAGE_FUNCTION
, CM.IND_COST_CODE
, GTEMP.EI_EXPENDITURE_TYPE
, (SELECT ICC.EXPENDITURE_TYPE
FROM PA_IND_COST_CODES ICC
WHERE ICC.IND_COST_CODE = CM.IND_COST_CODE) ICC_EXPENDITURE_TYPE
, CM.COST_BASE
, CM.COMPILED_MULTIPLIER
, CM.IND_COMPILED_SET_ID
, GTEMP.EXPENDITURE_ITEM_ID
, GTEMP.LINE_NUM
, GTEMP.EXPENDITURE_ITEM_DATE
, (DECODE(ADL.AWARD_ID
, NULL
, GTEMP.CDL_AMOUNT
, NVL(ADL.BURDENABLE_RAW_COST
, 0)) * CM.COMPILED_MULTIPLIER) BURDEN_COST
, (DECODE(ADL.AWARD_ID
, NULL
, GTEMP.CDL_DENOM_RAW_COST
, NVL(ADL.BURDENABLE_RAW_COST
, 0)) * CM.COMPILED_MULTIPLIER) DENOM_BURDENED_COST
, (DECODE(ADL.AWARD_ID
, NULL
, GTEMP.CDL_ACCT_RAW_COST
, NVL(ADL.BURDENABLE_RAW_COST
, 0)) * CM.COMPILED_MULTIPLIER) ACCT_BURDENED_COST
, (DECODE(ADL.AWARD_ID
, NULL
, GTEMP.CDL_ACCT_RAW_COST
, NVL(ADL.BURDENABLE_RAW_COST
, 0)) * CM.COMPILED_MULTIPLIER) PROJECT_BURDENED_COST
, GTEMP.BURDEN_SUM_SOURCE_RUN_ID
, GTEMP.BURDEN_SUM_REJECTION_CODE
, GTEMP.SYSTEM_REFERENCE1
, DECODE(ADL.AWARD_ID
, NULL
, GTEMP.DENOM_CURRENCY_CODE
, GTEMP.PROJFUNC_CURRENCY_CODE)
, DECODE(ADL.AWARD_ID
, NULL
, GTEMP.ACCT_CURRENCY_CODE
, GTEMP.PROJFUNC_CURRENCY_CODE)
, DECODE(ADL.AWARD_ID
, NULL
, GTEMP.PROJECT_CURRENCY_CODE
, GTEMP.PROJFUNC_CURRENCY_CODE)
, GTEMP.PROJFUNC_CURRENCY_CODE
, GTEMP.BILLABLE_FLAG
, GTEMP.REQUEST_ID
, NULL
, GTEMP.JOB_ID
, GTEMP.NON_LABOR_RESOURCE
, GTEMP.NON_LABOR_RESOURCE_ORGN_ID
, GTEMP.WIP_RESOURCE_ID
, GTEMP.INCURRED_BY_PERSON_ID
, GTEMP.INVENTORY_ITEM_ID
, ORG_ID
, ACCT_RATE_DATE
, ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE
, PROJECT_RATE_DATE
, PROJECT_RATE_TYPE
, PROJECT_EXCHANGE_RATE
, PROJFUNC_COST_RATE_DATE
, PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_EXCHANGE_RATE
FROM PA_EI_CDL_CM_GTEMP GTEMP
, PA_COMPILED_MULTIPLIERS CM
, GMS_AWARD_DISTRIBUTIONS ADL
WHERE ADL.EXPENDITURE_ITEM_ID = GTEMP.EXPENDITURE_ITEM_ID
AND ADL.CDL_LINE_NUM = GTEMP.LINE_NUM
AND ADL.ADL_STATUS = 'A'
AND ADL.DOCUMENT_TYPE = 'EXP'
AND CM.IND_COMPILED_SET_ID = GTEMP.IND_COMPILED_SET_ID
AND CM.COST_BASE = GTEMP.COST_BASE
AND CM.COMPILED_MULTIPLIER <> 0
AND GTEMP.BURDEN_SUM_REJECTION_CODE IS NULL
AND PA_BURDEN_COSTING.GET_CURRENT_SPONSORED_FLAG() = 'Y'

Columns