|
SELECT A.BUDGET_PERIOD,
A.BUSINESS_UNIT,
B.COURSE,
C.DEMAND_ID,
B.REAL_COURSE
FROM PS_TRN_SIMULATION A,
PS_TRN_ALL_COURSE B,
PS_TRN_DEMAND C,
PS_TRN_SCENARIO D
WHERE A.BUDGET_PERIOD = C.BUDGET_PERIOD
AND A.DEMAND_ID = C.DEMAND_ID
AND C.COURSE = B.COURSE
AND A.BUDGET_PERIOD = D.BUDGET_PERIOD
AND A.DEPTID = D.DEPTID
AND A.SCENARIO = D.SCENARIO
AND D.SCENARIO_STATUS = 'A'
AND A.BUSINESS_UNIT = C.BUSINESS_UNIT
AND A.BUSINESS_UNIT = D.BUSINESS_UNIT
GROUP BY A.BUDGET_PERIOD,
A.BUSINESS_UNIT,
B.COURSE,
C.DEMAND_ID,
B.REAL_COURSE
|
BUDGET_PERIOD