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_TRANS

Line 353: /* Populate DDR_R_MNTH_TRANS table */

349: and NYR.CLNDR_CD(+) = WK.CLNDR_CD
350: and NYR.WK_CD(+) = add_week(WK.WK_CD,52)
351: ;
352:
353: /* Populate DDR_R_MNTH_TRANS table */
354: delete from DDR_R_MNTH_TRANS
355: where (MNTH_CD,CLNDR_CD) in (
356: select MNTH_CD,CLNDR_CD
357: from DDR_TIME_BSNS_MNTH_V

Line 354: delete from DDR_R_MNTH_TRANS

350: and NYR.WK_CD(+) = add_week(WK.WK_CD,52)
351: ;
352:
353: /* Populate DDR_R_MNTH_TRANS table */
354: delete from DDR_R_MNTH_TRANS
355: where (MNTH_CD,CLNDR_CD) in (
356: select MNTH_CD,CLNDR_CD
357: from DDR_TIME_BSNS_MNTH_V
358: where ORG_CD = p_org_cd

Line 362: insert into DDR_R_MNTH_TRANS (

358: where ORG_CD = p_org_cd
359: and YR_CD between to_char(p_start_year) and to_char(p_end_year)
360: );
361:
362: insert into DDR_R_MNTH_TRANS (
363: MFG_ORG_CD,
364: MNTH_TRANS_ID,
365: MNTH_ID,
366: MNTH_CD,

Line 393: DDR_R_MNTH_TRANS_SEQ.NEXTVAL,

389: LAST_UPDATE_LOGIN
390: )
391: select
392: MNTH.MFG_ORG_CD,
393: DDR_R_MNTH_TRANS_SEQ.NEXTVAL,
394: MNTH.MNTH_ID,
395: MNTH.MNTH_CD,
396: MNTH.CLNDR_CD,
397: 'BSNS',

Line 1530: /* Populate DDR_R_MNTH_TRANS table */

1526: AND NYR.CLNDR_CD(+) = WK.CLNDR_CD
1527: AND NYR.WK_CD(+) = ADD_WEEK(WK.WK_CD,52)
1528: AND SUBSTR(WK.WK_CD,1,4) BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)
1529: ;
1530: /* Populate DDR_R_MNTH_TRANS table */
1531: DELETE
1532: FROM DDR_R_MNTH_TRANS
1533: WHERE (MNTH_CD,CLNDR_CD) IN
1534: (SELECT MNTH_CD,

Line 1532: FROM DDR_R_MNTH_TRANS

1528: AND SUBSTR(WK.WK_CD,1,4) BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)
1529: ;
1530: /* Populate DDR_R_MNTH_TRANS table */
1531: DELETE
1532: FROM DDR_R_MNTH_TRANS
1533: WHERE (MNTH_CD,CLNDR_CD) IN
1534: (SELECT MNTH_CD,
1535: CLNDR_CD
1536: FROM DDR_TIME_CLNDR_MNTH_V

Line 1540: INTO DDR_R_MNTH_TRANS

1536: FROM DDR_TIME_CLNDR_MNTH_V
1537: WHERE YR_CD BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)
1538: );
1539: INSERT
1540: INTO DDR_R_MNTH_TRANS
1541: (
1542: MFG_ORG_CD,
1543: MNTH_TRANS_ID,
1544: MNTH_ID,

Line 1571: DDR_R_MNTH_TRANS_SEQ.NEXTVAL,

1567: LAST_UPDATE_DATE,
1568: LAST_UPDATE_LOGIN
1569: )
1570: SELECT MNTH.ORG_CD,
1571: DDR_R_MNTH_TRANS_SEQ.NEXTVAL,
1572: MNTH.CLNDR_MNTH_ID,
1573: MNTH.MNTH_CD,
1574: MNTH.CLNDR_CD,
1575: MNTH.CLNDR_TYP,