PJC_CDL_BURDEN_SUM_EXTN

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 EXTN_CURRENT_RUN_ID EXTN_CALC_BURDEN_STATUS DATA_SET_ID RESERVED_ATTRIBUTE1 EXPENDITURE_ITEM_DATE2

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

EXTN_CURRENT_RUN_ID

EXTN_CALC_BURDEN_STATUS

DATA_SET_ID

RESERVED_ATTRIBUTE1

EXPENDITURE_ITEM_DATE2

Query

SQL_Statement
SELECT bre.transaction_org_id source_bu_id, bre.project_id source_project_id, bre.task_id source_task_id, bre.organization_id source_org_id, cdl.prvdr_gl_date source_prvdr_gl_date, cdl.prvdr_pa_date source_pa_date, DECODE(cdl.prev_ind_compiled_set_id, NULL, cdl.prvdr_pa_period_name, NVL(p.period_name, cdl.prvdr_pa_period_name)) source_pa_period_name, ei.attribute1 source_attribute1, ei.attribute2 source_attribute2, ei.attribute3 source_attribute3, ei.attribute4 source_attribute4, ei.attribute5 source_attribute5, ei.attribute6 source_attribute6, ei.attribute7 source_attribute7, ei.attribute8 source_attribute8, ei.attribute9 source_attribute9, ei.attribute10 source_attribute10, ei.attribute_category source_attribute_category, ei.person_type source_person_type, NULL source_po_line_id, ei.system_linkage_function source_system_linkage_function, bre.ind_cost_code source_ind_cost_code, bre.expenditure_type_id source_expenditure_type_id, bre.icc_expenditure_type_id source_ind_expenditure_type_id, bre.cost_base source_cost_base, bre.compiled_multiplier source_compiled_multiplier, bre.ind_rate_sch_id source_ind_rate_sch_id, bre.ind_rate_sch_revision_id source_ind_rate_sch_rev_id, bre.transaction_id source_exp_item_id, bre.line_num source_line_num, bre.transaction_date source_exp_item_date, bre.projfunc_burdened_cost source_burden_cost, bre.new_burden_cost source_denom_burdened_cost, bre.acct_burdened_cost source_acct_burdened_cost, bre.project_burdened_cost source_project_burdened_cost, bre.denom_currency_code source_denom_currency_code, bre.acct_currency_code source_acct_currency_code, bre.project_currency_code source_project_currency_code, bre.projfunc_currency_code source_projfunc_currency_code, cdl.burden_sum_source_run_id source_id, cdl.burden_sum_rejection_code source_burden_reject_code, NULL source_vendor_id, bre.organization_id dest_org_id, cdl.prvdr_pa_date dest_pa_date, ei.attribute1 dest_attribute1, bre.icc_expenditure_type_id dest_ind_expenditure_type_id, cdl.billable_flag, cdl.capitalizable_flag, ei.contract_id contract_id, NULL contract_line_id, DECODE(ei.adjustment_type, 'BURDEN_RESUMMARIZE', ei.adjustment_type, NULL) source_adjustment_type, ei.context_category, ei.user_def_attribute1, ei.user_def_attribute2, ei.user_def_attribute3, ei.user_def_attribute4, ei.user_def_attribute5, ei.user_def_attribute6, ei.user_def_attribute7, ei.user_def_attribute8, ei.user_def_attribute9, ei.user_def_attribute10, cdl.billable_flag \|\| cdl.capitalizable_flag \|\| bre.project_id \|\| bre.task_id \|\| bre.organization_id \|\| DECODE(cdl.prev_ind_compiled_set_id, NULL, cdl.prvdr_pa_period_name, NVL(p.period_name, cdl.prvdr_pa_period_name)) \|\| NVL(cdl.denom_currency_code, cdl.acct_currency_code) \|\| bre.acct_currency_code \|\| bre.ind_cost_code \|\| ei.system_linkage_function \|\| ei.person_type \|\| cdl.data_set_id \|\| ei.contract_id \|\| ei.reserved_attribute1 \|\| NULL \|\| pjc_client_extn_burden_summary.client_grouping( bre.expenditure_type_id, bre.icc_expenditure_type_id, ei.attribute1, ei.attribute2, ei.attribute3, ei.attribute4, ei.attribute5, ei.attribute6, ei.attribute7, ei.attribute8, ei.attribute9, ei.attribute10, ei.attribute_category, bre.transaction_date, bre.acct_rate_date, bre.acct_rate_type, bre.acct_exchange_rate, bre.project_rate_date, bre.project_rate_type, bre.project_exchange_rate, bre.projfunc_cost_rate_date, bre.projfunc_cost_rate_type, bre.projfunc_cost_exchange_rate, ei.contract_id, NULL, cdl.capitalizable_flag, ei.context_category, ei.user_def_attribute1, ei.user_def_attribute2, ei.user_def_attribute3, ei.user_def_attribute4, ei.user_def_attribute5, ei.user_def_attribute6, ei.user_def_attribute7, ei.user_def_attribute8, ei.user_def_attribute9, ei.user_def_attribute10, bre.person_job_id, bre.non_labor_resource_id, bre.non_labor_resource_org_id, NULL, bre.person_id, ei.inventory_item_id, NULL, NULL, NULL, ei.reserved_attribute1 ) dest_summary_group, bre.request_id source_request_id, bre.person_job_id source_job_id, bre.non_labor_resource_id source_nl_resource_id, bre.non_labor_resource_org_id source_nl_resource_org_id, NULL source_wip_resource_id, bre.person_id source_incurred_by_person_id, ei.inventory_item_id source_inventory_item_id, bre.acct_rate_date src_acct_rate_date, bre.acct_rate_type src_acct_rate_type, bre.acct_exchange_rate src_acct_exchange_rate, bre.project_rate_date src_project_rate_date, bre.project_rate_type src_project_rate_type, bre.project_exchange_rate src_project_exchange_rate, bre.projfunc_cost_rate_date src_projfunc_cost_rate_date, bre.projfunc_cost_rate_type src_projfunc_cost_rate_type, bre.projfunc_cost_exchange_rate src_projfunc_cost_xchng_rate, bre.current_run_id extn_current_run_id, bre.calc_burden_status extn_calc_burden_status, cdl.data_set_id data_set_id, ei.reserved_attribute1 reserved_attribute1, ei.expenditure_item_date expenditure_item_date2 FROM pjf_burden_rate_extn bre, pjc_exp_items_all ei, pjc_cost_dist_lines_all cdl, pjf_p_periods_all_v p WHERE bre.transaction_id = ei.expenditure_item_id AND bre.transaction_id = cdl.expenditure_item_id AND bre.line_num = cdl.line_num AND bre.transaction_org_id = p.org_id(+) AND bre.transaction_date BETWEEN p.start_date(+) AND p.end_date(+) AND bre.calling_module = 'BURDEN-PROCESS' AND bre.calc_burden_status = 'S'

