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.

APPS.DDR_TIME_TRANSFORM_PKG dependencies on DDR_R_MNTH_TODATE_TRANS

Line 716: /* Populate DDR_R_MNTH_TODATE_TRANS table */

712: AND A.YR_CD between to_char(p_start_year) and to_char(p_end_year)
713: ORDER BY A.WK_CD,
714: B.WK_CD) YTD;
715:
716: /* Populate DDR_R_MNTH_TODATE_TRANS table */
717: delete from DDR_R_MNTH_TODATE_TRANS
718: where (MNTH_CD,CLNDR_CD) in (
719: select MNTH_CD,CLNDR_CD
720: from DDR_TIME_BSNS_MNTH_V

Line 717: delete from DDR_R_MNTH_TODATE_TRANS

713: ORDER BY A.WK_CD,
714: B.WK_CD) YTD;
715:
716: /* Populate DDR_R_MNTH_TODATE_TRANS table */
717: delete from DDR_R_MNTH_TODATE_TRANS
718: where (MNTH_CD,CLNDR_CD) in (
719: select MNTH_CD,CLNDR_CD
720: from DDR_TIME_BSNS_MNTH_V
721: where ORG_CD = p_org_cd

Line 725: INSERT INTO DDR_R_MNTH_TODATE_TRANS(

721: where ORG_CD = p_org_cd
722: and YR_CD between to_char(p_start_year) and to_char(p_end_year)
723: );
724:
725: INSERT INTO DDR_R_MNTH_TODATE_TRANS(
726: MFG_ORG_CD,
727: MNTH_TODATE_TRANS_ID,
728: MNTH_ID,
729: MNTH_CD,

Line 746: DDR_R_MNTH_TODATE_TRANS_SEQ.NEXTVAL,

742: LAST_UPDATE_LOGIN
743: )
744: select
745: YTD.MFG_ORG_CD,
746: DDR_R_MNTH_TODATE_TRANS_SEQ.NEXTVAL,
747: YTD.MNTH_ID,
748: YTD.MNTH_CD,
749: YTD.CLNDR_CD,
750: 'BSNS',

Line 1874: /* Populate DDR_R_MNTH_TODATE_TRANS table */

1870: AND SUBSTR(A.WK_CD,1,4) = SUBSTR(B.WK_CD,1,4)
1871: AND SUBSTR(A.WK_CD,1,4) BETWEEN TO_CHAR(P_START_YEAR) AND
1872: TO_CHAR(P_END_YEAR)
1873: ORDER BY A.WK_CD, B.WK_CD) YTD;
1874: /* Populate DDR_R_MNTH_TODATE_TRANS table */
1875: DELETE
1876: FROM DDR_R_MNTH_TODATE_TRANS
1877: WHERE (MNTH_CD,CLNDR_CD) IN
1878: (SELECT MNTH_CD,

Line 1876: FROM DDR_R_MNTH_TODATE_TRANS

1872: TO_CHAR(P_END_YEAR)
1873: ORDER BY A.WK_CD, B.WK_CD) YTD;
1874: /* Populate DDR_R_MNTH_TODATE_TRANS table */
1875: DELETE
1876: FROM DDR_R_MNTH_TODATE_TRANS
1877: WHERE (MNTH_CD,CLNDR_CD) IN
1878: (SELECT MNTH_CD,
1879: CLNDR_CD
1880: FROM DDR_TIME_CLNDR_MNTH_V

Line 1884: INTO DDR_R_MNTH_TODATE_TRANS

1880: FROM DDR_TIME_CLNDR_MNTH_V
1881: WHERE YR_CD BETWEEN TO_CHAR(P_START_YEAR) AND TO_CHAR(P_END_YEAR)
1882: );
1883: INSERT
1884: INTO DDR_R_MNTH_TODATE_TRANS
1885: (
1886: MFG_ORG_CD,
1887: MNTH_TODATE_TRANS_ID,
1888: MNTH_ID,

Line 1905: DDR_R_MNTH_TODATE_TRANS_SEQ.NEXTVAL,

1901: LAST_UPDATE_DATE ,
1902: LAST_UPDATE_LOGIN
1903: )
1904: SELECT YTD.ORG_CD,
1905: DDR_R_MNTH_TODATE_TRANS_SEQ.NEXTVAL,
1906: YTD.MNTH_ID,
1907: YTD.MNTH_CD,
1908: YTD.CLNDR_CD,
1909: YTD.CLNDR_TYP,