VIEW: APPS.PA_CMT_BURDEN_DETAIL_V

Source

View Text - Preformatted

SELECT cmt.project_id , cmt.task_id , cmt.organization_id , cmt.pa_period , cmt.gl_period , cmt.transaction_source , cmt.line_type , cm.ind_cost_code , cmt.original_txn_reference1 , cmt.original_txn_reference2 , cmt.original_txn_reference3 , cmt.expenditure_type cmt_expenditure_type , icc.expenditure_type icc_expenditure_type , et.expenditure_category , et.revenue_category_code , cb.cost_base , cm.compiled_multiplier , irs.ind_rate_sch_id , irsr.ind_rate_sch_revision_id , cmt.tot_cmt_raw_cost * cm.compiled_multiplier burden_cost , cmt.burden_sum_source_run_id , cmt.burden_sum_rejection_code , cmt.acct_raw_cost , cmt.acct_raw_cost * cm.compiled_multiplier acct_burdened_cost , cmt.denom_currency_code , cmt.denom_raw_cost , cmt.denom_raw_cost * cm.compiled_multiplier denom_burdened_cost , cmt.acct_currency_code , cmt.acct_rate_date , cmt.acct_rate_type , cmt.acct_exchange_rate , cmt.project_currency_code , cmt.project_rate_date , cmt.project_rate_type , cmt.project_exchange_rate , cmt.resource_class , cmt.system_linkage_function , cmt.vendor_id , cmt.inventory_item_id , cmt.bom_labor_resource_id , cmt.bom_equipment_resource_id from pa_ind_rate_sch_revisions irsr, pa_cost_bases cb, pa_expenditure_types et, pa_ind_cost_codes icc, pa_cost_base_exp_types cbet, pa_ind_rate_schedules_all_bg irs, pa_ind_compiled_sets ics, pa_compiled_multipliers cm, pa_commitment_txns cmt, pa_project_types_all pt, pa_projects_all p WHERE irsr.cost_plus_structure = cbet.cost_plus_structure and cb.cost_base = cbet.cost_base and cb.cost_base_type = cbet.cost_base_type and et.expenditure_type = icc.expenditure_type and icc.ind_cost_code = cm.ind_cost_code and cbet.cost_base = cm.cost_base and cbet.cost_base_type = 'INDIRECT COST' and cbet.expenditure_type = cmt.expenditure_type and irs.ind_rate_sch_id = irsr.ind_rate_sch_id and ics.ind_rate_sch_revision_id = irsr.ind_rate_sch_revision_id and ics.organization_id = cmt.organization_id and ics.cost_base = cbet.cost_base and ics.ind_compiled_set_id = cmt.cmt_ind_compiled_set_id and ics.status = 'A' and cm.ind_compiled_set_id = cmt.cmt_ind_compiled_set_id And cmt.burden_sum_rejection_code is NULL and nvl(cmt.denom_raw_cost,0) <> 0 and cmt.burden_sum_source_run_id+0 = -9999 and cmt.project_id = p.project_id and pt.burden_amt_display_method = 'D' and pt.project_type = p.project_type and NVL(pt.org_id, -99) = NVL(p.org_id, -99) and p.project_id = pa_burden_costing.get_current_project_id()

View Text - HTML Formatted

