Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table RC_LN_COST_V (RC_ID, COST_TYPE, AMOUNT, REC_AMT) as
select 1837161, 'Commissions', 100, 50 from dual
union all
select 1837161, '3rd Party Software Usage TERMLIC Costs', 500, 99 from dual
union all
select 1837162, 'Commissions', 42, 0 from dual
3 rows affected

WITH TABLE1 AS (
SELECT RC_ID, COST_TYPE AS COST_TYPE, SUM(AMOUNT) AS COST_AMOUNT, SUM(REC_AMT) AS COST_RELEASED
FROM RC_LN_COST_V
WHERE RC_ID = 1837161
GROUP BY RC_ID, COST_TYPE)

SELECT *
FROM TABLE1
PIVOT (SUM(COST_AMOUNT),SUM(COST_RELEASED) FOR COST_TYPE IN ('Commissions','Commissions Adjustment','Commissions Adjustment2','Fringe Commissions','Fringe Cost Adjustment','Fringe Cost Adjustment2','Install Costs Estimate',
'3rd Party License Costs','3rd Party Software Usage TERMLIC Costs'))
ORDER BY RC_ID;
ORA-00918: column ambiguously defined

WITH TABLE1 AS (
SELECT RC_ID, COST_TYPE AS COST_TYPE, SUM(AMOUNT) AS COST_AMOUNT, SUM(REC_AMT) AS COST_RELEASED
FROM RC_LN_COST_V
WHERE RC_ID = 1837161
GROUP BY RC_ID, COST_TYPE)

SELECT *
FROM TABLE1
PIVOT (SUM(COST_AMOUNT) FOR COST_TYPE IN ('Commissions'))
ORDER BY RC_ID;


RC_ID
COST_RELEASED
'Commissions'


1837161
50
100

1837161
99
null


WITH TABLE1 AS (
SELECT RC_ID, COST_TYPE AS COST_TYPE, SUM(AMOUNT) AS COST_AMOUNT, SUM(REC_AMT) AS COST_RELEASED
FROM RC_LN_COST_V
WHERE RC_ID = 1837161
GROUP BY RC_ID, COST_TYPE)

SELECT *
FROM TABLE1
PIVOT (SUM(COST_RELEASED) FOR COST_TYPE IN ('Commissions'))
ORDER BY RC_ID;


RC_ID
COST_AMOUNT
'Commissions'


1837161
100
50

1837161
500
null


WITH TABLE1 AS (
SELECT RC_ID, COST_TYPE AS COST_TYPE, SUM(AMOUNT) AS COST_AMOUNT, SUM(REC_AMT) AS COST_RELEASED
FROM RC_LN_COST_V
WHERE RC_ID = 1837161
GROUP BY RC_ID, COST_TYPE)

SELECT *
FROM TABLE1
PIVOT (SUM(COST_AMOUNT),SUM(COST_RELEASED) FOR COST_TYPE IN ('Commissions'))
ORDER BY RC_ID;
ORA-00918: column ambiguously defined

WITH TABLE1 AS (
SELECT RC_ID, COST_TYPE AS COST_TYPE, SUM(AMOUNT) AS COST_AMOUNT, SUM(REC_AMT) AS COST_RELEASED
FROM RC_LN_COST_V
WHERE RC_ID = 1837161
GROUP BY RC_ID, COST_TYPE)

SELECT *
FROM TABLE1
PIVOT (SUM(COST_AMOUNT) AS SUM1,SUM(COST_RELEASED) AS SUM2 FOR COST_TYPE IN ('Commissions'))
ORDER BY RC_ID;


RC_ID
'Commissions'_SUM1
'Commissions'_SUM2


1837161
100
50


WITH TABLE1 AS (
SELECT RC_ID, COST_TYPE AS COST_TYPE, SUM(AMOUNT) AS COST_AMOUNT, SUM(REC_AMT) AS COST_RELEASED
FROM RC_LN_COST_V
WHERE RC_ID = 1837161
GROUP BY RC_ID, COST_TYPE)

