1. Tables and Views for Sales and Fusion Service
  2. HZ_CLASS_CATEGORY_CODES_V

HZ_CLASS_CATEGORY_CODES_V

Details

  • Schema: FUSION

  • Object owner: HZ

  • Object type: VIEW

Columns

Name

CLASS_CATEGORY

CLASS_CODE

VIEW_APPLICATION_ID

MEANING

DESCRIPTION

START_DATE_ACTIVE

END_DATE_ACTIVE

LAST_UPDATED_BY

Query

SQL_Statement

SELECT

CC.CLASS_CATEGORY,

LV.LOOKUP_CODE AS CLASS_CODE,

LV.VIEW_APPLICATION_ID,

LV.MEANING,

LV.DESCRIPTION,

LV.START_DATE_ACTIVE,

LV.END_DATE_ACTIVE,

LV.LAST_UPDATED_BY

FROM

HZ_CLASS_CATEGORIES CC,

FND_LOOKUP_VALUES LV

WHERE CC.CLASS_CATEGORY = LV.LOOKUP_TYPE

AND CC.LKUP_TYPE_OWNER_ID = LV.VIEW_APPLICATION_ID

AND LV.LANGUAGE = userenv('LANG')

AND LV.ENABLED_FLAG = 'Y'

AND TRUNC(SYSDATE) BETWEEN trunc(nvl(LV.START_DATE_ACTIVE, SYSDATE)) AND trunc(nvl(LV.END_DATE_ACTIVE, TO_DATE('4712-12-31','YYYY-MM-DD')))

AND LV.SET_ID = 0

AND CC.STATUS_FLAG = 'A'