SELECT "A4".ROWID "GMNTH_ROWID",
"A3".ROWID "GQTR_ROWID",
"A2".ROWID "GYR_ROWID",
"A1".ROWID "MNTH_TRANS_ROWID",
"A1".MFG_ORG_CD
||'-'
||'CLNDR' "CLNDR_DESC",
"A1"."CLNDR_CD" "CLNDR_CD",
"A1"."CLNDR_TYP" "CLNDR_TYPE",
"A4"."CLNDR_MNTH_ID" "CLNDR_MNTH_ID",
"A4"."MNTH_DESC" "MNTH_DESC",
"A4"."MNTH_CD" "MNTH_CD",
"A4"."MNTH_STRT_DT" "MNTH_STRT_DT",
"A4"."MNTH_END_DT" "MNTH_END_DT",
"A4"."MNTH_NBR" "MNTH_NBR",
"A4"."MNTH_TIMESPN" "MNTH_TIMESPN",
"A1"."LAST_YR_THIS_MNTH_ID" "LAST_YR_THIS_MNTH_ID",
"A1"."LAST_MNTH_THIS_YR_ID" "LAST_MNTH_THIS_YR_ID",
"A3"."CLNDR_QTR_ID" "CLNDR_QTR_ID",
"A3"."QTR_DESC" "QTR_DESC",
"A3"."QTR_NBR" "QTR_NBR",
"A3"."QTR_CD" "QTR_CD",
"A3"."QTR_STRT_DT" "QTR_STRT_DT",
"A3"."QTR_END_DT" "QTR_END_DT",
"A3"."QTR_TIMESPN" "QTR_TIMESPN",
"A2"."CLNDR_YR_ID" "CLNDR_YR_ID",
"A2"."YR_DESC" "YR_DESC",
"A2"."YR_NBR" "YR_NBR",
"A2"."YR_CD" "YR_CD",
"A2"."YR_STRT_DT" "YR_STRT_DT",
"A2"."YR_END_DT" "YR_END_DT",
"A2"."YR_TIMESPN" "YR_TIMESPN"
FROM "DDR_R_CLNDR_MNTH" "A4",
"DDR_R_CLNDR_QTR" "A3",
"DDR_R_CLNDR_YR" "A2",
"DDR_R_MNTH_TRANS" "A1"
WHERE "A4"."CLNDR_QTR_ID"="A3"."CLNDR_QTR_ID"
AND "A3"."CLNDR_YR_ID" ="A2"."CLNDR_YR_ID"
AND "A4"."CLNDR_MNTH_ID" ="A1"."MNTH_ID"
AND "A1"."CLNDR_CD" ='CLNDR'
SELECT "A4".ROWID "GMNTH_ROWID"
,
"A3".ROWID "GQTR_ROWID"
,
"A2".ROWID "GYR_ROWID"
,
"A1".ROWID "MNTH_TRANS_ROWID"
,
"A1".MFG_ORG_CD
||'-'
||'CLNDR' "CLNDR_DESC"
,
"A1"."CLNDR_CD" "CLNDR_CD"
,
"A1"."CLNDR_TYP" "CLNDR_TYPE"
,
"A4"."CLNDR_MNTH_ID" "CLNDR_MNTH_ID"
,
"A4"."MNTH_DESC" "MNTH_DESC"
,
"A4"."MNTH_CD" "MNTH_CD"
,
"A4"."MNTH_STRT_DT" "MNTH_STRT_DT"
,
"A4"."MNTH_END_DT" "MNTH_END_DT"
,
"A4"."MNTH_NBR" "MNTH_NBR"
,
"A4"."MNTH_TIMESPN" "MNTH_TIMESPN"
,
"A1"."LAST_YR_THIS_MNTH_ID" "LAST_YR_THIS_MNTH_ID"
,
"A1"."LAST_MNTH_THIS_YR_ID" "LAST_MNTH_THIS_YR_ID"
,
"A3"."CLNDR_QTR_ID" "CLNDR_QTR_ID"
,
"A3"."QTR_DESC" "QTR_DESC"
,
"A3"."QTR_NBR" "QTR_NBR"
,
"A3"."QTR_CD" "QTR_CD"
,
"A3"."QTR_STRT_DT" "QTR_STRT_DT"
,
"A3"."QTR_END_DT" "QTR_END_DT"
,
"A3"."QTR_TIMESPN" "QTR_TIMESPN"
,
"A2"."CLNDR_YR_ID" "CLNDR_YR_ID"
,
"A2"."YR_DESC" "YR_DESC"
,
"A2"."YR_NBR" "YR_NBR"
,
"A2"."YR_CD" "YR_CD"
,
"A2"."YR_STRT_DT" "YR_STRT_DT"
,
"A2"."YR_END_DT" "YR_END_DT"
,
"A2"."YR_TIMESPN" "YR_TIMESPN"
FROM "DDR_R_CLNDR_MNTH" "A4"
,
"DDR_R_CLNDR_QTR" "A3"
,
"DDR_R_CLNDR_YR" "A2"
,
"DDR_R_MNTH_TRANS" "A1"
WHERE "A4"."CLNDR_QTR_ID"="A3"."CLNDR_QTR_ID"
AND "A3"."CLNDR_YR_ID" ="A2"."CLNDR_YR_ID"
AND "A4"."CLNDR_MNTH_ID" ="A1"."MNTH_ID"
AND "A1"."CLNDR_CD" ='CLNDR'
|
|
|