PJF_COST_BASE_V

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name
COST_BASE_ASSGN_ID IND_STRUCTURE_NAME COST_BASE COST_BASE_TYPE

Query

SQL_Statement
SELECT rownum cost_base_assgn_id, ind_structure_name, cost_base, cost_base_type FROM ( SELECT DISTINCT ind_structure_name, cost_base, cost_base_type FROM pjf_cost_base_cost_codes UNION SELECT DISTINCT ind_structure_name, cost_base, cost_base_type FROM pjf_cost_base_exp_types cbet)