DBA Data[Home] [Help]

APPS.HZ_CUST_CLASS_DENORM dependencies on FND_LOOKUP_VALUES

Line 166: FND_LOOKUP_VALUES LV,

162: FND_GLOBAL.PROG_APPL_ID,
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

Line 235: FND_LOOKUP_VALUES LV,

231: FND_GLOBAL.PROG_APPL_ID,
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

Line 280: FND_LOOKUP_VALUES LV,

276: FND_GLOBAL.PROG_APPL_ID,
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

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 319: * fnd_lookup_values lv,

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

Line 402: FND_LOOKUP_VALUES LV,

398: FND_GLOBAL.PROG_APPL_ID,
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

Line 473: FND_LOOKUP_VALUES LV,

469: FND_GLOBAL.PROG_APPL_ID,
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

Line 519: FND_LOOKUP_VALUES LV,

515: FND_GLOBAL.PROG_APPL_ID,
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

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 564: * fnd_lookup_values lv,

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