VIEW: APPS.PA_BURDEN_DETAILS_BASE_V

Source

View Text - Preformatted

SELECT ics.ind_compiled_set_id ,o.name ,ics.organization_id ,cbet.expenditure_type ,cb.cost_base ,cb.report_sort_order ,cm.ind_cost_code ,cm.precedence ,cm.multiplier ,cm.compiled_multiplier ,irs.ind_rate_sch_name ,irs.ind_rate_sch_id ,irsr.ind_rate_sch_revision ,irsr.ind_rate_sch_revision_id ,cbet.cost_plus_structure FROM hr_organization_units o, pa_compiled_multipliers cm, pa_cost_base_exp_types cbet, pa_cost_bases cb, pa_ind_compiled_sets ics, pa_ind_rate_sch_revisions irsr, pa_ind_rate_schedules_all_bg irs WHERE cm.ind_compiled_set_id = ics.ind_compiled_set_id AND ics.ind_rate_sch_revision_id = irsr.ind_rate_sch_revision_id AND irsr.cost_plus_structure = cbet.cost_plus_structure AND cm.cost_base = cbet.cost_base AND cbet.cost_base_type = 'INDIRECT COST' AND irs.ind_rate_sch_id = irsr.ind_rate_sch_id AND ics.organization_id = o.organization_id AND cb.cost_base = cbet.cost_base AND cb.cost_base = ics.cost_base AND cb.cost_base_type = cbet.cost_base_type

View Text - HTML Formatted

SELECT ICS.IND_COMPILED_SET_ID
, O.NAME
, ICS.ORGANIZATION_ID
, CBET.EXPENDITURE_TYPE
, CB.COST_BASE
, CB.REPORT_SORT_ORDER
, CM.IND_COST_CODE
, CM.PRECEDENCE
, CM.MULTIPLIER
, CM.COMPILED_MULTIPLIER
, IRS.IND_RATE_SCH_NAME
, IRS.IND_RATE_SCH_ID
, IRSR.IND_RATE_SCH_REVISION
, IRSR.IND_RATE_SCH_REVISION_ID
, CBET.COST_PLUS_STRUCTURE
FROM HR_ORGANIZATION_UNITS O
, PA_COMPILED_MULTIPLIERS CM
, PA_COST_BASE_EXP_TYPES CBET
, PA_COST_BASES CB
, PA_IND_COMPILED_SETS ICS
, PA_IND_RATE_SCH_REVISIONS IRSR
, PA_IND_RATE_SCHEDULES_ALL_BG IRS
WHERE CM.IND_COMPILED_SET_ID = ICS.IND_COMPILED_SET_ID
AND ICS.IND_RATE_SCH_REVISION_ID = IRSR.IND_RATE_SCH_REVISION_ID
AND IRSR.COST_PLUS_STRUCTURE = CBET.COST_PLUS_STRUCTURE
AND CM.COST_BASE = CBET.COST_BASE
AND CBET.COST_BASE_TYPE = 'INDIRECT COST'
AND IRS.IND_RATE_SCH_ID = IRSR.IND_RATE_SCH_ID
AND ICS.ORGANIZATION_ID = O.ORGANIZATION_ID
AND CB.COST_BASE = CBET.COST_BASE
AND CB.COST_BASE = ICS.COST_BASE
AND CB.COST_BASE_TYPE = CBET.COST_BASE_TYPE