View: PA_CDL_BURDEN_SUMMARY_V

Product:	PA - Projects
Description:	Summarization criteria for burden summarization of expenditure items.
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
, PA_PERIOD_NAME SOURCE_PA_PERIOD_NAME
, ATTRIBUTE1 SOURCE_ATTRIBUTE1
, ATTRIBUTE2 SOURCE_ATTRIBUTE2
, ATTRIBUTE3 SOURCE_ATTRIBUTE3
, ATTRIBUTE4 SOURCE_ATTRIBUTE4
, ATTRIBUTE5 SOURCE_ATTRIBUTE5
, ATTRIBUTE6 SOURCE_ATTRIBUTE6
, ATTRIBUTE7 SOURCE_ATTRIBUTE7
, ATTRIBUTE8 SOURCE_ATTRIBUTE8
, ATTRIBUTE9 SOURCE_ATTRIBUTE9
, ATTRIBUTE10 SOURCE_ATTRIBUTE10
, ATTRIBUTE_CATEGORY SOURCE_ATTRIBUTE_CATEGORY
, PERSON_TYPE SOURCE_PERSON_TYPE
, PO_LINE_ID SOURCE_PO_LINE_ID
, SYSTEM_LINKAGE_FUNCTION SOURCE_SYSTEM_LINKAGE_FUNCTION
, 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
, 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
, PROJECT_BURDENED_COST SOURCE_PROJECT_BURDENED_COST
, DENOM_CURRENCY_CODE SOURCE_DENOM_CURRENCY_CODE
, ACCT_CURRENCY_CODE SOURCE_ACCT_CURRENCY_CODE
, PROJECT_CURRENCY_CODE SOURCE_PROJECT_CURRENCY_CODE
, PROJFUNC_CURRENCY_CODE SOURCE_PROJFUNC_CURRENCY_CODE
, BURDEN_SUM_SOURCE_RUN_ID SOURCE_ID
, BURDEN_SUM_REJECTION_CODE SOURCE_BURDEN_REJECT_CODE
, SYSTEM_REFERENCE1 SOURCE_VENDOR_ID
, ORGANIZATION_ID DEST_ORG_ID
, PA_DATE DEST_PA_DATE
, ATTRIBUTE1 DEST_ATTRIBUTE1
, ICC_EXPENDITURE_TYPE DEST_IND_EXPENDITURE_TYPE
, BILLABLE_FLAG
, ADJUSTMENT_TYPE SOURCE_ADJUSTMENT_TYPE
, BILLABLE_FLAG || PROJECT_ID ||TASK_ID|| ORGANIZATION_ID|| PA_PERIOD_NAME|| NVL(DENOM_CURRENCY_CODE
, ACCT_CURRENCY_CODE) || ACCT_CURRENCY_CODE || PROJECT_CURRENCY_CODE || PROJFUNC_CURRENCY_CODE || IND_COST_CODE || SYSTEM_LINKAGE_FUNCTION || SYSTEM_REFERENCE1 || PERSON_TYPE || PO_LINE_ID || PA_CLIENT_EXTN_BURDEN_SUMMARY.CLIENT_GROUPING ( PA_CDL_BURDEN_DETAIL_V.EI_EXPENDITURE_TYPE
, PA_CDL_BURDEN_DETAIL_V.ICC_EXPENDITURE_TYPE
, PA_CDL_BURDEN_DETAIL_V.ATTRIBUTE1
, PA_CDL_BURDEN_DETAIL_V.ATTRIBUTE2
, PA_CDL_BURDEN_DETAIL_V.ATTRIBUTE3
, PA_CDL_BURDEN_DETAIL_V.ATTRIBUTE4
, PA_CDL_BURDEN_DETAIL_V.ATTRIBUTE5
, PA_CDL_BURDEN_DETAIL_V.ATTRIBUTE6
, PA_CDL_BURDEN_DETAIL_V.ATTRIBUTE7
, PA_CDL_BURDEN_DETAIL_V.ATTRIBUTE8
, PA_CDL_BURDEN_DETAIL_V.ATTRIBUTE9
, PA_CDL_BURDEN_DETAIL_V.ATTRIBUTE10
, PA_CDL_BURDEN_DETAIL_V.ATTRIBUTE_CATEGORY
, PA_CDL_BURDEN_DETAIL_V.EXPENDITURE_ITEM_DATE
, PA_CDL_BURDEN_DETAIL_V.ACCT_RATE_DATE
, PA_CDL_BURDEN_DETAIL_V.ACCT_RATE_TYPE
, PA_CDL_BURDEN_DETAIL_V.ACCT_EXCHANGE_RATE
, PA_CDL_BURDEN_DETAIL_V.PROJECT_RATE_DATE
, PA_CDL_BURDEN_DETAIL_V.PROJECT_RATE_TYPE
, PA_CDL_BURDEN_DETAIL_V.PROJECT_EXCHANGE_RATE
, PA_CDL_BURDEN_DETAIL_V.PROJFUNC_COST_RATE_DATE
, PA_CDL_BURDEN_DETAIL_V.PROJFUNC_COST_RATE_TYPE
, PA_CDL_BURDEN_DETAIL_V.PROJFUNC_COST_EXCHANGE_RATE ) || PA_CLIENT_EXTN_BURDEN_RESOURCE.CLIENT_GROUPING ( PA_CDL_BURDEN_DETAIL_V.JOB_ID
, PA_CDL_BURDEN_DETAIL_V.NON_LABOR_RESOURCE
, PA_CDL_BURDEN_DETAIL_V.NON_LABOR_RESOURCE_ORGN_ID
, PA_CDL_BURDEN_DETAIL_V.WIP_RESOURCE_ID
, PA_CDL_BURDEN_DETAIL_V.INCURRED_BY_PERSON_ID
, PA_CDL_BURDEN_DETAIL_V.INVENTORY_ITEM_ID
, NULL
, NULL
, NULL ) DEST_SUMMARY_GROUP
, BILLABLE_FLAG || PROJECT_ID ||TASK_ID|| ORGANIZATION_ID|| PA_PERIOD_NAME|| NVL(DENOM_CURRENCY_CODE
, ACCT_CURRENCY_CODE) || ACCT_CURRENCY_CODE || PROJECT_CURRENCY_CODE || PROJFUNC_CURRENCY_CODE || IND_COST_CODE || SYSTEM_LINKAGE_FUNCTION || SYSTEM_REFERENCE1 || PERSON_TYPE || PO_LINE_ID || ADJUSTMENT_TYPE || PA_CLIENT_EXTN_BURDEN_SUMMARY.CLIENT_GROUPING ( PA_CDL_BURDEN_DETAIL_V.EI_EXPENDITURE_TYPE
, PA_CDL_BURDEN_DETAIL_V.ICC_EXPENDITURE_TYPE
, PA_CDL_BURDEN_DETAIL_V.ATTRIBUTE1
, PA_CDL_BURDEN_DETAIL_V.ATTRIBUTE2
, PA_CDL_BURDEN_DETAIL_V.ATTRIBUTE3
, PA_CDL_BURDEN_DETAIL_V.ATTRIBUTE4
, PA_CDL_BURDEN_DETAIL_V.ATTRIBUTE5
, PA_CDL_BURDEN_DETAIL_V.ATTRIBUTE6
, PA_CDL_BURDEN_DETAIL_V.ATTRIBUTE7
, PA_CDL_BURDEN_DETAIL_V.ATTRIBUTE8
, PA_CDL_BURDEN_DETAIL_V.ATTRIBUTE9
, PA_CDL_BURDEN_DETAIL_V.ATTRIBUTE10
, PA_CDL_BURDEN_DETAIL_V.ATTRIBUTE_CATEGORY
, PA_CDL_BURDEN_DETAIL_V.EXPENDITURE_ITEM_DATE
, PA_CDL_BURDEN_DETAIL_V.ACCT_RATE_DATE
, PA_CDL_BURDEN_DETAIL_V.ACCT_RATE_TYPE
, PA_CDL_BURDEN_DETAIL_V.ACCT_EXCHANGE_RATE
, PA_CDL_BURDEN_DETAIL_V.PROJECT_RATE_DATE
, PA_CDL_BURDEN_DETAIL_V.PROJECT_RATE_TYPE
, PA_CDL_BURDEN_DETAIL_V.PROJECT_EXCHANGE_RATE
, PA_CDL_BURDEN_DETAIL_V.PROJFUNC_COST_RATE_DATE
, PA_CDL_BURDEN_DETAIL_V.PROJFUNC_COST_RATE_TYPE
, PA_CDL_BURDEN_DETAIL_V.PROJFUNC_COST_EXCHANGE_RATE ) || PA_CLIENT_EXTN_BURDEN_RESOURCE.CLIENT_GROUPING ( PA_CDL_BURDEN_DETAIL_V.JOB_ID
, PA_CDL_BURDEN_DETAIL_V.NON_LABOR_RESOURCE
, PA_CDL_BURDEN_DETAIL_V.NON_LABOR_RESOURCE_ORGN_ID
, PA_CDL_BURDEN_DETAIL_V.WIP_RESOURCE_ID
, PA_CDL_BURDEN_DETAIL_V.INCURRED_BY_PERSON_ID
, PA_CDL_BURDEN_DETAIL_V.INVENTORY_ITEM_ID
, NULL
, NULL
, NULL ) DEST_SUMMARY_GROUP_RESUM
, REQUEST_ID SOURCE_REQUEST_ID
, JOB_ID SOURCE_JOB_ID
, NON_LABOR_RESOURCE SOURCE_NL_RESOURCE
, NON_LABOR_RESOURCE_ORGN_ID SOURCE_NL_RESOURCE_ORGN_ID
, WIP_RESOURCE_ID SOURCE_WIP_RESOURCE_ID
, INCURRED_BY_PERSON_ID SOURCE_INCURRED_BY_PERSON_ID
, INVENTORY_ITEM_ID SOURCE_INVENTORY_ITEM_ID
, ACCT_RATE_DATE SRC_ACCT_RATE_DATE
, ACCT_RATE_TYPE SRC_ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE SRC_ACCT_EXCHANGE_RATE
, PROJECT_RATE_DATE SRC_PROJECT_RATE_DATE
, PROJECT_RATE_TYPE SRC_PROJECT_RATE_TYPE
, PROJECT_EXCHANGE_RATE SRC_PROJECT_EXCHANGE_RATE
, PROJFUNC_COST_RATE_DATE SRC_PROJFUNC_COST_RATE_DATE
, PROJFUNC_COST_RATE_TYPE SRC_PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_EXCHANGE_RATE SRC_PROJFUNC_COST_XCHNG_RATE
FROM PA_CDL_BURDEN_DETAIL_V

Columns