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.HZ_CUST_CLASS_DENORM dependencies on HZ_CLASS_CODE_RELATIONS

Line 179: FROM HZ_CLASS_CODE_RELATIONS CCR

175: --AND CC.ALLOW_MULTI_PARENT_FLAG = 'N'
176: AND CCU.OWNER_TABLE='HZ_PARTIES'
177: AND NOT EXISTS(
178: SELECT 'X'
179: FROM HZ_CLASS_CODE_RELATIONS CCR
180: WHERE LV.LOOKUP_CODE = CCR.SUB_CLASS_CODE
181: AND CCR.CLASS_CATEGORY = LT.LOOKUP_TYPE
182: AND sysdate between ccr.start_date_active and nvl(ccr.end_date_active,sysdate));
183:

Line 238: HZ_CLASS_CODE_RELATIONS CCR,

234: FND_LOOKUP_TYPES_TL LT,
235: FND_LOOKUP_VALUES LV,
236: HZ_CLASS_CATEGORIES CC,
237: HZ_CLASS_CATEGORY_USES CCU,
238: HZ_CLASS_CODE_RELATIONS CCR,
239: HZ_CLASS_CODE_DENORM DENORM
240: WHERE LT.LOOKUP_TYPE = CC.CLASS_CATEGORY
241: AND LT.VIEW_APPLICATION_ID = 222
242: AND LV.VIEW_APPLICATION_ID = 222

Line 283: HZ_CLASS_CODE_RELATIONS CCR,

279: FND_LOOKUP_TYPES_TL LT,
280: FND_LOOKUP_VALUES LV,
281: HZ_CLASS_CATEGORIES CC,
282: HZ_CLASS_CATEGORY_USES CCU,
283: HZ_CLASS_CODE_RELATIONS CCR,
284: HZ_CLASS_CODE_DENORM DENORM
285: WHERE LT.LOOKUP_TYPE = CC.CLASS_CATEGORY
286: AND LT.VIEW_APPLICATION_ID = 222
287: AND LV.VIEW_APPLICATION_ID = 222

