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_TIME_BSNS_MNTH_V

Line 357: from DDR_TIME_BSNS_MNTH_V

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
359: and YR_CD between to_char(p_start_year) and to_char(p_end_year)
360: );
361:

Line 420: DDR_TIME_BSNS_MNTH_V MNTH,

416: g_last_updated_by,
417: g_last_update_date,
418: g_last_update_login
419: from
420: DDR_TIME_BSNS_MNTH_V MNTH,
421: DDR_TIME_BSNS_MNTH_V PMNTH,
422: DDR_TIME_BSNS_MNTH_V PQTR,
423: DDR_TIME_BSNS_MNTH_V PYR,
424: DDR_TIME_BSNS_MNTH_V NMNTH,

Line 421: DDR_TIME_BSNS_MNTH_V PMNTH,

417: g_last_update_date,
418: g_last_update_login
419: from
420: DDR_TIME_BSNS_MNTH_V MNTH,
421: DDR_TIME_BSNS_MNTH_V PMNTH,
422: DDR_TIME_BSNS_MNTH_V PQTR,
423: DDR_TIME_BSNS_MNTH_V PYR,
424: DDR_TIME_BSNS_MNTH_V NMNTH,
425: DDR_TIME_BSNS_MNTH_V NQTR,

Line 422: DDR_TIME_BSNS_MNTH_V PQTR,

418: g_last_update_login
419: from
420: DDR_TIME_BSNS_MNTH_V MNTH,
421: DDR_TIME_BSNS_MNTH_V PMNTH,
422: DDR_TIME_BSNS_MNTH_V PQTR,
423: DDR_TIME_BSNS_MNTH_V PYR,
424: DDR_TIME_BSNS_MNTH_V NMNTH,
425: DDR_TIME_BSNS_MNTH_V NQTR,
426: DDR_TIME_BSNS_MNTH_V NYR

Line 423: DDR_TIME_BSNS_MNTH_V PYR,

419: from
420: DDR_TIME_BSNS_MNTH_V MNTH,
421: DDR_TIME_BSNS_MNTH_V PMNTH,
422: DDR_TIME_BSNS_MNTH_V PQTR,
423: DDR_TIME_BSNS_MNTH_V PYR,
424: DDR_TIME_BSNS_MNTH_V NMNTH,
425: DDR_TIME_BSNS_MNTH_V NQTR,
426: DDR_TIME_BSNS_MNTH_V NYR
427: where MNTH.ORG_CD = p_org_cd

Line 424: DDR_TIME_BSNS_MNTH_V NMNTH,

420: DDR_TIME_BSNS_MNTH_V MNTH,
421: DDR_TIME_BSNS_MNTH_V PMNTH,
422: DDR_TIME_BSNS_MNTH_V PQTR,
423: DDR_TIME_BSNS_MNTH_V PYR,
424: DDR_TIME_BSNS_MNTH_V NMNTH,
425: DDR_TIME_BSNS_MNTH_V NQTR,
426: DDR_TIME_BSNS_MNTH_V NYR
427: where MNTH.ORG_CD = p_org_cd
428: and MNTH.YR_CD between to_char(p_start_year) and to_char(p_end_year)

Line 425: DDR_TIME_BSNS_MNTH_V NQTR,

421: DDR_TIME_BSNS_MNTH_V PMNTH,
422: DDR_TIME_BSNS_MNTH_V PQTR,
423: DDR_TIME_BSNS_MNTH_V PYR,
424: DDR_TIME_BSNS_MNTH_V NMNTH,
425: DDR_TIME_BSNS_MNTH_V NQTR,
426: DDR_TIME_BSNS_MNTH_V NYR
427: where MNTH.ORG_CD = p_org_cd
428: and MNTH.YR_CD between to_char(p_start_year) and to_char(p_end_year)
429: and PMNTH.ORG_CD(+) = MNTH.ORG_CD

Line 426: DDR_TIME_BSNS_MNTH_V NYR

422: DDR_TIME_BSNS_MNTH_V PQTR,
423: DDR_TIME_BSNS_MNTH_V PYR,
424: DDR_TIME_BSNS_MNTH_V NMNTH,
425: DDR_TIME_BSNS_MNTH_V NQTR,
426: DDR_TIME_BSNS_MNTH_V NYR
427: where MNTH.ORG_CD = p_org_cd
428: and MNTH.YR_CD between to_char(p_start_year) and to_char(p_end_year)
429: and PMNTH.ORG_CD(+) = MNTH.ORG_CD
430: and PMNTH.CLNDR_CD(+) = MNTH.CLNDR_CD

Line 720: from DDR_TIME_BSNS_MNTH_V

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
722: and YR_CD between to_char(p_start_year) and to_char(p_end_year)
723: );
724:

Line 770: FROM DDR_TIME_BSNS_MNTH_V A,

766: A.MNTH_ID MNTH_ID,
767: A.CLNDR_CD CLNDR_CD,
768: B.MNTH_CD YR_MNTH_CD,
769: B.MNTH_ID YR_MNTH_ID
770: FROM DDR_TIME_BSNS_MNTH_V A,
771: DDR_TIME_BSNS_MNTH_V B
772: WHERE A.YR_CD = B.YR_CD
773: AND A.MNTH_CD >= B.MNTH_CD
774: AND A.ORG_CD = B.ORG_CD

Line 771: DDR_TIME_BSNS_MNTH_V B

767: A.CLNDR_CD CLNDR_CD,
768: B.MNTH_CD YR_MNTH_CD,
769: B.MNTH_ID YR_MNTH_ID
770: FROM DDR_TIME_BSNS_MNTH_V A,
771: DDR_TIME_BSNS_MNTH_V B
772: WHERE A.YR_CD = B.YR_CD
773: AND A.MNTH_CD >= B.MNTH_CD
774: AND A.ORG_CD = B.ORG_CD
775: AND A.ORG_CD = p_org_cd