SELECT *
FROM TABLE1
PIVOT (
  SUM(COST_AMOUNT) AS SUM1,SUM(COST_RELEASED) AS SUM2
  FOR COST_TYPE IN (
    'Commissions','Commissions Adjustment','Commissions Adjustment2','Fringe Commissions','Fringe Cost Adjustment','Fringe Cost Adjustment2','Install Costs Estimate',
'3rd Party License Costs','3rd Party Software Usage TERMLIC Costs'
  )
)
ORDER BY RC_ID;
ORA-00918: column ambiguously defined

WITH TABLE1 AS (
SELECT RC_ID, COST_TYPE AS COST_TYPE, SUM(AMOUNT) AS COST_AMOUNT, SUM(REC_AMT) AS COST_RELEASED
FROM RC_LN_COST_V
WHERE RC_ID = 1837161
GROUP BY RC_ID, COST_TYPE)

SELECT *
FROM TABLE1
PIVOT (
  SUM(COST_AMOUNT) AS amt, SUM(COST_RELEASED) AS rel
  FOR COST_TYPE IN (
    'Commissions' AS comm,
    'Commissions Adjustment' AS comm_adj,
    'Commissions Adjustment2' AS comm_adj2,
    'Fringe Commissions' AS fringe_comm,
    'Fringe Cost Adjustment' AS fringe_comm_adj,
    'Fringe Cost Adjustment2' AS fring_comm_adj2,
    'Install Costs Estimate' AS inst_cost_est,
    '3rd Party License Costs' AS tp_lic_cost,
    '3rd Party Software Usage TERMLIC Costs' AS tp_su_term_lic_cost
  )
)
ORDER BY RC_ID;


RC_ID
COMM_AMT
COMM_REL
COMM_ADJ_AMT
COMM_ADJ_REL
COMM_ADJ2_AMT
COMM_ADJ2_REL
FRINGE_COMM_AMT
FRINGE_COMM_REL
FRINGE_COMM_ADJ_AMT
FRINGE_COMM_ADJ_REL
FRING_COMM_ADJ2_AMT
FRING_COMM_ADJ2_REL
INST_COST_EST_AMT
INST_COST_EST_REL
TP_LIC_COST_AMT
TP_LIC_COST_REL
TP_SU_TERM_LIC_COST_AMT
TP_SU_TERM_LIC_COST_REL


1837161
100
50
null
null
null
null
null
null
null
null
null
null
null
null
null
null
500
99


SELECT *
FROM RC_LN_COST_V
PIVOT (
  SUM(AMOUNT) AS amt, SUM(REC_AMT) AS rel
  FOR COST_TYPE IN (
    'Commissions' AS comm,
    'Commissions Adjustment' AS comm_adj,
    'Commissions Adjustment2' AS comm_adj2,
    'Fringe Commissions' AS fringe_comm,
    'Fringe Cost Adjustment' AS fringe_comm_adj,
    'Fringe Cost Adjustment2' AS fring_comm_adj2,
    'Install Costs Estimate' AS inst_cost_est,
    '3rd Party License Costs' AS tp_lic_cost,
    '3rd Party Software Usage TERMLIC Costs' AS tp_su_term_lic_cost
  )
)
WHERE RC_ID = 1837161
ORDER BY RC_ID;


RC_ID
COMM_AMT
COMM_REL
COMM_ADJ_AMT
COMM_ADJ_REL
COMM_ADJ2_AMT
COMM_ADJ2_REL
FRINGE_COMM_AMT
FRINGE_COMM_REL
FRINGE_COMM_ADJ_AMT
FRINGE_COMM_ADJ_REL
FRING_COMM_ADJ2_AMT
FRING_COMM_ADJ2_REL
INST_COST_EST_AMT
INST_COST_EST_REL
TP_LIC_COST_AMT
TP_LIC_COST_REL
TP_SU_TERM_LIC_COST_AMT
TP_SU_TERM_LIC_COST_REL


1837161
100
50
null
null
null
null
null
null
null
null
null
null
null
null
null
null
500
99