VIEW: APPS.PA_CDL_BURDEN_SUMMARY_V

Source

View Text - Preformatted

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|| cbs_element_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|| cbs_element_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 , cbs_element_id FROM PA_CDL_BURDEN_DETAIL_V

View Text - HTML Formatted

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|| CBS_ELEMENT_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|| CBS_ELEMENT_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
, CBS_ELEMENT_ID
FROM PA_CDL_BURDEN_DETAIL_V