View: PA_CDL_BURDEN_SUMMARY_V

Product:	IPA - Capital Resource Logistics - Projects
Description:
Implementation/DBA Data:	APPS.PA_CDL_BURDEN_SUMMARY_V

View Text

SELECT PROJECT_ID SOURCE_PROJECT_ID
, TASK_ID SOURCE_TASK_ID
, ORGANIZATION_ID SOURCE_ORG_ID
, PA_DATE SOURCE_PA_DATE
, ATTRIBUTE1 SOURCE_ATTRIBUTE1
, IND_COST_CODE SOURCE_IND_COST_CODE
, EI_EXPENDITURE_TYPE SOURCE_EXPENDITURE_TYPE
, ICC_EXPENDITURE_TYPE SOURCE_IND_EXPENDITURE_TYPE
, COST_BASE SOURCE_COST_BASE
, COMPILED_MULTIPLIER SOURCE_COMPILED_MULTIPLIER
, IND_RATE_SCH_ID SOURCE_IND_RATE_SCH_ID
, IND_RATE_SCH_REVISION_ID SOURCE_IND_RATE_SCH_REV_ID
, EXPENDITURE_ITEM_ID SOURCE_EXP_ITEM_ID
, LINE_NUM SOURCE_LINE_NUM
, EXPENDITURE_ITEM_DATE SOURCE_EXP_ITEM_DATE
, BURDEN_COST SOURCE_BURDEN_COST
, DENOM_BURDENED_COST SOURCE_DENOM_BURDENED_COST
, ACCT_BURDENED_COST SOURCE_ACCT_BURDENED_COST
, DENOM_CURRENCY_CODE SOURCE_DENOM_CURRENCY_CODE
, ACCT_CURRENCY_CODE SOURCE_ACCT_CURRENCY_CODE
, PROJECT_CURRENCY_CODE SOURCE_PROJECT_CURRENCY_CODE
, BURDEN_SUM_SOURCE_RUN_ID SOURCE_ID
, BURDEN_SUM_REJECTION_CODE SOURCE_BURDEN_REJECT_CODE
, DEST_PROJECT_ID DEST_PROJECT_ID
, DEST_TASK_ID DEST_TASK_ID
, ORGANIZATION_ID DEST_ORG_ID
, PA_DATE DEST_PA_DATE
, ATTRIBUTE1 DEST_ATTRIBUTE1
, ICC_EXPENDITURE_TYPE DEST_IND_EXPENDITURE_TYPE
, PROJECT_ID ||TASK_ID|| ORGANIZATION_ID|| PA_DATE|| NVL(DENOM_CURRENCY_CODE
, ACCT_CURRENCY_CODE) || ACCT_CURRENCY_CODE || PROJECT_CURRENCY_CODE || IND_COST_CODE DEST_SUMMARY_GROUP
FROM PA_CDL_BURDEN_DETAIL_V

Columns