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 /*+ USE_NL(PA_CDL_BURDEN_DETAIL_V.E PA_CDL_BURDEN_DETAIL_V.ICS) INDEX (PA_CDL_BURDEN_DETAIL_V.ICS PA_IND_COMPILED_SETS_N6)*/ CDL.PROJECT_ID
, CDL.TASK_ID
, ICS.ORGANIZATION_ID
, CDL.PA_DATE
, DECODE(CDL.PREV_IND_COMPILED_SET_ID
, NULL
, CDL.PA_PERIOD_NAME
, NVL(PA_UTILS2.GET_PA_PERIOD_NAME(EI.EXPENDITURE_ITEM_DATE
, EI.ORG_ID)
, CDL.PA_PERIOD_NAME)) PA_PERIOD_NAME
, EI.ATTRIBUTE1
, EI.ATTRIBUTE2
, EI.ATTRIBUTE3
, EI.ATTRIBUTE4
, EI.ATTRIBUTE5
, EI.ATTRIBUTE6
, EI.ATTRIBUTE7
, EI.ATTRIBUTE8
, EI.ATTRIBUTE9
, EI.ATTRIBUTE10
, EI.ATTRIBUTE_CATEGORY
, E.PERSON_TYPE PERSON_TYPE
, EI.PO_LINE_ID PO_LINE_ID
, EI.SYSTEM_LINKAGE_FUNCTION SYSTEM_LINKAGE_FUNCTION
, CM.IND_COST_CODE
, EI.EXPENDITURE_TYPE EI_EXPENDITURE_TYPE
, ICC.EXPENDITURE_TYPE ICC_EXPENDITURE_TYPE
, CM.COST_BASE
, CM.COMPILED_MULTIPLIER
, NULL IND_RATE_SCH_ID
, IRSR.IND_RATE_SCH_REVISION_ID
, EI.EXPENDITURE_ITEM_ID
, CDL.LINE_NUM
, EI.EXPENDITURE_ITEM_DATE
, PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((CDL.AMOUNT * CM.COMPILED_MULTIPLIER)
, CDL.PROJFUNC_CURRENCY_CODE) BURDEN_COST
, PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((CDL.DENOM_RAW_COST * CM.COMPILED_MULTIPLIER)
, CDL.DENOM_CURRENCY_CODE) DENOM_BURDENED_COST
, PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((CDL.ACCT_RAW_COST * CM.COMPILED_MULTIPLIER)
, CDL.ACCT_CURRENCY_CODE) ACCT_BURDENED_COST
, PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((CDL.PROJECT_RAW_COST * CM.COMPILED_MULTIPLIER)
, CDL.PROJECT_CURRENCY_CODE) PROJECT_BURDENED_COST
, CDL.BURDEN_SUM_SOURCE_RUN_ID
, CDL.BURDEN_SUM_REJECTION_CODE
, CDL.SYSTEM_REFERENCE1 SYSTEM_REFERENCE1
, EI.DENOM_CURRENCY_CODE
, EI.ACCT_CURRENCY_CODE
, EI.PROJECT_CURRENCY_CODE
, EI.PROJFUNC_CURRENCY_CODE
, CDL.BILLABLE_FLAG
, CDL.REQUEST_ID
, DECODE(EI.ADJUSTMENT_TYPE
, 'BURDEN_RESUMMARIZE'
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'VI'
, EI.ADJUSTMENT_TYPE
, DECODE(EI.PO_LINE_ID
, NULL
, NULL
, EI.ADJUSTMENT_TYPE))
, NULL) ADJUSTMENT_TYPE
, EI.JOB_ID
, EI.NON_LABOR_RESOURCE
, EI.ORGANIZATION_ID NON_LABOR_RESOURCE_ORGN_ID
, EI.WIP_RESOURCE_ID
, E.INCURRED_BY_PERSON_ID
, EI.INVENTORY_ITEM_ID
, EI.ORG_ID
, CDL.ACCT_RATE_DATE
, CDL.ACCT_RATE_TYPE
, CDL.ACCT_EXCHANGE_RATE
, CDL.PROJECT_RATE_DATE
, CDL.PROJECT_RATE_TYPE
, CDL.PROJECT_EXCHANGE_RATE
, CDL.PROJFUNC_COST_RATE_DATE
, CDL.PROJFUNC_COST_RATE_TYPE
, CDL.PROJFUNC_COST_EXCHANGE_RATE
FROM PA_COST_DISTRIBUTION_LINES_ALL CDL
, PA_EXPENDITURE_ITEMS EI
, PA_EXPENDITURES_ALL E
, PA_IND_COMPILED_SETS ICS
, PA_IND_RATE_SCH_REVISIONS IRSR
, PA_COST_BASE_EXP_TYPES CBET
, PA_COMPILED_MULTIPLIERS CM
, PA_IND_COST_CODES ICC
WHERE ICS.IND_RATE_SCH_REVISION_ID = IRSR.IND_RATE_SCH_REVISION_ID
AND IRSR.COST_PLUS_STRUCTURE = CBET.COST_PLUS_STRUCTURE
AND CBET.COST_BASE = CM.COST_BASE
AND CBET.COST_BASE_TYPE = 'INDIRECT COST'
AND CBET.EXPENDITURE_TYPE = EI.EXPENDITURE_TYPE
AND ICS.ORGANIZATION_ID = NVL(EI.OVERRIDE_TO_ORGANIZATION_ID
, E.INCURRED_BY_ORGANIZATION_ID)
AND ICS.COST_BASE = CBET.COST_BASE
AND ICS.IND_COMPILED_SET_ID = CDL.IND_COMPILED_SET_ID
AND ICC.IND_COST_CODE = CM.IND_COST_CODE
AND CM.IND_COMPILED_SET_ID = DECODE(CBET.COST_BASE
, NULL
, NULL
, ICS.IND_COMPILED_SET_ID)
AND CDL.BURDEN_SUM_REJECTION_CODE IS NULL
AND CDL.LINE_TYPE = 'R'
AND CDL.BURDEN_SUM_SOURCE_RUN_ID = PA_BURDEN_COSTING.GET_CURRENT_RUN_ID()
AND CDL.EXPENDITURE_ITEM_ID = EI.EXPENDITURE_ITEM_ID
AND E.EXPENDITURE_ID = EI.EXPENDITURE_ID
AND CDL.PROJECT_ID = PA_BURDEN_COSTING.GET_CURRENT_PROJECT_ID()
AND PA_BURDEN_COSTING.GET_CURRENT_SPONSORED_FLAG() = 'N'
AND DECODE(EI.TRANSACTION_SOURCE
, NULL
, 'N'
, PA_UTILS2.GET_TS_ALLOW_BURDEN_FLAG(EI.TRANSACTION_SOURCE))<>'Y' UNION ALL SELECT CDL.PROJECT_ID
, CDL.TASK_ID
, ICS.ORGANIZATION_ID
, CDL.PA_DATE
, DECODE(CDL.PREV_IND_COMPILED_SET_ID
, NULL
, CDL.PA_PERIOD_NAME
, NVL(PA_UTILS2.GET_PA_PERIOD_NAME(EI.EXPENDITURE_ITEM_DATE
, EI.ORG_ID)
, CDL.PA_PERIOD_NAME)) PA_PERIOD_NAME
, EI.ATTRIBUTE1
, EI.ATTRIBUTE2
, EI.ATTRIBUTE3
, EI.ATTRIBUTE4
, EI.ATTRIBUTE5
, EI.ATTRIBUTE6
, EI.ATTRIBUTE7
, EI.ATTRIBUTE8
, EI.ATTRIBUTE9
, EI.ATTRIBUTE10
, EI.ATTRIBUTE_CATEGORY
, E.PERSON_TYPE PERSON_TYPE
, EI.PO_LINE_ID PO_LINE_ID
, EI.SYSTEM_LINKAGE_FUNCTION SYSTEM_LINKAGE_FUNCTION
, CM.IND_COST_CODE
, EI.EXPENDITURE_TYPE EI_EXPENDITURE_TYPE
, ICC.EXPENDITURE_TYPE ICC_EXPENDITURE_TYPE
, CM.COST_BASE
, CM.COMPILED_MULTIPLIER
, NULL IND_RATE_SCH_ID
, IRSR.IND_RATE_SCH_REVISION_ID
, EI.EXPENDITURE_ITEM_ID
, CDL.LINE_NUM
, EI.EXPENDITURE_ITEM_DATE
, PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((CDL.AMOUNT * CM.COMPILED_MULTIPLIER)
, CDL.PROJFUNC_CURRENCY_CODE) * -1 BURDEN_COST
, PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((CDL.DENOM_RAW_COST * CM.COMPILED_MULTIPLIER)
, CDL.DENOM_CURRENCY_CODE) * -1 DENOM_BURDENED_COST
, PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((CDL.ACCT_RAW_COST * CM.COMPILED_MULTIPLIER)
, CDL.ACCT_CURRENCY_CODE) * -1 ACCT_BURDENED_COST
, PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((CDL.PROJECT_RAW_COST * CM.COMPILED_MULTIPLIER)
, CDL.PROJECT_CURRENCY_CODE) * -1 PROJECT_BURDENED_COST
, CDL.BURDEN_SUM_SOURCE_RUN_ID
, CDL.BURDEN_SUM_REJECTION_CODE
, CDL.SYSTEM_REFERENCE1 SYSTEM_REFERENCE1
, EI.DENOM_CURRENCY_CODE
, EI.ACCT_CURRENCY_CODE
, EI.PROJECT_CURRENCY_CODE
, EI.PROJFUNC_CURRENCY_CODE
, CDL.BILLABLE_FLAG
, CDL.REQUEST_ID
, DECODE(EI.ADJUSTMENT_TYPE
, 'BURDEN_RESUMMARIZE'
, DECODE(EI.SYSTEM_LINKAGE_FUNCTION
, 'VI'
, EI.ADJUSTMENT_TYPE
, DECODE(EI.PO_LINE_ID
, NULL
, NULL
, EI.ADJUSTMENT_TYPE))
, NULL) ADJUSTMENT_TYPE
, EI.JOB_ID
, EI.NON_LABOR_RESOURCE
, EI.ORGANIZATION_ID NON_LABOR_RESOURCE_ORGN_ID
, EI.WIP_RESOURCE_ID
, E.INCURRED_BY_PERSON_ID
, EI.INVENTORY_ITEM_ID
, EI.ORG_ID
, CDL.ACCT_RATE_DATE
, CDL.ACCT_RATE_TYPE
, CDL.ACCT_EXCHANGE_RATE
, CDL.PROJECT_RATE_DATE
, CDL.PROJECT_RATE_TYPE
, CDL.PROJECT_EXCHANGE_RATE
, CDL.PROJFUNC_COST_RATE_DATE
, CDL.PROJFUNC_COST_RATE_TYPE
, CDL.PROJFUNC_COST_EXCHANGE_RATE
FROM PA_COST_DISTRIBUTION_LINES_ALL CDL
, PA_EXPENDITURE_ITEMS EI
, PA_EXPENDITURES_ALL E
, PA_IND_COMPILED_SETS ICS
, PA_IND_RATE_SCH_REVISIONS IRSR
, PA_COST_BASE_EXP_TYPES CBET
, PA_COMPILED_MULTIPLIERS CM
, PA_IND_COST_CODES ICC
WHERE ICS.IND_RATE_SCH_REVISION_ID = IRSR.IND_RATE_SCH_REVISION_ID
AND IRSR.COST_PLUS_STRUCTURE = CBET.COST_PLUS_STRUCTURE
AND CBET.COST_BASE = CM.COST_BASE
AND CBET.COST_BASE_TYPE = 'INDIRECT COST'
AND CBET.EXPENDITURE_TYPE = EI.EXPENDITURE_TYPE
AND ICS.ORGANIZATION_ID = NVL(EI.OVERRIDE_TO_ORGANIZATION_ID
, E.INCURRED_BY_ORGANIZATION_ID)
AND ICS.COST_BASE = CBET.COST_BASE
AND ICS.IND_COMPILED_SET_ID = CDL.PREV_IND_COMPILED_SET_ID
AND CDL.PREV_IND_COMPILED_SET_ID IS NOT NULL
AND ICC.IND_COST_CODE = CM.IND_COST_CODE
AND CM.IND_COMPILED_SET_ID = DECODE(CBET.COST_BASE
, NULL
, NULL
, ICS.IND_COMPILED_SET_ID)
AND CDL.BURDEN_SUM_REJECTION_CODE IS NULL
AND CDL.LINE_TYPE = 'R'
AND CDL.BURDEN_SUM_SOURCE_RUN_ID = PA_BURDEN_COSTING.GET_CURRENT_RUN_ID()
AND CDL.EXPENDITURE_ITEM_ID = EI.EXPENDITURE_ITEM_ID
AND E.EXPENDITURE_ID = EI.EXPENDITURE_ID
AND CDL.PROJECT_ID = PA_BURDEN_COSTING.GET_CURRENT_PROJECT_ID()
AND PA_BURDEN_COSTING.GET_CURRENT_SPONSORED_FLAG() = 'N'
AND DECODE(EI.TRANSACTION_SOURCE
, NULL
, 'N'
, PA_UTILS2.GET_TS_ALLOW_BURDEN_FLAG(EI.TRANSACTION_SOURCE))<>'Y' UNION ALL SELECT CDL.PROJECT_ID
, CDL.TASK_ID
, ICS.ORGANIZATION_ID
, CDL.PA_DATE
, CDL.PA_PERIOD_NAME
, TO_CHAR(ADL.AWARD_ID)
, EI.ATTRIBUTE2
, EI.ATTRIBUTE3
, EI.ATTRIBUTE4
, EI.ATTRIBUTE5
, EI.ATTRIBUTE6
, EI.ATTRIBUTE7
, EI.ATTRIBUTE8
, EI.ATTRIBUTE9
, EI.ATTRIBUTE10
, EI.ATTRIBUTE_CATEGORY
, E.PERSON_TYPE PERSON_TYPE
, EI.PO_LINE_ID PO_LINE_ID
, EI.SYSTEM_LINKAGE_FUNCTION
, CM.IND_COST_CODE
, EI.EXPENDITURE_TYPE EI_EXPENDITURE_TYPE
, ICC.EXPENDITURE_TYPE ICC_EXPENDITURE_TYPE
, CM.COST_BASE
, CM.COMPILED_MULTIPLIER
, NULL IND_RATE_SCH_ID
, IRSR.IND_RATE_SCH_REVISION_ID
, EI.EXPENDITURE_ITEM_ID
, CDL.LINE_NUM
, EI.EXPENDITURE_ITEM_DATE
, PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((DECODE(ADL.AWARD_ID
, NULL
, CDL.AMOUNT
, NVL(ADL.BURDENABLE_RAW_COST
, 0)) * CM.COMPILED_MULTIPLIER)
, CDL.PROJFUNC_CURRENCY_CODE) BURDEN_COST
, PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((DECODE(ADL.AWARD_ID
, NULL
, CDL.DENOM_RAW_COST
, NVL(ADL.BURDENABLE_RAW_COST
, 0)) * CM.COMPILED_MULTIPLIER)
, CDL.DENOM_CURRENCY_CODE) DENOM_BURDENED_COST
, PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((DECODE(ADL.AWARD_ID
, NULL
, CDL.ACCT_RAW_COST
, NVL(ADL.BURDENABLE_RAW_COST
, 0)) * CM.COMPILED_MULTIPLIER)
, CDL.ACCT_CURRENCY_CODE) ACCT_BURDENED_COST
, PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((DECODE(ADL.AWARD_ID
, NULL
, CDL.ACCT_RAW_COST
, NVL(ADL.BURDENABLE_RAW_COST
, 0)) * CM.COMPILED_MULTIPLIER)
, CDL.PROJECT_CURRENCY_CODE) PROJECT_BURDENED_COST
, CDL.BURDEN_SUM_SOURCE_RUN_ID
, CDL.BURDEN_SUM_REJECTION_CODE
, CDL.SYSTEM_REFERENCE1
, DECODE(ADL.AWARD_ID
, NULL
, EI.DENOM_CURRENCY_CODE
, EI.PROJFUNC_CURRENCY_CODE)
, DECODE(ADL.AWARD_ID
, NULL
, EI.ACCT_CURRENCY_CODE
, EI.PROJFUNC_CURRENCY_CODE)
, DECODE(ADL.AWARD_ID
, NULL
, EI.PROJECT_CURRENCY_CODE
, EI.PROJFUNC_CURRENCY_CODE)
, EI.PROJFUNC_CURRENCY_CODE
, CDL.BILLABLE_FLAG
, CDL.REQUEST_ID
, NULL ADJUSTMENT_TYPE
, EI.JOB_ID
, EI.NON_LABOR_RESOURCE
, EI.ORGANIZATION_ID NON_LABOR_RESOURCE_ORGN_ID
, EI.WIP_RESOURCE_ID
, E.INCURRED_BY_PERSON_ID
, EI.INVENTORY_ITEM_ID
, EI.ORG_ID
, CDL.ACCT_RATE_DATE
, CDL.ACCT_RATE_TYPE
, CDL.ACCT_EXCHANGE_RATE
, CDL.PROJECT_RATE_DATE
, CDL.PROJECT_RATE_TYPE
, CDL.PROJECT_EXCHANGE_RATE
, CDL.PROJFUNC_COST_RATE_DATE
, CDL.PROJFUNC_COST_RATE_TYPE
, CDL.PROJFUNC_COST_EXCHANGE_RATE
FROM PA_COST_DISTRIBUTION_LINES_ALL CDL
, PA_EXPENDITURE_ITEMS EI
, PA_EXPENDITURES_ALL E
, GMS_AWARD_DISTRIBUTIONS ADL
, PA_IND_COST_CODES ICC
, PA_COMPILED_MULTIPLIERS CM
, PA_IND_COMPILED_SETS ICS
, PA_COST_BASE_EXP_TYPES CBET
, PA_IND_RATE_SCH_REVISIONS IRSR
WHERE ICS.IND_RATE_SCH_REVISION_ID = IRSR.IND_RATE_SCH_REVISION_ID
AND IRSR.COST_PLUS_STRUCTURE = CBET.COST_PLUS_STRUCTURE
AND CBET.COST_BASE = CM.COST_BASE
AND CBET.COST_BASE_TYPE = 'INDIRECT COST'
AND CBET.EXPENDITURE_TYPE = EI.EXPENDITURE_TYPE
AND ICS.ORGANIZATION_ID = NVL(EI.OVERRIDE_TO_ORGANIZATION_ID
, E.INCURRED_BY_ORGANIZATION_ID)
AND ICS.COST_BASE = CBET.COST_BASE
AND ICS.IND_COMPILED_SET_ID = CDL.IND_COMPILED_SET_ID
AND ICC.IND_COST_CODE = CM.IND_COST_CODE
AND CM.IND_COMPILED_SET_ID = DECODE(CBET.COST_BASE
, NULL
, NULL
, CDL.IND_COMPILED_SET_ID)
AND ADL.EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID
AND ADL.CDL_LINE_NUM = CDL.LINE_NUM
AND ADL.ADL_STATUS = 'A'
AND ADL.DOCUMENT_TYPE = 'EXP'
AND CDL.BURDEN_SUM_REJECTION_CODE IS NULL
AND CDL.LINE_TYPE = 'R'
AND CDL.BURDEN_SUM_SOURCE_RUN_ID = PA_BURDEN_COSTING.GET_CURRENT_RUN_ID()
AND CDL.EXPENDITURE_ITEM_ID = EI.EXPENDITURE_ITEM_ID
AND E.EXPENDITURE_ID = EI.EXPENDITURE_ID
AND CDL.PROJECT_ID = PA_BURDEN_COSTING.GET_CURRENT_PROJECT_ID()
AND PA_BURDEN_COSTING.GET_CURRENT_SPONSORED_FLAG() = 'Y'
AND DECODE(EI.TRANSACTION_SOURCE
, NULL
, 'N'
, PA_UTILS2.GET_TS_ALLOW_BURDEN_FLAG(EI.TRANSACTION_SOURCE))<>'Y'

Columns