SELECT CWK.CLNDR_WK_ID, CWK.WK_CD, CWK.WK_NBR, CWK.WK_DESC, CWK.WK_STRT_DT, CWK.WK_END_DT, CWK.WK_TIMESPN, 'CLNDR' CLNDR_CD, 'CLNDR' CLNDR_TYP, MFG_ORG.ORG_CD ORG_CD FROM DDR_R_CLNDR_WK CWK,DDR_R_ORG MFG_ORG WHERE MFG_ORG.ORG_TYP='MFG'
SELECT CWK.CLNDR_WK_ID
, CWK.WK_CD
, CWK.WK_NBR
, CWK.WK_DESC
, CWK.WK_STRT_DT
, CWK.WK_END_DT
, CWK.WK_TIMESPN
, 'CLNDR' CLNDR_CD
, 'CLNDR' CLNDR_TYP
, MFG_ORG.ORG_CD ORG_CD
FROM DDR_R_CLNDR_WK CWK
, DDR_R_ORG MFG_ORG
WHERE MFG_ORG.ORG_TYP='MFG'
|
|
|