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

CN_LOOKUPS

Details

  • Schema: FUSION

  • Object owner: CN

  • Object type: VIEW

Columns

Name

ROW_ID

LOOKUP_TYPE

LOOKUP_CODE

MEANING

DESCRIPTION

ENABLED_FLAG

START_DATE_ACTIVE

END_DATE_ACTIVE

DISPLAY_SEQUENCE

Query

SQL_Statement

SELECT B.ROWID ROW_ID,

B.LOOKUP_TYPE,

B.LOOKUP_CODE,

T.MEANING,

T.DESCRIPTION,

B.ENABLED_FLAG,

B.START_DATE_ACTIVE,

B.END_DATE_ACTIVE,

B.DISPLAY_SEQUENCE

FROM FND_LOOKUP_VALUES_TL T,

FND_LOOKUP_VALUES_B B

WHERE T.LOOKUP_TYPE = B.LOOKUP_TYPE

AND T.LOOKUP_CODE = B.LOOKUP_CODE

AND T.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID

AND T.SET_ID = B.SET_ID

AND T.LANGUAGE = USERENV('LANG')

AND B.view_APPLICATION_ID=0

AND B.SET_ID = 0 WITH READ ONLY