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_DAY_V

Line 127: from DDR_TIME_BSNS_DAY_V

123: /* Populate DDR_R_DAY_TRANS table */
124: delete from DDR_R_DAY_TRANS
125: where (DAY_CD,CLNDR_CD) in (
126: select DAY_CD,CLNDR_CD
127: from DDR_TIME_BSNS_DAY_V
128: where ORG_CD = p_org_cd
129: and YR_CD between to_char(p_start_year) and to_char(p_end_year)
130: );
131:

Line 188: DDR_TIME_BSNS_DAY_V BDAY,

184: g_last_updated_by,
185: g_last_update_date,
186: g_last_update_login
187: from
188: DDR_TIME_BSNS_DAY_V BDAY,
189: DDR_TIME_BSNS_DAY_V PDAY,
190: DDR_TIME_BSNS_DAY_V PWK,
191: DDR_TIME_BSNS_DAY_V PMNTH,
192: DDR_TIME_BSNS_DAY_V PQTR,

Line 189: DDR_TIME_BSNS_DAY_V PDAY,

185: g_last_update_date,
186: g_last_update_login
187: from
188: DDR_TIME_BSNS_DAY_V BDAY,
189: DDR_TIME_BSNS_DAY_V PDAY,
190: DDR_TIME_BSNS_DAY_V PWK,
191: DDR_TIME_BSNS_DAY_V PMNTH,
192: DDR_TIME_BSNS_DAY_V PQTR,
193: DDR_TIME_BSNS_DAY_V PYR,

Line 190: DDR_TIME_BSNS_DAY_V PWK,

186: g_last_update_login
187: from
188: DDR_TIME_BSNS_DAY_V BDAY,
189: DDR_TIME_BSNS_DAY_V PDAY,
190: DDR_TIME_BSNS_DAY_V PWK,
191: DDR_TIME_BSNS_DAY_V PMNTH,
192: DDR_TIME_BSNS_DAY_V PQTR,
193: DDR_TIME_BSNS_DAY_V PYR,
194: DDR_TIME_BSNS_DAY_V NDAY,

Line 191: DDR_TIME_BSNS_DAY_V PMNTH,

187: from
188: DDR_TIME_BSNS_DAY_V BDAY,
189: DDR_TIME_BSNS_DAY_V PDAY,
190: DDR_TIME_BSNS_DAY_V PWK,
191: DDR_TIME_BSNS_DAY_V PMNTH,
192: DDR_TIME_BSNS_DAY_V PQTR,
193: DDR_TIME_BSNS_DAY_V PYR,
194: DDR_TIME_BSNS_DAY_V NDAY,
195: DDR_TIME_BSNS_DAY_V NWK,

Line 192: DDR_TIME_BSNS_DAY_V PQTR,

188: DDR_TIME_BSNS_DAY_V BDAY,
189: DDR_TIME_BSNS_DAY_V PDAY,
190: DDR_TIME_BSNS_DAY_V PWK,
191: DDR_TIME_BSNS_DAY_V PMNTH,
192: DDR_TIME_BSNS_DAY_V PQTR,
193: DDR_TIME_BSNS_DAY_V PYR,
194: DDR_TIME_BSNS_DAY_V NDAY,
195: DDR_TIME_BSNS_DAY_V NWK,
196: DDR_TIME_BSNS_DAY_V NMNTH,

Line 193: DDR_TIME_BSNS_DAY_V PYR,

189: DDR_TIME_BSNS_DAY_V PDAY,
190: DDR_TIME_BSNS_DAY_V PWK,
191: DDR_TIME_BSNS_DAY_V PMNTH,
192: DDR_TIME_BSNS_DAY_V PQTR,
193: DDR_TIME_BSNS_DAY_V PYR,
194: DDR_TIME_BSNS_DAY_V NDAY,
195: DDR_TIME_BSNS_DAY_V NWK,
196: DDR_TIME_BSNS_DAY_V NMNTH,
197: DDR_TIME_BSNS_DAY_V NQTR,

Line 194: DDR_TIME_BSNS_DAY_V NDAY,

190: DDR_TIME_BSNS_DAY_V PWK,
191: DDR_TIME_BSNS_DAY_V PMNTH,
192: DDR_TIME_BSNS_DAY_V PQTR,
193: DDR_TIME_BSNS_DAY_V PYR,
194: DDR_TIME_BSNS_DAY_V NDAY,
195: DDR_TIME_BSNS_DAY_V NWK,
196: DDR_TIME_BSNS_DAY_V NMNTH,
197: DDR_TIME_BSNS_DAY_V NQTR,
198: DDR_TIME_BSNS_DAY_V NYR

