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_WK_TODATE_TRANS

Line 652: /* Populate DDR_R_WK_TODATE_TRANS table */

648: AND A.YR_CD between to_char(p_start_year) and to_char(p_end_year)
649: ORDER BY A.DAY_CD,
650: B.DAY_CD) YTD;
651:
652: /* Populate DDR_R_WK_TODATE_TRANS table */
653: delete from DDR_R_WK_TODATE_TRANS
654: where (WK_CD,CLNDR_CD) in (
655: select WK_CD,CLNDR_CD
656: from DDR_TIME_BSNS_WK_V

Line 653: delete from DDR_R_WK_TODATE_TRANS

649: ORDER BY A.DAY_CD,
650: B.DAY_CD) YTD;
651:
652: /* Populate DDR_R_WK_TODATE_TRANS table */
653: delete from DDR_R_WK_TODATE_TRANS
654: where (WK_CD,CLNDR_CD) in (
655: select WK_CD,CLNDR_CD
656: from DDR_TIME_BSNS_WK_V
657: where ORG_CD = p_org_cd

Line 661: INSERT INTO DDR_R_WK_TODATE_TRANS(

657: where ORG_CD = p_org_cd
658: and YR_CD between to_char(p_start_year) and to_char(p_end_year)
659: );
660:
661: INSERT INTO DDR_R_WK_TODATE_TRANS(
662: MFG_ORG_CD,
663: WK_TODATE_TRANS_ID,
664: WK_ID,
665: WK_CD,

Line 682: DDR_R_WK_TODATE_TRANS_SEQ.NEXTVAL,

678: LAST_UPDATE_LOGIN
679: )
680: select
681: YTD.MFG_ORG_CD,
682: DDR_R_WK_TODATE_TRANS_SEQ.NEXTVAL,
683: YTD.WK_ID,
684: YTD.WK_CD,
685: YTD.CLNDR_CD,
686: 'BSNS',

Line 1810: /* Populate DDR_R_WK_TODATE_TRANS table */

1806: AND A.DAY_CD >= B.DAY_CD
1807: AND A.ORG_CD = B.ORG_CD
1808: AND A.YR_CD BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)
1809: ORDER BY A.DAY_CD, B.DAY_CD) YTD;
1810: /* Populate DDR_R_WK_TODATE_TRANS table */
1811: DELETE
1812: FROM DDR_R_WK_TODATE_TRANS
1813: WHERE (WK_CD,CLNDR_CD) IN
1814: (SELECT WK_CD,

Line 1812: FROM DDR_R_WK_TODATE_TRANS

1808: AND A.YR_CD BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)
1809: ORDER BY A.DAY_CD, B.DAY_CD) YTD;
1810: /* Populate DDR_R_WK_TODATE_TRANS table */
1811: DELETE
1812: FROM DDR_R_WK_TODATE_TRANS
1813: WHERE (WK_CD,CLNDR_CD) IN
1814: (SELECT WK_CD,
1815: CLNDR_CD
1816: FROM DDR_TIME_CLNDR_WK_V

Line 1821: INTO DDR_R_WK_TODATE_TRANS

1817: WHERE SUBSTR(WK_CD,1,4) BETWEEN TO_CHAR(p_start_year) AND
1818: TO_CHAR(p_end_year)
1819: );
1820: INSERT
1821: INTO DDR_R_WK_TODATE_TRANS
1822: (
1823: MFG_ORG_CD,
1824: WK_TODATE_TRANS_ID,
1825: WK_ID,

Line 1842: DDR_R_WK_TODATE_TRANS_SEQ.NEXTVAL,

1838: LAST_UPDATE_DATE ,
1839: LAST_UPDATE_LOGIN
1840: )
1841: SELECT YTD.ORG_CD,
1842: DDR_R_WK_TODATE_TRANS_SEQ.NEXTVAL,
1843: YTD.WK_ID,
1844: YTD.WK_CD,
1845: YTD.CLNDR_CD,
1846: YTD.CLNDR_TYP,