Line 310: /* Bug 2657352. Removed hz_class_code_relations rel1 and fnd_lookup_values lv from the join.

306:
307:
308: -- set selectable_flag based on allow_leaf_node_only_flag
309:
310: /* Bug 2657352. Removed hz_class_code_relations rel1 and fnd_lookup_values lv from the join.
311: * Furthermore considered the date range of the relationships in
312: * hz_class_code_relations
313: *
314: * update hz_class_code_denorm denorm

Line 312: * hz_class_code_relations

308: -- set selectable_flag based on allow_leaf_node_only_flag
309:
310: /* Bug 2657352. Removed hz_class_code_relations rel1 and fnd_lookup_values lv from the join.
311: * Furthermore considered the date range of the relationships in
312: * hz_class_code_relations
313: *
314: * update hz_class_code_denorm denorm
315: * set selectable_flag ='N'
316: * where exists (select 'x'

Line 317: * from hz_class_code_relations rel1,

313: *
314: * update hz_class_code_denorm denorm
315: * set selectable_flag ='N'
316: * where exists (select 'x'
317: * from hz_class_code_relations rel1,
318: * hz_class_code_relations rel2,
319: * fnd_lookup_values lv,
320: * hz_class_categories cc
321: * where lv.lookup_type = denorm.class_category

Line 318: * hz_class_code_relations rel2,

314: * update hz_class_code_denorm denorm
315: * set selectable_flag ='N'
316: * where exists (select 'x'
317: * from hz_class_code_relations rel1,
318: * hz_class_code_relations rel2,
319: * fnd_lookup_values lv,
320: * hz_class_categories cc
321: * where lv.lookup_type = denorm.class_category
322: * and lv.VIEW_APPLICATION_ID = 222

Line 336: FROM hz_class_code_relations rel1,

332: UPDATE hz_class_code_denorm denorm
333: SET selectable_flag ='N'
334: WHERE EXISTS
335: (SELECT 'X'
336: FROM hz_class_code_relations rel1,
337: hz_class_categories cc
338: WHERE denorm.class_category = rel1.class_category AND
339: cc.class_category = denorm.class_category AND
340: rel1.class_code = denorm.class_code AND

Line 416: FROM HZ_CLASS_CODE_RELATIONS CCR

412: AND CCU.OWNER_TABLE='HZ_PARTIES'
413: AND CC.CLASS_CATEGORY = P_CLASS_CATEGORY
414: AND NOT EXISTS(
415: SELECT 'X'
416: FROM HZ_CLASS_CODE_RELATIONS CCR
417: WHERE LV.LOOKUP_CODE = CCR.SUB_CLASS_CODE
418: AND CCR.CLASS_CATEGORY = LT.LOOKUP_TYPE
419: AND sysdate between ccr.start_date_active and nvl(ccr.end_date_active,sysdate));
420:

Line 476: HZ_CLASS_CODE_RELATIONS CCR,

472: FND_LOOKUP_TYPES_TL LT,
473: FND_LOOKUP_VALUES LV,
474: HZ_CLASS_CATEGORIES CC,
475: HZ_CLASS_CATEGORY_USES CCU,
476: HZ_CLASS_CODE_RELATIONS CCR,
477: HZ_CLASS_CODE_DENORM DENORM
478: WHERE LT.LOOKUP_TYPE = CC.CLASS_CATEGORY
479: AND LT.VIEW_APPLICATION_ID = 222
480: AND LV.VIEW_APPLICATION_ID = 222

Line 522: HZ_CLASS_CODE_RELATIONS CCR,

518: FND_LOOKUP_TYPES_TL LT,
519: FND_LOOKUP_VALUES LV,
520: HZ_CLASS_CATEGORIES CC,
521: HZ_CLASS_CATEGORY_USES CCU,
522: HZ_CLASS_CODE_RELATIONS CCR,
523: HZ_CLASS_CODE_DENORM DENORM
524: WHERE LT.LOOKUP_TYPE = CC.CLASS_CATEGORY
525: AND LT.VIEW_APPLICATION_ID = 222
526: AND LV.VIEW_APPLICATION_ID = 222

Line 551: /* Bug 2657352.Removed joins to hz_class_code_relations rel1, fnd_lookup_values lv,

547:
548:
549: -- set selectable_flag based on allow_leaf_node_only_flag
550:
551: /* Bug 2657352.Removed joins to hz_class_code_relations rel1, fnd_lookup_values lv,
552: * hz_class_categories.
553: * Considered date range in hz_class_code_relations
554: * Performed the update only if allow_leaf_node_flag is 'Y'.
555: * Used an anonymous block so that resources for variable

Line 553: * Considered date range in hz_class_code_relations

549: -- set selectable_flag based on allow_leaf_node_only_flag
550:
551: /* Bug 2657352.Removed joins to hz_class_code_relations rel1, fnd_lookup_values lv,
552: * hz_class_categories.
553: * Considered date range in hz_class_code_relations
554: * Performed the update only if allow_leaf_node_flag is 'Y'.
555: * Used an anonymous block so that resources for variable
556: * l_allow_leaf_node_only_flag are released after this block.
557: *

Line 562: * from hz_class_code_relations rel1,

558: * update hz_class_code_denorm denorm
559: * set selectable_flag ='N'
560: * where denorm.class_category = p_class_category
561: * and exists (select 'x'
562: * from hz_class_code_relations rel1,
563: * hz_class_code_relations rel2,
564: * fnd_lookup_values lv,
565: * hz_class_categories cc
566: * where lv.lookup_type = denorm.class_category

Line 563: * hz_class_code_relations rel2,

559: * set selectable_flag ='N'
560: * where denorm.class_category = p_class_category
561: * and exists (select 'x'
562: * from hz_class_code_relations rel1,
563: * hz_class_code_relations rel2,
564: * fnd_lookup_values lv,
565: * hz_class_categories cc
566: * where lv.lookup_type = denorm.class_category
567: * and lv.VIEW_APPLICATION_ID = 222

Line 594: FROM hz_class_code_relations rel1

590: SET selectable_flag ='N'
591: WHERE denorm.class_category = p_class_category AND
592: EXISTS
593: (SELECT 'x'
594: FROM hz_class_code_relations rel1
595: WHERE denorm.class_category = rel1.class_category AND
596: rel1.class_code = denorm.class_code AND
597: SYSDATE >= rel1.start_date_active AND
598: SYSDATE <= NVL(rel1.end_date_active, SYSDATE + 1)