eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.DDR_R_PRD_DRTN_DN_MV#

Source

View Text - Preformatted


select MFG_ORG_CD
,      CLNDR_CD
,      DAY_CD PRD_CD
,      BASE_DAY_ID PRD_ID
,      1 PRD_TYP
,      1 PRD_DRTN
,      day_of_yr PRD_DRTN_YTD
,      0 CNT_PRD_DRTN_YTD
,      0 CNT_TOTAL
,      ROWID PRD_ROWID
from DDR_R_BASE_DAY
union all
select w1.MFG_ORG_CD
,      w1.CLNDR_CD
,      w1.WK_CD PRD_CD
,      w1.BSNS_WK_ID PRD_ID
,      2 PRD_TYP
,      w1.WK_TIMESPN PRD_DRTN
,      sum(w2.WK_TIMESPN) PRD_DRTN_YTD
,      count(w2.WK_TIMESPN) CNT_PRD_DRTN_YTD
,      count(*) CNT_TOTAL
,      w1.ROWID PRD_ROWID
from DDR_R_BSNS_WK w1
,    DDR_R_BSNS_WK w2
,    DDR_R_WK_TODATE_TRANS t
where w1.clndr_cd = t.clndr_cd
and   w1.bsns_wk_id = t.wk_id
and   t.clndr_cd = w2.clndr_cd
and   t.yr_wk_id = w2.bsns_wk_id
group by w1.MFG_ORG_CD
,        w1.CLNDR_CD
,        w1.WK_CD
,        w1.BSNS_WK_ID
,        w1.WK_TIMESPN
,        w1.ROWID
union all
select m1.MFG_ORG_CD
,      m1.CLNDR_CD
,      m1.MNTH_CD PRD_CD
,      m1.BSNS_MNTH_ID PRD_ID
,      3 PRD_TYP
,      m1.MNTH_TIMESPN PRD_DRTN
,      sum(m2.MNTH_TIMESPN) PRD_DRTN_YTD
,      count(m2.MNTH_TIMESPN) CNT_PRD_DRTN_YTD
,      count(*) CNT_TOTAL
,      m1.ROWID PRD_ROWID
from DDR_R_BSNS_MNTH m1
,    DDR_R_BSNS_MNTH m2
,    DDR_R_MNTH_TODATE_TRANS t
where m1.clndr_cd = t.clndr_cd
and   m1.bsns_mnth_id = t.mnth_id
and   t.clndr_cd = m2.clndr_cd
and   t.yr_mnth_id = m2.bsns_mnth_id
group by m1.MFG_ORG_CD
,        m1.CLNDR_CD
,        m1.MNTH_CD
,        m1.BSNS_MNTH_ID
,        m1.MNTH_TIMESPN
,        m1.ROWID
union all
select q1.MFG_ORG_CD
,      q1.CLNDR_CD
,      q1.QTR_CD PRD_CD
,      q1.BSNS_QTR_ID PRD_ID
,      4 PRD_TYP
,      q1.QTR_TIMESPN PRD_DRTN
,      sum(q2.QTR_TIMESPN) PRD_DRTN_YTD
,      count(q2.QTR_TIMESPN) CNT_PRD_DRTN_YTD
,      count(*) CNT_TOTAL
,      q1.ROWID PRD_ROWID
from DDR_R_BSNS_QTR q1
,    DDR_R_BSNS_QTR q2
,    DDR_R_QTR_TODATE_TRANS t
where q1.clndr_cd = t.clndr_cd
and   q1.bsns_qtr_id = t.qtr_id
and   t.clndr_cd = q2.clndr_cd
and   t.yr_qtr_id = q2.bsns_qtr_id
group by q1.MFG_ORG_CD
,        q1.CLNDR_CD
,        q1.QTR_CD
,        q1.BSNS_QTR_ID
,        q1.QTR_TIMESPN
,        q1.ROWID
union all
select MFG_ORG_CD
,      CLNDR_CD
,      YR_CD PRD_CD
,      BSNS_YR_ID PRD_ID
,      5 PRD_TYP
,      YR_TIMESPN PRD_DRTN
,      YR_TIMESPN PRD_DRTN_YTD
,      0 CNT_PRD_DRTN_YTD
,      0 CNT_TOTAL
,      ROWID PRD_ROWID
from DDR_R_BSNS_YR

View Text - HTML Formatted