Line 195: DDR_TIME_BSNS_DAY_V NWK,

191: DDR_TIME_BSNS_DAY_V PMNTH,
192: DDR_TIME_BSNS_DAY_V PQTR,
193: DDR_TIME_BSNS_DAY_V PYR,
194: DDR_TIME_BSNS_DAY_V NDAY,
195: DDR_TIME_BSNS_DAY_V NWK,
196: DDR_TIME_BSNS_DAY_V NMNTH,
197: DDR_TIME_BSNS_DAY_V NQTR,
198: DDR_TIME_BSNS_DAY_V NYR
199: where BDAY.ORG_CD = p_org_cd

Line 196: DDR_TIME_BSNS_DAY_V NMNTH,

192: DDR_TIME_BSNS_DAY_V PQTR,
193: DDR_TIME_BSNS_DAY_V PYR,
194: DDR_TIME_BSNS_DAY_V NDAY,
195: DDR_TIME_BSNS_DAY_V NWK,
196: DDR_TIME_BSNS_DAY_V NMNTH,
197: DDR_TIME_BSNS_DAY_V NQTR,
198: DDR_TIME_BSNS_DAY_V NYR
199: where BDAY.ORG_CD = p_org_cd
200: and BDAY.YR_CD between to_char(p_start_year) and to_char(p_end_year)

Line 197: DDR_TIME_BSNS_DAY_V NQTR,

193: DDR_TIME_BSNS_DAY_V PYR,
194: DDR_TIME_BSNS_DAY_V NDAY,
195: DDR_TIME_BSNS_DAY_V NWK,
196: DDR_TIME_BSNS_DAY_V NMNTH,
197: DDR_TIME_BSNS_DAY_V NQTR,
198: DDR_TIME_BSNS_DAY_V NYR
199: where BDAY.ORG_CD = p_org_cd
200: and BDAY.YR_CD between to_char(p_start_year) and to_char(p_end_year)
201: and PDAY.ORG_CD(+) = BDAY.ORG_CD

Line 198: DDR_TIME_BSNS_DAY_V NYR

194: DDR_TIME_BSNS_DAY_V NDAY,
195: DDR_TIME_BSNS_DAY_V NWK,
196: DDR_TIME_BSNS_DAY_V NMNTH,
197: DDR_TIME_BSNS_DAY_V NQTR,
198: DDR_TIME_BSNS_DAY_V NYR
199: where BDAY.ORG_CD = p_org_cd
200: and BDAY.YR_CD between to_char(p_start_year) and to_char(p_end_year)
201: and PDAY.ORG_CD(+) = BDAY.ORG_CD
202: and PDAY.CLNDR_CD(+) = BDAY.CLNDR_CD

Line 598: from DDR_TIME_BSNS_DAY_V

594: /* Populate DDR_R_DAY_TODATE_TRANS table */
595: delete from DDR_R_DAY_TODATE_TRANS
596: where (DAY_CD,CLNDR_CD) in (
597: select DAY_CD,CLNDR_CD
598: from DDR_TIME_BSNS_DAY_V
599: where ORG_CD = p_org_cd
600: and YR_CD between to_char(p_start_year) and to_char(p_end_year)
601: );
602:

Line 642: FROM DDR_TIME_BSNS_DAY_V A,

638: A.MFG_ORG_CD MFG_ORG_CD,
639: A.DAY_CD DAY_CD,
640: A.CLNDR_CD CLNDR_CD,
641: B.DAY_CD YR_DAY_CD
642: FROM DDR_TIME_BSNS_DAY_V A,
643: DDR_TIME_BSNS_DAY_V B
644: WHERE A.YR_CD = B.YR_CD
645: AND A.DAY_CD >= B.DAY_CD
646: AND A.ORG_CD = B.ORG_CD

Line 643: DDR_TIME_BSNS_DAY_V B

639: A.DAY_CD DAY_CD,
640: A.CLNDR_CD CLNDR_CD,
641: B.DAY_CD YR_DAY_CD
642: FROM DDR_TIME_BSNS_DAY_V A,
643: DDR_TIME_BSNS_DAY_V B
644: WHERE A.YR_CD = B.YR_CD
645: AND A.DAY_CD >= B.DAY_CD
646: AND A.ORG_CD = B.ORG_CD
647: AND A.ORG_CD = p_org_cd