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_CATEGORIES

Line 167: HZ_CLASS_CATEGORIES CC,

163: SYSDATE
164: FROM
165: FND_LOOKUP_TYPES_TL LT,
166: FND_LOOKUP_VALUES LV,
167: HZ_CLASS_CATEGORIES CC,
168: HZ_CLASS_CATEGORY_USES CCU
169: WHERE LT.LOOKUP_TYPE = CC.CLASS_CATEGORY
170: AND LT.VIEW_APPLICATION_ID = 222
171: AND LV.VIEW_APPLICATION_ID = 222

Line 236: HZ_CLASS_CATEGORIES CC,

232: SYSDATE
233: FROM
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

Line 281: HZ_CLASS_CATEGORIES CC,

277: SYSDATE
278: FROM
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

Line 320: * hz_class_categories cc

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
323: * and denorm.class_category= rel1.class_category
324: * and denorm.class_category= rel2.class_category

Line 337: hz_class_categories cc

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
341: SYSDATE >= rel1.start_date_active AND

Line 347: update hz_class_categories

343: cc.allow_leaf_node_only_flag = 'Y');
344:
345:
346: -- Set frozen_flag to 'Y' - means no dirty data
347: update hz_class_categories
348: set frozen_flag = 'Y'
349: where (frozen_flag = 'N' or frozen_flag is null);
350:
351: else -- p_class_category is passed in

Line 403: HZ_CLASS_CATEGORIES CC,

399: SYSDATE
400: FROM
401: FND_LOOKUP_TYPES_TL LT,
402: FND_LOOKUP_VALUES LV,
403: HZ_CLASS_CATEGORIES CC,
404: HZ_CLASS_CATEGORY_USES CCU
405: WHERE LT.LOOKUP_TYPE = CC.CLASS_CATEGORY
406: AND LT.VIEW_APPLICATION_ID = 222
407: AND LV.VIEW_APPLICATION_ID = 222

Line 474: HZ_CLASS_CATEGORIES CC,

470: SYSDATE
471: FROM
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

Line 520: HZ_CLASS_CATEGORIES CC,

516: SYSDATE
517: FROM
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

Line 552: * hz_class_categories.

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
556: * l_allow_leaf_node_only_flag are released after this block.

Line 565: * hz_class_categories cc

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
568: * and denorm.class_category= rel1.class_category
569: * and denorm.class_category= rel2.class_category

Line 579: l_allow_leaf_node_only_flag HZ_CLASS_CATEGORIES.ALLOW_LEAF_NODE_ONLY_FLAG%TYPE;

575: * and cc.allow_leaf_node_only_flag = 'Y');
576: */
577:
578: DECLARE
579: l_allow_leaf_node_only_flag HZ_CLASS_CATEGORIES.ALLOW_LEAF_NODE_ONLY_FLAG%TYPE;
580: BEGIN
581: SELECT allow_leaf_node_only_flag
582: INTO l_allow_leaf_node_only_flag
583: FROM HZ_CLASS_CATEGORIES

Line 583: FROM HZ_CLASS_CATEGORIES

579: l_allow_leaf_node_only_flag HZ_CLASS_CATEGORIES.ALLOW_LEAF_NODE_ONLY_FLAG%TYPE;
580: BEGIN
581: SELECT allow_leaf_node_only_flag
582: INTO l_allow_leaf_node_only_flag
583: FROM HZ_CLASS_CATEGORIES
584: WHERE class_category = p_class_category;
585:
586: IF (l_allow_leaf_node_only_flag = 'Y')
587: THEN

Line 604: update hz_class_categories

600: END IF;
601: END;
602:
603: -- Set frozen_flag to 'Y' - means no dirty data
604: update hz_class_categories
605: set frozen_flag = 'Y'
606: where class_category = p_class_category
607: and (frozen_flag = 'N' or frozen_flag is null);
608: