APPS.HZ_CUST_CLASS_DENORM dependencies on HZ_CLASS_CATEGORY_USES

Line 168: HZ_CLASS_CATEGORY_USES CCU

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
172: AND CC.CLASS_CATEGORY = CCU.CLASS_CATEGORY

Line 237: HZ_CLASS_CATEGORY_USES CCU,

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
241: AND LT.VIEW_APPLICATION_ID = 222

Line 282: HZ_CLASS_CATEGORY_USES CCU,

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
286: AND LT.VIEW_APPLICATION_ID = 222

Line 404: HZ_CLASS_CATEGORY_USES CCU

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
408: AND CC.CLASS_CATEGORY = CCU.CLASS_CATEGORY

Line 475: HZ_CLASS_CATEGORY_USES CCU,

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
479: AND LT.VIEW_APPLICATION_ID = 222

Line 521: HZ_CLASS_CATEGORY_USES CCU,

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
525: AND LT.VIEW_APPLICATION_ID = 222