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_TODATE_TRANS

Line 780: /* Populate DDR_R_QTR_TODATE_TRANS table */

776: AND A.YR_CD between to_char(p_start_year) and to_char(p_end_year)
777: ORDER BY A.MNTH_CD,
778: B.MNTH_CD) YTD;
779:
780: /* Populate DDR_R_QTR_TODATE_TRANS table */
781: delete from DDR_R_QTR_TODATE_TRANS
782: where (QTR_CD,CLNDR_CD) in (
783: select QTR_CD,CLNDR_CD
784: from DDR_TIME_BSNS_QTR_V

Line 781: delete from DDR_R_QTR_TODATE_TRANS

777: ORDER BY A.MNTH_CD,
778: B.MNTH_CD) YTD;
779:
780: /* Populate DDR_R_QTR_TODATE_TRANS table */
781: delete from DDR_R_QTR_TODATE_TRANS
782: where (QTR_CD,CLNDR_CD) in (
783: select QTR_CD,CLNDR_CD
784: from DDR_TIME_BSNS_QTR_V
785: where ORG_CD = p_org_cd

Line 789: INSERT INTO DDR_R_QTR_TODATE_TRANS(

785: where ORG_CD = p_org_cd
786: and YR_CD between to_char(p_start_year) and to_char(p_end_year)
787: );
788:
789: INSERT INTO DDR_R_QTR_TODATE_TRANS(
790: MFG_ORG_CD,
791: QTR_TODATE_TRANS_ID,
792: QTR_ID,
793: QTR_CD,

Line 810: DDR_R_QTR_TODATE_TRANS_SEQ.NEXTVAL,

806: LAST_UPDATE_LOGIN
807: )
808: select
809: YTD.MFG_ORG_CD,
810: DDR_R_QTR_TODATE_TRANS_SEQ.NEXTVAL,
811: YTD.QTR_ID,
812: YTD.QTR_CD,
813: YTD.CLNDR_CD,
814: 'BSNS',

Line 1936: /* Populate DDR_R_QTR_TODATE_TRANS table */

1932: AND A.MNTH_CD >= B.MNTH_CD
1933: AND A.ORG_CD = B.ORG_CD
1934: AND A.YR_CD BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)
1935: ORDER BY A.MNTH_CD, B.MNTH_CD) YTD;
1936: /* Populate DDR_R_QTR_TODATE_TRANS table */
1937: DELETE
1938: FROM DDR_R_QTR_TODATE_TRANS
1939: WHERE (QTR_CD,CLNDR_CD) IN
1940: (SELECT QTR_CD,

Line 1938: FROM DDR_R_QTR_TODATE_TRANS

1934: AND A.YR_CD BETWEEN TO_CHAR(p_start_year) AND TO_CHAR(p_end_year)
1935: ORDER BY A.MNTH_CD, B.MNTH_CD) YTD;
1936: /* Populate DDR_R_QTR_TODATE_TRANS table */
1937: DELETE
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

Line 1946: INTO DDR_R_QTR_TODATE_TRANS

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
1947: (
1948: MFG_ORG_CD,
1949: QTR_TODATE_TRANS_ID,
1950: QTR_ID,

Line 1967: DDR_R_QTR_TODATE_TRANS_SEQ.NEXTVAL,

1963: LAST_UPDATE_DATE ,
1964: LAST_UPDATE_LOGIN
1965: )
1966: SELECT YTD.ORG_CD,
1967: DDR_R_QTR_TODATE_TRANS_SEQ.NEXTVAL,
1968: YTD.QTR_ID,
1969: YTD.QTR_CD,
1970: YTD.CLNDR_CD,
1971: YTD.CLNDR_TYP,