SQL_Statement

SELECT bre.transaction_org_id source_bu_id,

bre.project_id source_project_id,

bre.task_id source_task_id,

bre.organization_id source_org_id,

cdl.prvdr_gl_date source_prvdr_gl_date,

cdl.prvdr_pa_date source_pa_date,

DECODE(cdl.prev_ind_compiled_set_id, NULL, cdl.prvdr_pa_period_name, NVL(p.period_name, cdl.prvdr_pa_period_name)) source_pa_period_name,

ei.attribute1 source_attribute1,

ei.attribute2 source_attribute2,

ei.attribute3 source_attribute3,

ei.attribute4 source_attribute4,

ei.attribute5 source_attribute5,

ei.attribute6 source_attribute6,

ei.attribute7 source_attribute7,

ei.attribute8 source_attribute8,

ei.attribute9 source_attribute9,

ei.attribute10 source_attribute10,

ei.attribute_category source_attribute_category,

ei.person_type source_person_type,

NULL source_po_line_id,

ei.system_linkage_function source_system_linkage_function,

bre.ind_cost_code source_ind_cost_code,

bre.expenditure_type_id source_expenditure_type_id,

bre.icc_expenditure_type_id source_ind_expenditure_type_id,

bre.cost_base source_cost_base,

bre.compiled_multiplier source_compiled_multiplier,

bre.ind_rate_sch_id source_ind_rate_sch_id,

bre.ind_rate_sch_revision_id source_ind_rate_sch_rev_id,

bre.transaction_id source_exp_item_id,

bre.line_num source_line_num,

bre.transaction_date source_exp_item_date,

bre.projfunc_burdened_cost source_burden_cost,

bre.new_burden_cost source_denom_burdened_cost,

bre.acct_burdened_cost source_acct_burdened_cost,

bre.project_burdened_cost source_project_burdened_cost,

bre.denom_currency_code source_denom_currency_code,

bre.acct_currency_code source_acct_currency_code,

bre.project_currency_code source_project_currency_code,

bre.projfunc_currency_code source_projfunc_currency_code,

cdl.burden_sum_source_run_id source_id,

cdl.burden_sum_rejection_code source_burden_reject_code,

