VIEW: APPS.PA_CMT_BURDEN_SUMMARY_V

Source

View Text - Preformatted

SELECT project_id source_project_id , task_id source_task_id , organization_id source_org_id , pa_period source_pa_period , gl_period source_gl_period , transaction_source source_txn_source , line_type source_line_type , ind_cost_code source_ind_cost_code , original_txn_reference1 source_txn_ref1 , original_txn_reference2 source_txn_ref2 , original_txn_reference3 source_txn_ref3 , cmt_expenditure_type source_expenditure_type , icc_expenditure_type source_ind_expenditure_type , expenditure_category source_exp_category , revenue_category_code source_revenue_category , 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 , burden_cost source_burden_cost , burden_sum_source_run_id source_run_id , burden_sum_rejection_code source_burden_sum_rej_code , resource_class resource_class , system_linkage_function source_system_linkage_function , project_id dest_project_id , task_id dest_task_id , organization_id dest_org_id , icc_expenditure_type dest_ind_exp_type , original_txn_reference1 dest_txn_ref1 , pa_period dest_pa_period , gl_period dest_gl_period , transaction_source dest_txn_source , expenditure_category dest_exp_category , revenue_category_code dest_revenue_category , line_type dest_line_type , ind_cost_code dest_ind_cost_code , acct_raw_cost , acct_burdened_cost , denom_currency_code , denom_raw_cost , denom_burdened_cost , acct_currency_code , acct_rate_date , acct_rate_type , acct_exchange_rate , project_currency_code , project_rate_date , project_rate_type , project_exchange_rate , vendor_id , inventory_item_id , bom_labor_resource_id , bom_equipment_resource_id , nvl(denom_currency_code,acct_currency_code) || acct_currency_code || project_currency_code || project_id ||task_id|| organization_id||gl_period || pa_period || transaction_source || line_type ||ind_cost_code || resource_class ||system_linkage_function || PA_CLIENT_EXTN_BURDEN_RESOURCE.CLIENT_GROUPING ( null, null, null, null, null, PA_CMT_BURDEN_DETAIL_V.inventory_item_id, PA_CMT_BURDEN_DETAIL_V.vendor_id, PA_CMT_BURDEN_DETAIL_V.bom_labor_resource_id, PA_CMT_BURDEN_DETAIL_V.bom_equipment_resource_id ) dest_summary_group FROM PA_CMT_BURDEN_DETAIL_V

View Text - HTML Formatted

SELECT PROJECT_ID SOURCE_PROJECT_ID
, TASK_ID SOURCE_TASK_ID
, ORGANIZATION_ID SOURCE_ORG_ID
, PA_PERIOD SOURCE_PA_PERIOD
, GL_PERIOD SOURCE_GL_PERIOD
, TRANSACTION_SOURCE SOURCE_TXN_SOURCE
, LINE_TYPE SOURCE_LINE_TYPE
, IND_COST_CODE SOURCE_IND_COST_CODE
, ORIGINAL_TXN_REFERENCE1 SOURCE_TXN_REF1
, ORIGINAL_TXN_REFERENCE2 SOURCE_TXN_REF2
, ORIGINAL_TXN_REFERENCE3 SOURCE_TXN_REF3
, CMT_EXPENDITURE_TYPE SOURCE_EXPENDITURE_TYPE
, ICC_EXPENDITURE_TYPE SOURCE_IND_EXPENDITURE_TYPE
, EXPENDITURE_CATEGORY SOURCE_EXP_CATEGORY
, REVENUE_CATEGORY_CODE SOURCE_REVENUE_CATEGORY
, 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
, BURDEN_COST SOURCE_BURDEN_COST
, BURDEN_SUM_SOURCE_RUN_ID SOURCE_RUN_ID
, BURDEN_SUM_REJECTION_CODE SOURCE_BURDEN_SUM_REJ_CODE
, RESOURCE_CLASS RESOURCE_CLASS
, SYSTEM_LINKAGE_FUNCTION SOURCE_SYSTEM_LINKAGE_FUNCTION
, PROJECT_ID DEST_PROJECT_ID
, TASK_ID DEST_TASK_ID
, ORGANIZATION_ID DEST_ORG_ID
, ICC_EXPENDITURE_TYPE DEST_IND_EXP_TYPE
, ORIGINAL_TXN_REFERENCE1 DEST_TXN_REF1
, PA_PERIOD DEST_PA_PERIOD
, GL_PERIOD DEST_GL_PERIOD
, TRANSACTION_SOURCE DEST_TXN_SOURCE
, EXPENDITURE_CATEGORY DEST_EXP_CATEGORY
, REVENUE_CATEGORY_CODE DEST_REVENUE_CATEGORY
, LINE_TYPE DEST_LINE_TYPE
, IND_COST_CODE DEST_IND_COST_CODE
, ACCT_RAW_COST
, ACCT_BURDENED_COST
, DENOM_CURRENCY_CODE
, DENOM_RAW_COST
, DENOM_BURDENED_COST
, ACCT_CURRENCY_CODE
, ACCT_RATE_DATE
, ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE
, PROJECT_CURRENCY_CODE
, PROJECT_RATE_DATE
, PROJECT_RATE_TYPE
, PROJECT_EXCHANGE_RATE
, VENDOR_ID
, INVENTORY_ITEM_ID
, BOM_LABOR_RESOURCE_ID
, BOM_EQUIPMENT_RESOURCE_ID
, NVL(DENOM_CURRENCY_CODE
, ACCT_CURRENCY_CODE) || ACCT_CURRENCY_CODE || PROJECT_CURRENCY_CODE || PROJECT_ID ||TASK_ID|| ORGANIZATION_ID||GL_PERIOD || PA_PERIOD || TRANSACTION_SOURCE || LINE_TYPE ||IND_COST_CODE || RESOURCE_CLASS ||SYSTEM_LINKAGE_FUNCTION || PA_CLIENT_EXTN_BURDEN_RESOURCE.CLIENT_GROUPING ( NULL
, NULL
, NULL
, NULL
, NULL
, PA_CMT_BURDEN_DETAIL_V.INVENTORY_ITEM_ID
, PA_CMT_BURDEN_DETAIL_V.VENDOR_ID
, PA_CMT_BURDEN_DETAIL_V.BOM_LABOR_RESOURCE_ID
, PA_CMT_BURDEN_DETAIL_V.BOM_EQUIPMENT_RESOURCE_ID ) DEST_SUMMARY_GROUP
FROM PA_CMT_BURDEN_DETAIL_V