1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
| SELECT
WS.CD_WO,
WS.CD_WS,
WS.TXT_QUOTEFIELD,
WS.CD_TEAM,
TEAM.TXT_QUOTEFIELD,
WS.CD_ACTION_TYPE,
ACTION_TYPE.TXT_QUOTEFIELD,
WS.CD_COST_CENTER,
WO.DTTM_WO_CREATE,
WS.CD_BOX, WS.CD_BOX2,
BOX.TXT_QUOTEFIELD,
GTM_RENTAL.CD_GTM_BUILDING_SITE,
GTM_BUILDING_SITE.TXT_QUOTEFIELD,
GTM_RENTAL.DTTM_MUTATION_LAST
FROM
S02.ACTION_TYPE ACTION_TYPE,
S02.BOX BOX,
S02.GTM_BUILDING_SITE GTM_BUILDING_SITE,
S02.GTM_RENTAL GTM_RENTAL,
S02.TEAM TEAM,
S02.WO WO,
S02.WS WS
WHERE
WS.CD_WO = WO.CD_WO
AND WS.CD_ACTION_TYPE = ACTION_TYPE.CD_ACTION_TYPE
AND WS.CD_BOX2 = BOX.CD_BOX
AND WS.CD_TEAM = TEAM.CD_TEAM
AND WS.CD_BOX = GTM_RENTAL.CD_BOX
AND GTM_RENTAL.CD_GTM_BUILDING_SITE = GTM_BUILDING_SITE.CD_GTM_BUILDING_SITE
AND ((WS.CD_WO=29830))
ORDER BY
GTM_RENTAL.DTTM_MUTATION_LAST |
Partager