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_QTR_TRANS

Line 449: /* Populate DDR_R_QTR_TRANS table */

445: and NYR.CLNDR_CD(+) = MNTH.CLNDR_CD
446: and NYR.MNTH_CD(+) = add_month(MNTH.MNTH_CD,12)
447: ;
448:
449: /* Populate DDR_R_QTR_TRANS table */
450: delete from DDR_R_QTR_TRANS
451: where (QTR_CD,CLNDR_CD) in (
452: select QTR_CD,CLNDR_CD
453: from DDR_TIME_BSNS_QTR_V

Line 450: delete from DDR_R_QTR_TRANS

446: and NYR.MNTH_CD(+) = add_month(MNTH.MNTH_CD,12)
447: ;
448:
449: /* Populate DDR_R_QTR_TRANS table */
450: delete from DDR_R_QTR_TRANS
451: where (QTR_CD,CLNDR_CD) in (
452: select QTR_CD,CLNDR_CD
453: from DDR_TIME_BSNS_QTR_V
454: where ORG_CD = p_org_cd

Line 458: insert into DDR_R_QTR_TRANS (

454: where ORG_CD = p_org_cd
455: and YR_CD between to_char(p_start_year) and to_char(p_end_year)
456: );
457:
458: insert into DDR_R_QTR_TRANS (
459: MFG_ORG_CD,
460: QTR_TRANS_ID,
461: QTR_ID,
462: QTR_CD,

Line 485: DDR_R_QTR_TRANS_SEQ.NEXTVAL,

481: LAST_UPDATE_LOGIN
482: )
483: select
484: QTR.MFG_ORG_CD,
485: DDR_R_QTR_TRANS_SEQ.NEXTVAL,
486: QTR.QTR_ID,
487: QTR.QTR_CD,
488: QTR.CLNDR_CD,
489: 'BSNS',

Line 1617: /* Populate DDR_R_QTR_TRANS table */

1613: AND NQTR.CLNDR_CD(+) = MNTH.CLNDR_CD
1614: AND NQTR.MNTH_CD(+) = add_month(MNTH.MNTH_CD,3)
1615: AND NYR.CLNDR_CD(+) = MNTH.CLNDR_CD
1616: AND NYR.MNTH_CD(+) = add_month(MNTH.MNTH_CD,12) ;
1617: /* Populate DDR_R_QTR_TRANS table */
1618: DELETE
1619: FROM DDR_R_QTR_TRANS
1620: WHERE (QTR_CD,CLNDR_CD) IN
1621: (SELECT QTR_CD,

Line 1619: FROM DDR_R_QTR_TRANS

1615: AND NYR.CLNDR_CD(+) = MNTH.CLNDR_CD
1616: AND NYR.MNTH_CD(+) = add_month(MNTH.MNTH_CD,12) ;
1617: /* Populate DDR_R_QTR_TRANS table */
1618: DELETE
1619: FROM DDR_R_QTR_TRANS
1620: WHERE (QTR_CD,CLNDR_CD) IN
1621: (SELECT QTR_CD,
1622: CLNDR_CD
1623: FROM DDR_TIME_CLNDR_QTR_V

Line 1627: INTO DDR_R_QTR_TRANS

1623: FROM DDR_TIME_CLNDR_QTR_V
1624: WHERE YR_CD BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)
1625: );
1626: INSERT
1627: INTO DDR_R_QTR_TRANS
1628: (
1629: MFG_ORG_CD,
1630: QTR_TRANS_ID,
1631: QTR_ID,

Line 1654: DDR_R_QTR_TRANS_SEQ.NEXTVAL,

1650: LAST_UPDATE_DATE,
1651: LAST_UPDATE_LOGIN
1652: )
1653: SELECT QTR.ORG_CD,
1654: DDR_R_QTR_TRANS_SEQ.NEXTVAL,
1655: QTR.CLNDR_QTR_ID,
1656: QTR.QTR_CD,
1657: QTR.CLNDR_CD,
1658: QTR.CLNDR_TYP,