SEO

Hi friends,

Thanks in advance.

Is there a way we can transpose the columns (SUM columns) in to rows
against each
L.ACCOUNT_ID,L.WORK_ITEM_ID,W.WORK_ITEM_TITLE,W.PL ANNED_START_DATE,W.PLANNED_END_DATE,
SUBSTR(B.EMP_LAST_NAME,21,5),
L.EMP_SER_NUM,B.EMP_LAST_NAME,L.EMP_INITIALS,L.WEE K_ENDING_DATE ?

Here is the select statement :

SELECT DISTINCT

L.ACCOUNT_ID,L.WORK_ITEM_ID,W.WORK_ITEM_TITLE,W.PL ANNED_START_DATE,W.PLANNED_END_DATE,
SUBSTR(B.EMP_LAST_NAME,21,5),
L.EMP_SER_NUM,B.EMP_LAST_NAME,L.EMP_INITIALS,L.WEE K_ENDING_DATE,


SUM(L.SAT_HOURS_EXPENDED),SUM(L.SUN_HOURS_EXPENDED ),

SUM(L.MON_HOURS_EXPENDED),SUM(L.TUE_HOURS_EXPENDED ),

SUM(L.WED_HOURS_EXPENDED),SUM(L.THU_HOURS_EXPENDED ),

SUM(L.FRI_HOURS_EXPENDED)

FROM BMSIW.APPROVAL_LABOR_V L,BMSIW.EMP_MASTER_FILE_V
B,BMSIW.WORK_ITEMS_V W

WHERE L.ACCOUNT_ID = 'WJJJC'


AND L.WEEK_ENDING_DATE BETWEEN ('2006-12-23') AND
('2007-06-08')
AND L.CONTROL_GROUP_CD IN
('NA1','NA2')
AND L.WORK_ITEM_ID =
W.WORK_ITEM_ID
AND L.ACCOUNT_ID =
W.ACCOUNT_ID
AND L.COUNTRY_CODE IN
('897','709')
AND L.EMP_SER_NUM =
B.EMP_SER_NUM
AND B.SITE_LOC_ID =
L.SITE_LOC_ID
AND L.COUNTRY_CODE = B.COUNTRY_CODE AND L.EMP_COMPANY_CODE =
B.COMPANY_CODE
AND WORK_ITEM_STATUS =
'ACTIVE'
AND LAB_STATUS = 'ACTIVE'

GROUP BY

L.ACCOUNT_ID,
L.WORK_ITEM_ID,
W.WORK_ITEM_TITLE,
W.PLANNED_START_DATE,
W.PLANNED_END_DATE,
L.EMP_SER_NUM,
L.EMP_LAST_NAME,
L.EMP_INITIALS,
WEEK_ENDING_DATE,
SAT_HOURS_EXPENDED,SUN_HOURS_EXPENDED,MON_HOURS_EX PENDED,TUE_HOURS_EXPENDED,WED_HOURS_EXPENDED,THU_H OURS_EXPENDED,FRI_HOURS_EXPENDED,
L.COUNTRY_CODE,
B.EMP_LAST_NAME