SELECT MFG_ORG_CD
, CLNDR_CD
, DAY_CD PRD_CD
, BASE_DAY_ID PRD_ID
, 1 PRD_TYP
, 1 PRD_DRTN
, DAY_OF_YR PRD_DRTN_YTD
, 0 CNT_PRD_DRTN_YTD
, 0 CNT_TOTAL
, ROWID PRD_ROWID FROM DDR_R_BASE_DAY UNION ALL SELECT W1.MFG_ORG_CD
, W1.CLNDR_CD
, W1.WK_CD PRD_CD
, W1.BSNS_WK_ID PRD_ID
, 2 PRD_TYP
, W1.WK_TIMESPN PRD_DRTN
, SUM(W2.WK_TIMESPN) PRD_DRTN_YTD
, COUNT(W2.WK_TIMESPN) CNT_PRD_DRTN_YTD
, COUNT(*) CNT_TOTAL
, W1.ROWID PRD_ROWID FROM DDR_R_BSNS_WK W1
, DDR_R_BSNS_WK W2
, DDR_R_WK_TODATE_TRANS T WHERE W1.CLNDR_CD = T.CLNDR_CD AND W1.BSNS_WK_ID = T.WK_ID AND T.CLNDR_CD = W2.CLNDR_CD AND T.YR_WK_ID = W2.BSNS_WK_ID GROUP BY W1.MFG_ORG_CD
, W1.CLNDR_CD
, W1.WK_CD
, W1.BSNS_WK_ID
, W1.WK_TIMESPN
, W1.ROWID UNION ALL SELECT M1.MFG_ORG_CD
, M1.CLNDR_CD
, M1.MNTH_CD PRD_CD
, M1.BSNS_MNTH_ID PRD_ID
, 3 PRD_TYP
, M1.MNTH_TIMESPN PRD_DRTN
, SUM(M2.MNTH_TIMESPN) PRD_DRTN_YTD
, COUNT(M2.MNTH_TIMESPN) CNT_PRD_DRTN_YTD
, COUNT(*) CNT_TOTAL
, M1.ROWID PRD_ROWID FROM DDR_R_BSNS_MNTH M1
, DDR_R_BSNS_MNTH M2
, DDR_R_MNTH_TODATE_TRANS T WHERE M1.CLNDR_CD = T.CLNDR_CD AND M1.BSNS_MNTH_ID = T.MNTH_ID AND T.CLNDR_CD = M2.CLNDR_CD AND T.YR_MNTH_ID = M2.BSNS_MNTH_ID GROUP BY M1.MFG_ORG_CD
, M1.CLNDR_CD
, M1.MNTH_CD
, M1.BSNS_MNTH_ID
, M1.MNTH_TIMESPN
, M1.ROWID UNION ALL SELECT Q1.MFG_ORG_CD
, Q1.CLNDR_CD
, Q1.QTR_CD PRD_CD
, Q1.BSNS_QTR_ID PRD_ID
, 4 PRD_TYP
, Q1.QTR_TIMESPN PRD_DRTN
, SUM(Q2.QTR_TIMESPN) PRD_DRTN_YTD
, COUNT(Q2.QTR_TIMESPN) CNT_PRD_DRTN_YTD
, COUNT(*) CNT_TOTAL
, Q1.ROWID PRD_ROWID FROM DDR_R_BSNS_QTR Q1
, DDR_R_BSNS_QTR Q2
, DDR_R_QTR_TODATE_TRANS T WHERE Q1.CLNDR_CD = T.CLNDR_CD AND Q1.BSNS_QTR_ID = T.QTR_ID AND T.CLNDR_CD = Q2.CLNDR_CD AND T.YR_QTR_ID = Q2.BSNS_QTR_ID GROUP BY Q1.MFG_ORG_CD
, Q1.CLNDR_CD
, Q1.QTR_CD
, Q1.BSNS_QTR_ID
, Q1.QTR_TIMESPN
, Q1.ROWID UNION ALL SELECT MFG_ORG_CD
, CLNDR_CD
, YR_CD PRD_CD
, BSNS_YR_ID PRD_ID
, 5 PRD_TYP
, YR_TIMESPN PRD_DRTN
, YR_TIMESPN PRD_DRTN_YTD
, 0 CNT_PRD_DRTN_YTD
, 0 CNT_TOTAL
, ROWID PRD_ROWID FROM DDR_R_BSNS_YR