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 286: FROM DDR_R_RTL_ITEM_CMPNY

282: l_return VARCHAR2(30);
283:
284: CURSOR cur_cmpny IS
285: SELECT 1
286: FROM DDR_R_RTL_ITEM_CMPNY
287: WHERE RTL_CMPNY_CD = p_hchy_cd;
288:
289: CURSOR cur_div IS
290: SELECT 1

Line 291: FROM DDR_R_RTL_ITEM_DIV

287: WHERE RTL_CMPNY_CD = p_hchy_cd;
288:
289: CURSOR cur_div IS
290: SELECT 1
291: FROM DDR_R_RTL_ITEM_DIV
292: WHERE RTL_DIV_CD = p_hchy_cd
293: AND EFF_TO_DT IS NULL;
294:
295: CURSOR cur_grp IS

Line 297: FROM DDR_R_RTL_ITEM_GRP

293: AND EFF_TO_DT IS NULL;
294:
295: CURSOR cur_grp IS
296: SELECT 1
297: FROM DDR_R_RTL_ITEM_GRP
298: WHERE RTL_GRP_CD = p_hchy_cd
299: AND EFF_TO_DT IS NULL;
300:
301: CURSOR cur_dept IS

Line 303: FROM DDR_R_RTL_ITEM_DEPT

299: AND EFF_TO_DT IS NULL;
300:
301: CURSOR cur_dept IS
302: SELECT 1
303: FROM DDR_R_RTL_ITEM_DEPT
304: WHERE RTL_DEPT_CD = p_hchy_cd
305: AND EFF_TO_DT IS NULL;
306:
307: CURSOR cur_class IS

Line 309: FROM DDR_R_RTL_ITEM_CLASS

305: AND EFF_TO_DT IS NULL;
306:
307: CURSOR cur_class IS
308: SELECT 1
309: FROM DDR_R_RTL_ITEM_CLASS
310: WHERE RTL_CLASS_CD = p_hchy_cd
311: AND EFF_TO_DT IS NULL;
312:
313: CURSOR cur_sbc IS

Line 315: FROM DDR_R_RTL_ITEM_SBC

311: AND EFF_TO_DT IS NULL;
312:
313: CURSOR cur_sbc IS
314: SELECT 1
315: FROM DDR_R_RTL_ITEM_SBC
316: WHERE RTL_SBC_CD = p_hchy_cd
317: AND EFF_TO_DT IS NULL;
318:
319: CURSOR cur_item IS

Line 321: FROM DDR_R_RTL_ITEM

317: AND EFF_TO_DT IS NULL;
318:
319: CURSOR cur_item IS
320: SELECT 1
321: FROM DDR_R_RTL_ITEM
322: WHERE RTL_ITEM_NBR = p_hchy_cd
323: AND EFF_TO_DT IS NULL;
324:
325: CURSOR cur_sku IS