1. Tables and Views for Project Management
  2. GMS_LOOKUPS

GMS_LOOKUPS

Details

  • Schema: FUSION

  • Object owner: GMS

  • Object type: VIEW

Columns

Name

LOOKUP_TYPE

LOOKUP_CODE

MEANING

DESCRIPTION

ENABLED_FLAG

START_DATE_ACTIVE

END_DATE_ACTIVE

TAG

DISPLAY_SEQUENCE

Query

SQL_Statement

SELECT

FLT.LOOKUP_TYPE,

FLV.LOOKUP_CODE,

FLV.MEANING,

FLV.DESCRIPTION,

FLV.ENABLED_FLAG,

FLV.START_DATE_ACTIVE,

FLV.END_DATE_ACTIVE,

FLV.TAG,

FLV.DISPLAY_SEQUENCE

FROM

FND_LOOKUP_VALUES_VL FLV,

FND_LOOKUP_TYPES_VL FLT

WHERE FLV.SET_ID = 0

AND FLT.VIEW_APPLICATION_ID = FLV.VIEW_APPLICATION_ID

AND FLT.MODULE_ID = 'AF87AE8073384B61E0401490D3C564EB'

AND FLT.LOOKUP_TYPE = FLV.LOOKUP_TYPE