SELECT "A2".ROWID "GWK_ROWID",
"A1".ROWID "WK_TRANS_ROWID",
"A1".MFG_ORG_CD
||'-'
||'CLNDR' "CLNDR_DESC",
"A1"."CLNDR_CD" "CLNDR_CD",
"A1"."CLNDR_TYP" "CLNDR_TYPE",
"A2"."CLNDR_WK_ID" "CLNDR_WK_ID",
"A2"."WK_CD" "WK_CD",
"A2"."WK_NBR" "WK_NBR",
"A2"."WK_DESC" "WK_DESC",
"A2"."WK_STRT_DT" "WK_STRT_DT",
"A2"."WK_END_DT" "WK_END_DT",
"A2"."WK_TIMESPN" "WK_TIMESPN",
"A1"."LAST_WK_THIS_YR_ID" "LAST_WK_THIS_YR_ID",
"A1"."LAST_YR_THIS_WK_ID" "LAST_YR_THIS_WK_ID"
FROM "DDR_R_CLNDR_WK" "A2",
"DDR_R_WK_TRANS" "A1"
WHERE "A2"."CLNDR_WK_ID"="A1"."WK_ID"
AND "A1"."CLNDR_CD" ='CLNDR'
SELECT "A2".ROWID "GWK_ROWID"
,
"A1".ROWID "WK_TRANS_ROWID"
,
"A1".MFG_ORG_CD
||'-'
||'CLNDR' "CLNDR_DESC"
,
"A1"."CLNDR_CD" "CLNDR_CD"
,
"A1"."CLNDR_TYP" "CLNDR_TYPE"
,
"A2"."CLNDR_WK_ID" "CLNDR_WK_ID"
,
"A2"."WK_CD" "WK_CD"
,
"A2"."WK_NBR" "WK_NBR"
,
"A2"."WK_DESC" "WK_DESC"
,
"A2"."WK_STRT_DT" "WK_STRT_DT"
,
"A2"."WK_END_DT" "WK_END_DT"
,
"A2"."WK_TIMESPN" "WK_TIMESPN"
,
"A1"."LAST_WK_THIS_YR_ID" "LAST_WK_THIS_YR_ID"
,
"A1"."LAST_YR_THIS_WK_ID" "LAST_YR_THIS_WK_ID"
FROM "DDR_R_CLNDR_WK" "A2"
,
"DDR_R_WK_TRANS" "A1"
WHERE "A2"."CLNDR_WK_ID"="A1"."WK_ID"
AND "A1"."CLNDR_CD" ='CLNDR'
|
|
|