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

HZ_LOOKUPS

Details

  • Schema: FUSION

  • Object owner: HZ

  • Object type: VIEW

Columns

Name

LOOKUP_TYPE

LANGUAGE

LOOKUP_CODE

MEANING

DESCRIPTION

ENABLED_FLAG

START_DATE_ACTIVE

END_DATE_ACTIVE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

SOURCE_LANG

VIEW_APPLICATION_ID

TERRITORY_CODE

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

TAG

SET_ID

DISPLAY_SEQUENCE

Query

SQL_Statement

SELECT LV.LOOKUP_TYPE,

LVT.LANGUAGE,

LV.LOOKUP_CODE,

LVT.MEANING,

LVT.DESCRIPTION,

LV.ENABLED_FLAG,

LV.START_DATE_ACTIVE,

LV.END_DATE_ACTIVE,

LVT.CREATED_BY,

LVT.CREATION_DATE,

LVT.LAST_UPDATED_BY,

LVT.LAST_UPDATE_DATE,

LVT.LAST_UPDATE_LOGIN,

LVT.SOURCE_LANG,

LV.VIEW_APPLICATION_ID,

LV.TERRITORY_CODE,

LV.ATTRIBUTE_CATEGORY,

LV.ATTRIBUTE1,

LV.ATTRIBUTE2,

LV.ATTRIBUTE3,

LV.ATTRIBUTE4,

LV.ATTRIBUTE5,

LV.ATTRIBUTE6,

LV.ATTRIBUTE7,

LV.ATTRIBUTE8,

LV.ATTRIBUTE9,

LV.ATTRIBUTE10,

LV.ATTRIBUTE11,

LV.ATTRIBUTE12,

LV.ATTRIBUTE13,

LV.ATTRIBUTE14,

LV.ATTRIBUTE15,

LV.TAG,

LV.SET_ID,

LV.DISPLAY_SEQUENCE

From FND_LOOKUP_VALUES_B LV, FND_LOOKUP_VALUES_TL LVT

WHERE

LV.LOOKUP_TYPE=LVT.LOOKUP_TYPE

AND LV.LOOKUP_CODE=LVT.LOOKUP_CODE

AND LV.VIEW_APPLICATION_ID=LVT.VIEW_APPLICATION_ID

AND LV.SET_ID=LVT.SET_ID

AND LVT.LANGUAGE = userenv('LANG')

AND LV.VIEW_APPLICATION_ID = 0

AND LV.SET_ID = 0