PJC_CDL_BURDEN_SUMMARY_V

Details

• Schema: FUSION

• Object owner: PJC

• Object type: VIEW

Columns

Name

SOURCE_BU_ID SOURCE_PROJECT_ID SOURCE_TASK_ID SOURCE_ORG_ID SOURCE_PRVDR_GL_DATE SOURCE_PA_DATE SOURCE_PA_PERIOD_NAME SOURCE_ATTRIBUTE1 SOURCE_ATTRIBUTE2 SOURCE_ATTRIBUTE3 SOURCE_ATTRIBUTE4 SOURCE_ATTRIBUTE5 SOURCE_ATTRIBUTE6 SOURCE_ATTRIBUTE7 SOURCE_ATTRIBUTE8 SOURCE_ATTRIBUTE9 SOURCE_ATTRIBUTE10 SOURCE_ATTRIBUTE_CATEGORY SOURCE_PERSON_TYPE SOURCE_PO_LINE_ID SOURCE_SYSTEM_LINKAGE_FUNCTION SOURCE_IND_COST_CODE SOURCE_EXPENDITURE_TYPE_ID SOURCE_IND_EXPENDITURE_TYPE_ID SOURCE_COST_BASE SOURCE_COMPILED_MULTIPLIER SOURCE_IND_RATE_SCH_ID SOURCE_IND_RATE_SCH_REV_ID SOURCE_EXP_ITEM_ID SOURCE_LINE_NUM SOURCE_EXP_ITEM_DATE SOURCE_BURDEN_COST SOURCE_DENOM_BURDENED_COST SOURCE_ACCT_BURDENED_COST SOURCE_PROJECT_BURDENED_COST SOURCE_DENOM_CURRENCY_CODE SOURCE_ACCT_CURRENCY_CODE SOURCE_PROJECT_CURRENCY_CODE SOURCE_PROJFUNC_CURRENCY_CODE SOURCE_ID SOURCE_BURDEN_REJECT_CODE SOURCE_VENDOR_ID DEST_ORG_ID DEST_PA_DATE DEST_ATTRIBUTE1 DEST_IND_EXPENDITURE_TYPE_ID BILLABLE_FLAG CAPITALIZABLE_FLAG CONTRACT_ID CONTRACT_LINE_ID SOURCE_ADJUSTMENT_TYPE CONTEXT_CATEGORY USER_DEF_ATTRIBUTE1 USER_DEF_ATTRIBUTE2 USER_DEF_ATTRIBUTE3 USER_DEF_ATTRIBUTE4 USER_DEF_ATTRIBUTE5 USER_DEF_ATTRIBUTE6 USER_DEF_ATTRIBUTE7 USER_DEF_ATTRIBUTE8 USER_DEF_ATTRIBUTE9 USER_DEF_ATTRIBUTE10 DEST_SUMMARY_GROUP SOURCE_REQUEST_ID SOURCE_JOB_ID SOURCE_NL_RESOURCE_ID SOURCE_NL_RESOURCE_ORG_ID SOURCE_WIP_RESOURCE_ID SOURCE_INCURRED_BY_PERSON_ID SOURCE_INVENTORY_ITEM_ID SRC_ACCT_RATE_DATE SRC_ACCT_RATE_TYPE SRC_ACCT_EXCHANGE_RATE SRC_PROJECT_RATE_DATE SRC_PROJECT_RATE_TYPE SRC_PROJECT_EXCHANGE_RATE SRC_PROJFUNC_COST_RATE_DATE SRC_PROJFUNC_COST_RATE_TYPE SRC_PROJFUNC_COST_XCHNG_RATE DATA_SET_ID RESERVED_ATTRIBUTE1 EXPENDITURE_ITEM_DATE2

Query

SQL_Statement

SELECT org_id source_bu_id, project_id source_project_id, task_id source_task_id, organization_id source_org_id, prvdr_gl_date source_prvdr_gl_date, 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_id source_expenditure_type_id, icc_expenditure_type_id source_ind_expenditure_type_id, 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, 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, NULL source_vendor_id, organization_id dest_org_id, pa_date dest_pa_date, attribute1 dest_attribute1, icc_expenditure_type_id dest_ind_expenditure_type_id, billable_flag, capitalizable_flag, contract_id, contract_line_id, adjustment_type source_adjustment_type, context_category, user_def_attribute1, user_def_attribute2, user_def_attribute3, user_def_attribute4, user_def_attribute5, user_def_attribute6, user_def_attribute7, user_def_attribute8, user_def_attribute9, user_def_attribute10, billable_flag || capitalizable_flag|| project_id || task_id|| organization_id|| pa_period_name|| nvl(denom_currency_code,acct_currency_code) || acct_currency_code || ind_cost_code || system_linkage_function || person_type || po_line_id || data_set_id || contract_id || reserved_attribute1 || pjc_burden_costing.get_custom_burden_grp_val(pjc_cdl_burden_detail_v.expenditure_item_id) dest_summary_group, request_id source_request_id, job_id source_job_id, non_labor_resource_id source_nl_resource_id, non_labor_resource_org_id source_nl_resource_org_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, data_set_id data_set_id, reserved_attribute1, expenditure_item_date2 FROM PJC_CDL_BURDEN_DETAIL_V