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_CLNDR_WK_V

Line 1426: FROM DDR_TIME_CLNDR_WK_V

1422: FROM DDR_R_WK_TRANS
1423: WHERE (WK_CD,CLNDR_CD) IN
1424: (SELECT WK_CD,
1425: CLNDR_CD
1426: FROM DDR_TIME_CLNDR_WK_V
1427: WHERE SUBSTR(WK_CD,1,4) BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)
1428: );
1429: INSERT
1430: INTO DDR_R_WK_TRANS

Line 1503: FROM DDR_TIME_CLNDR_WK_V WK,

1499: g_creation_date,
1500: g_last_updated_by,
1501: g_last_update_date,
1502: g_last_update_login
1503: FROM DDR_TIME_CLNDR_WK_V WK,
1504: DDR_TIME_CLNDR_WK_V PWK,
1505: DDR_TIME_CLNDR_WK_V PMNTH,
1506: DDR_TIME_CLNDR_WK_V PQTR,
1507: DDR_TIME_CLNDR_WK_V PYR,

Line 1504: DDR_TIME_CLNDR_WK_V PWK,

1500: g_last_updated_by,
1501: g_last_update_date,
1502: g_last_update_login
1503: FROM DDR_TIME_CLNDR_WK_V WK,
1504: DDR_TIME_CLNDR_WK_V PWK,
1505: DDR_TIME_CLNDR_WK_V PMNTH,
1506: DDR_TIME_CLNDR_WK_V PQTR,
1507: DDR_TIME_CLNDR_WK_V PYR,
1508: DDR_TIME_CLNDR_WK_V NWK,

Line 1505: DDR_TIME_CLNDR_WK_V PMNTH,

1501: g_last_update_date,
1502: g_last_update_login
1503: FROM DDR_TIME_CLNDR_WK_V WK,
1504: DDR_TIME_CLNDR_WK_V PWK,
1505: DDR_TIME_CLNDR_WK_V PMNTH,
1506: DDR_TIME_CLNDR_WK_V PQTR,
1507: DDR_TIME_CLNDR_WK_V PYR,
1508: DDR_TIME_CLNDR_WK_V NWK,
1509: DDR_TIME_CLNDR_WK_V NMNTH,

Line 1506: DDR_TIME_CLNDR_WK_V PQTR,

1502: g_last_update_login
1503: FROM DDR_TIME_CLNDR_WK_V WK,
1504: DDR_TIME_CLNDR_WK_V PWK,
1505: DDR_TIME_CLNDR_WK_V PMNTH,
1506: DDR_TIME_CLNDR_WK_V PQTR,
1507: DDR_TIME_CLNDR_WK_V PYR,
1508: DDR_TIME_CLNDR_WK_V NWK,
1509: DDR_TIME_CLNDR_WK_V NMNTH,
1510: DDR_TIME_CLNDR_WK_V NQTR,

Line 1507: DDR_TIME_CLNDR_WK_V PYR,

1503: FROM DDR_TIME_CLNDR_WK_V WK,
1504: DDR_TIME_CLNDR_WK_V PWK,
1505: DDR_TIME_CLNDR_WK_V PMNTH,
1506: DDR_TIME_CLNDR_WK_V PQTR,
1507: DDR_TIME_CLNDR_WK_V PYR,
1508: DDR_TIME_CLNDR_WK_V NWK,
1509: DDR_TIME_CLNDR_WK_V NMNTH,
1510: DDR_TIME_CLNDR_WK_V NQTR,
1511: DDR_TIME_CLNDR_WK_V NYR

Line 1508: DDR_TIME_CLNDR_WK_V NWK,

1504: DDR_TIME_CLNDR_WK_V PWK,
1505: DDR_TIME_CLNDR_WK_V PMNTH,
1506: DDR_TIME_CLNDR_WK_V PQTR,
1507: DDR_TIME_CLNDR_WK_V PYR,
1508: DDR_TIME_CLNDR_WK_V NWK,
1509: DDR_TIME_CLNDR_WK_V NMNTH,
1510: DDR_TIME_CLNDR_WK_V NQTR,
1511: DDR_TIME_CLNDR_WK_V NYR
1512: WHERE PWK.CLNDR_CD(+) = WK.CLNDR_CD