NULL source_vendor_id,

bre.organization_id dest_org_id,

cdl.prvdr_pa_date dest_pa_date,

ei.attribute1 dest_attribute1,

bre.icc_expenditure_type_id dest_ind_expenditure_type_id,

cdl.billable_flag,

cdl.capitalizable_flag,

ei.contract_id contract_id,

NULL contract_line_id,

DECODE(ei.adjustment_type, 'BURDEN_RESUMMARIZE', ei.adjustment_type, NULL) source_adjustment_type,

ei.context_category,

ei.user_def_attribute1,

ei.user_def_attribute2,

ei.user_def_attribute3,

ei.user_def_attribute4,

ei.user_def_attribute5,

ei.user_def_attribute6,

ei.user_def_attribute7,

ei.user_def_attribute8,

ei.user_def_attribute9,

ei.user_def_attribute10,

cdl.billable_flag ||

cdl.capitalizable_flag ||

bre.project_id ||

bre.task_id ||

bre.organization_id ||

DECODE(cdl.prev_ind_compiled_set_id, NULL, cdl.prvdr_pa_period_name, NVL(p.period_name, cdl.prvdr_pa_period_name)) ||

NVL(cdl.denom_currency_code, cdl.acct_currency_code) ||

bre.acct_currency_code ||

bre.ind_cost_code ||

ei.system_linkage_function ||

ei.person_type ||

cdl.data_set_id || ei.contract_id ||

ei.reserved_attribute1 ||

NULL ||

pjc_client_extn_burden_summary.client_grouping(

bre.expenditure_type_id,

bre.icc_expenditure_type_id,

ei.attribute1,

ei.attribute2,

ei.attribute3,

ei.attribute4,

ei.attribute5,

ei.attribute6,

ei.attribute7,

ei.attribute8,

ei.attribute9,

ei.attribute10,

ei.attribute_category,

bre.transaction_date,

bre.acct_rate_date,

bre.acct_rate_type,

bre.acct_exchange_rate,

bre.project_rate_date,

bre.project_rate_type,

bre.project_exchange_rate,

bre.projfunc_cost_rate_date,

bre.projfunc_cost_rate_type,

bre.projfunc_cost_exchange_rate,

ei.contract_id,

NULL,

cdl.capitalizable_flag,

ei.context_category,

ei.user_def_attribute1,

ei.user_def_attribute2,

ei.user_def_attribute3,

ei.user_def_attribute4,

ei.user_def_attribute5,

ei.user_def_attribute6,

ei.user_def_attribute7,

ei.user_def_attribute8,

ei.user_def_attribute9,

ei.user_def_attribute10,

bre.person_job_id,

bre.non_labor_resource_id,

bre.non_labor_resource_org_id,

NULL,

bre.person_id,

ei.inventory_item_id,

NULL,

ei.reserved_attribute1

) dest_summary_group,

bre.request_id source_request_id,

bre.person_job_id source_job_id,

bre.non_labor_resource_id source_nl_resource_id,

bre.non_labor_resource_org_id source_nl_resource_org_id,

NULL source_wip_resource_id,

bre.person_id source_incurred_by_person_id,

ei.inventory_item_id source_inventory_item_id,

bre.acct_rate_date src_acct_rate_date,

bre.acct_rate_type src_acct_rate_type,

bre.acct_exchange_rate src_acct_exchange_rate,

bre.project_rate_date src_project_rate_date,

bre.project_rate_type src_project_rate_type,

bre.project_exchange_rate src_project_exchange_rate,

bre.projfunc_cost_rate_date src_projfunc_cost_rate_date,

bre.projfunc_cost_rate_type src_projfunc_cost_rate_type,

bre.projfunc_cost_exchange_rate src_projfunc_cost_xchng_rate,

bre.current_run_id extn_current_run_id,

bre.calc_burden_status extn_calc_burden_status,

cdl.data_set_id data_set_id,

ei.reserved_attribute1 reserved_attribute1,

ei.expenditure_item_date expenditure_item_date2

FROM pjf_burden_rate_extn bre,

pjc_exp_items_all ei,

pjc_cost_dist_lines_all cdl,

pjf_p_periods_all_v p

WHERE bre.transaction_id = ei.expenditure_item_id

AND bre.transaction_id = cdl.expenditure_item_id

AND bre.line_num = cdl.line_num

AND bre.transaction_org_id = p.org_id(+)

AND bre.transaction_date BETWEEN p.start_date(+) AND p.end_date(+)

AND bre.calling_module = 'BURDEN-PROCESS'

AND bre.calc_burden_status = 'S'