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_QTR_V

Line 1623: FROM DDR_TIME_CLNDR_QTR_V

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
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

Line 1676: FROM DDR_TIME_CLNDR_QTR_V QTR,

1672: g_creation_date,
1673: g_last_updated_by,
1674: g_last_update_date,
1675: g_last_update_login
1676: FROM DDR_TIME_CLNDR_QTR_V QTR,
1677: DDR_TIME_CLNDR_QTR_V PQTR,
1678: DDR_TIME_CLNDR_QTR_V PYR,
1679: DDR_TIME_CLNDR_QTR_V NQTR,
1680: DDR_TIME_CLNDR_QTR_V NYR

Line 1677: DDR_TIME_CLNDR_QTR_V PQTR,

1673: g_last_updated_by,
1674: g_last_update_date,
1675: g_last_update_login
1676: FROM DDR_TIME_CLNDR_QTR_V QTR,
1677: DDR_TIME_CLNDR_QTR_V PQTR,
1678: DDR_TIME_CLNDR_QTR_V PYR,
1679: DDR_TIME_CLNDR_QTR_V NQTR,
1680: DDR_TIME_CLNDR_QTR_V NYR
1681: WHERE QTR.YR_CD BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)

Line 1678: DDR_TIME_CLNDR_QTR_V PYR,

1674: g_last_update_date,
1675: g_last_update_login
1676: FROM DDR_TIME_CLNDR_QTR_V QTR,
1677: DDR_TIME_CLNDR_QTR_V PQTR,
1678: DDR_TIME_CLNDR_QTR_V PYR,
1679: DDR_TIME_CLNDR_QTR_V NQTR,
1680: DDR_TIME_CLNDR_QTR_V NYR
1681: WHERE QTR.YR_CD BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)
1682: AND PQTR.ORG_CD(+) = QTR.ORG_CD

Line 1679: DDR_TIME_CLNDR_QTR_V NQTR,

1675: g_last_update_login
1676: FROM DDR_TIME_CLNDR_QTR_V QTR,
1677: DDR_TIME_CLNDR_QTR_V PQTR,
1678: DDR_TIME_CLNDR_QTR_V PYR,
1679: DDR_TIME_CLNDR_QTR_V NQTR,
1680: DDR_TIME_CLNDR_QTR_V NYR
1681: WHERE QTR.YR_CD BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)
1682: AND PQTR.ORG_CD(+) = QTR.ORG_CD
1683: AND PQTR.CLNDR_CD(+) = QTR.CLNDR_CD

Line 1680: DDR_TIME_CLNDR_QTR_V NYR

1676: FROM DDR_TIME_CLNDR_QTR_V QTR,
1677: DDR_TIME_CLNDR_QTR_V PQTR,
1678: DDR_TIME_CLNDR_QTR_V PYR,
1679: DDR_TIME_CLNDR_QTR_V NQTR,
1680: DDR_TIME_CLNDR_QTR_V NYR
1681: WHERE QTR.YR_CD BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)
1682: AND PQTR.ORG_CD(+) = QTR.ORG_CD
1683: AND PQTR.CLNDR_CD(+) = QTR.CLNDR_CD
1684: AND PQTR.QTR_CD(+) = add_quarter(QTR.QTR_CD,-1)

Line 1942: FROM DDR_TIME_CLNDR_QTR_V

1938: FROM DDR_R_QTR_TODATE_TRANS
1939: WHERE (QTR_CD,CLNDR_CD) IN
1940: (SELECT QTR_CD,
1941: CLNDR_CD
1942: FROM DDR_TIME_CLNDR_QTR_V
1943: WHERE YR_CD BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)
1944: );
1945: INSERT
1946: INTO DDR_R_QTR_TODATE_TRANS

Line 1991: FROM DDR_TIME_CLNDR_QTR_V A,

1987: A.CLNDR_CD CLNDR_CD,
1988: A.CLNDR_CD CLNDR_TYP,
1989: B.QTR_CD YR_QTR_CD,
1990: B.CLNDR_QTR_ID YR_QTR_ID
1991: FROM DDR_TIME_CLNDR_QTR_V A,
1992: DDR_TIME_CLNDR_QTR_V B
1993: WHERE A.YR_CD = B.YR_CD
1994: AND A.QTR_CD >= B.QTR_CD
1995: AND A.ORG_CD = B.ORG_CD

Line 1992: DDR_TIME_CLNDR_QTR_V B

1988: A.CLNDR_CD CLNDR_TYP,
1989: B.QTR_CD YR_QTR_CD,
1990: B.CLNDR_QTR_ID YR_QTR_ID
1991: FROM DDR_TIME_CLNDR_QTR_V A,
1992: DDR_TIME_CLNDR_QTR_V B
1993: WHERE A.YR_CD = B.YR_CD
1994: AND A.QTR_CD >= B.QTR_CD
1995: AND A.ORG_CD = B.ORG_CD
1996: AND A.YR_CD BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)