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_REF_UTIL_PKG dependencies on DDR_R_RTL_ITEM

Line 270: FROM DDR_R_RTL_ITEM_CMPNY

266: l_return VARCHAR2(30);
267:
268: CURSOR cur_cmpny IS
269: SELECT 1
270: FROM DDR_R_RTL_ITEM_CMPNY
271: WHERE RTL_CMPNY_CD = p_hchy_cd;
272:
273: CURSOR cur_div IS
274: SELECT 1

Line 275: FROM DDR_R_RTL_ITEM_DIV

271: WHERE RTL_CMPNY_CD = p_hchy_cd;
272:
273: CURSOR cur_div IS
274: SELECT 1
275: FROM DDR_R_RTL_ITEM_DIV
276: WHERE RTL_DIV_CD = p_hchy_cd
277: AND EFF_TO_DT IS NULL;
278:
279: CURSOR cur_grp IS

Line 281: FROM DDR_R_RTL_ITEM_GRP

277: AND EFF_TO_DT IS NULL;
278:
279: CURSOR cur_grp IS
280: SELECT 1
281: FROM DDR_R_RTL_ITEM_GRP
282: WHERE RTL_GRP_CD = p_hchy_cd
283: AND EFF_TO_DT IS NULL;
284:
285: CURSOR cur_dept IS

Line 287: FROM DDR_R_RTL_ITEM_DEPT

283: AND EFF_TO_DT IS NULL;
284:
285: CURSOR cur_dept IS
286: SELECT 1
287: FROM DDR_R_RTL_ITEM_DEPT
288: WHERE RTL_DEPT_CD = p_hchy_cd
289: AND EFF_TO_DT IS NULL;
290:
291: CURSOR cur_class IS

Line 293: FROM DDR_R_RTL_ITEM_CLASS

289: AND EFF_TO_DT IS NULL;
290:
291: CURSOR cur_class IS
292: SELECT 1
293: FROM DDR_R_RTL_ITEM_CLASS
294: WHERE RTL_CLASS_CD = p_hchy_cd
295: AND EFF_TO_DT IS NULL;
296:
297: CURSOR cur_sbc IS

Line 299: FROM DDR_R_RTL_ITEM_SBC

295: AND EFF_TO_DT IS NULL;
296:
297: CURSOR cur_sbc IS
298: SELECT 1
299: FROM DDR_R_RTL_ITEM_SBC
300: WHERE RTL_SBC_CD = p_hchy_cd
301: AND EFF_TO_DT IS NULL;
302:
303: CURSOR cur_item IS

Line 305: FROM DDR_R_RTL_ITEM

301: AND EFF_TO_DT IS NULL;
302:
303: CURSOR cur_item IS
304: SELECT 1
305: FROM DDR_R_RTL_ITEM
306: WHERE RTL_ITEM_NBR = p_hchy_cd
307: AND EFF_TO_DT IS NULL;
308:
309: CURSOR cur_sku IS