SELECT CMT.PROJECT_ID
, CMT.TASK_ID
, CMT.ORGANIZATION_ID
, CMT.PA_PERIOD
, CMT.GL_PERIOD
, CMT.TRANSACTION_SOURCE
, CMT.LINE_TYPE
, CM.IND_COST_CODE
, CMT.ORIGINAL_TXN_REFERENCE1
, CMT.ORIGINAL_TXN_REFERENCE2
, CMT.ORIGINAL_TXN_REFERENCE3
, CMT.EXPENDITURE_TYPE CMT_EXPENDITURE_TYPE
, ICC.EXPENDITURE_TYPE ICC_EXPENDITURE_TYPE
, ET.EXPENDITURE_CATEGORY
, ET.REVENUE_CATEGORY_CODE
, CB.COST_BASE
, CM.COMPILED_MULTIPLIER
, IRS.IND_RATE_SCH_ID
, IRSR.IND_RATE_SCH_REVISION_ID
, CMT.TOT_CMT_RAW_COST * CM.COMPILED_MULTIPLIER BURDEN_COST
, CMT.BURDEN_SUM_SOURCE_RUN_ID
, CMT.BURDEN_SUM_REJECTION_CODE
, CMT.ACCT_RAW_COST
, CMT.ACCT_RAW_COST * CM.COMPILED_MULTIPLIER ACCT_BURDENED_COST
, CMT.DENOM_CURRENCY_CODE
, CMT.DENOM_RAW_COST
, CMT.DENOM_RAW_COST * CM.COMPILED_MULTIPLIER DENOM_BURDENED_COST
, CMT.ACCT_CURRENCY_CODE
, CMT.ACCT_RATE_DATE
, CMT.ACCT_RATE_TYPE
, CMT.ACCT_EXCHANGE_RATE
, CMT.PROJECT_CURRENCY_CODE
, CMT.PROJECT_RATE_DATE
, CMT.PROJECT_RATE_TYPE
, CMT.PROJECT_EXCHANGE_RATE
, CMT.RESOURCE_CLASS
, CMT.SYSTEM_LINKAGE_FUNCTION
, CMT.VENDOR_ID
, CMT.INVENTORY_ITEM_ID
, CMT.BOM_LABOR_RESOURCE_ID
, CMT.BOM_EQUIPMENT_RESOURCE_ID
FROM PA_IND_RATE_SCH_REVISIONS IRSR
, PA_COST_BASES CB
, PA_EXPENDITURE_TYPES ET
, PA_IND_COST_CODES ICC
, PA_COST_BASE_EXP_TYPES CBET
, PA_IND_RATE_SCHEDULES_ALL_BG IRS
, PA_IND_COMPILED_SETS ICS
, PA_COMPILED_MULTIPLIERS CM
, PA_COMMITMENT_TXNS CMT
, PA_PROJECT_TYPES_ALL PT
, PA_PROJECTS_ALL P
WHERE IRSR.COST_PLUS_STRUCTURE = CBET.COST_PLUS_STRUCTURE
AND CB.COST_BASE = CBET.COST_BASE
AND CB.COST_BASE_TYPE = CBET.COST_BASE_TYPE
AND ET.EXPENDITURE_TYPE = ICC.EXPENDITURE_TYPE
AND ICC.IND_COST_CODE = CM.IND_COST_CODE
AND CBET.COST_BASE = CM.COST_BASE
AND CBET.COST_BASE_TYPE = 'INDIRECT COST'
AND CBET.EXPENDITURE_TYPE = CMT.EXPENDITURE_TYPE
AND IRS.IND_RATE_SCH_ID = IRSR.IND_RATE_SCH_ID
AND ICS.IND_RATE_SCH_REVISION_ID = IRSR.IND_RATE_SCH_REVISION_ID
AND ICS.ORGANIZATION_ID = CMT.ORGANIZATION_ID
AND ICS.COST_BASE = CBET.COST_BASE
AND ICS.IND_COMPILED_SET_ID = CMT.CMT_IND_COMPILED_SET_ID
AND ICS.STATUS = 'A'
AND CM.IND_COMPILED_SET_ID = CMT.CMT_IND_COMPILED_SET_ID
AND CMT.BURDEN_SUM_REJECTION_CODE IS NULL
AND NVL(CMT.DENOM_RAW_COST
, 0) <> 0
AND CMT.BURDEN_SUM_SOURCE_RUN_ID+0 = -9999
AND CMT.PROJECT_ID = P.PROJECT_ID
AND PT.BURDEN_AMT_DISPLAY_METHOD = 'D'
AND PT.PROJECT_TYPE = P.PROJECT_TYPE
AND NVL(PT.ORG_ID
, -99) = NVL(P.ORG_ID
, -99)
AND P.PROJECT_ID = PA_BURDEN_COSTING.GET_CURRENT_PROJECT_ID()