Line 1509: DDR_TIME_CLNDR_WK_V NMNTH,

1505: DDR_TIME_CLNDR_WK_V PMNTH,
1506: DDR_TIME_CLNDR_WK_V PQTR,
1507: DDR_TIME_CLNDR_WK_V PYR,
1508: DDR_TIME_CLNDR_WK_V NWK,
1509: DDR_TIME_CLNDR_WK_V NMNTH,
1510: DDR_TIME_CLNDR_WK_V NQTR,
1511: DDR_TIME_CLNDR_WK_V NYR
1512: WHERE PWK.CLNDR_CD(+) = WK.CLNDR_CD
1513: AND PWK.WK_CD(+) = add_week(WK.WK_CD,-1)

Line 1510: DDR_TIME_CLNDR_WK_V NQTR,

1506: DDR_TIME_CLNDR_WK_V PQTR,
1507: DDR_TIME_CLNDR_WK_V PYR,
1508: DDR_TIME_CLNDR_WK_V NWK,
1509: DDR_TIME_CLNDR_WK_V NMNTH,
1510: DDR_TIME_CLNDR_WK_V NQTR,
1511: DDR_TIME_CLNDR_WK_V NYR
1512: WHERE PWK.CLNDR_CD(+) = WK.CLNDR_CD
1513: AND PWK.WK_CD(+) = add_week(WK.WK_CD,-1)
1514: AND PMNTH.CLNDR_CD(+) = WK.CLNDR_CD

Line 1511: DDR_TIME_CLNDR_WK_V NYR

1507: DDR_TIME_CLNDR_WK_V PYR,
1508: DDR_TIME_CLNDR_WK_V NWK,
1509: DDR_TIME_CLNDR_WK_V NMNTH,
1510: DDR_TIME_CLNDR_WK_V NQTR,
1511: DDR_TIME_CLNDR_WK_V NYR
1512: WHERE PWK.CLNDR_CD(+) = WK.CLNDR_CD
1513: AND PWK.WK_CD(+) = add_week(WK.WK_CD,-1)
1514: AND PMNTH.CLNDR_CD(+) = WK.CLNDR_CD
1515: AND PMNTH.WK_CD(+) = add_week(WK.WK_CD,-4)

Line 1816: FROM DDR_TIME_CLNDR_WK_V

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
1817: WHERE SUBSTR(WK_CD,1,4) BETWEEN TO_CHAR(p_start_year) AND
1818: TO_CHAR(p_end_year)
1819: );
1820: INSERT

Line 1866: FROM DDR_TIME_CLNDR_WK_V A,

1862: A.CLNDR_CD CLNDR_CD,
1863: A.CLNDR_TYP CLNDR_TYP,
1864: B.WK_CD YR_WK_CD,
1865: B.CLNDR_WK_ID YR_WK_ID
1866: FROM DDR_TIME_CLNDR_WK_V A,
1867: DDR_TIME_CLNDR_WK_V B
1868: WHERE A.WK_CD >= B.WK_CD
1869: AND A.ORG_CD = B.ORG_CD
1870: AND SUBSTR(A.WK_CD,1,4) = SUBSTR(B.WK_CD,1,4)

Line 1867: DDR_TIME_CLNDR_WK_V B

1863: A.CLNDR_TYP CLNDR_TYP,
1864: B.WK_CD YR_WK_CD,
1865: B.CLNDR_WK_ID YR_WK_ID
1866: FROM DDR_TIME_CLNDR_WK_V A,
1867: DDR_TIME_CLNDR_WK_V B
1868: WHERE A.WK_CD >= B.WK_CD
1869: AND A.ORG_CD = B.ORG_CD
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