1. Tables and Views for Project Management
  2. PJB_LOOKUPS

PJB_LOOKUPS

Details

  • Schema: FUSION

  • Object owner: PJB

  • Object type: VIEW

Columns

Name

LOOKUP_TYPE

LOOKUP_CODE

MEANING

DESCRIPTION

ENABLED_FLAG

START_DATE_ACTIVE

END_DATE_ACTIVE

DISPLAY_SEQUENCE

TAG

Query

SQL_Statement

SELECT

flv.LOOKUP_TYPE,

flv.LOOKUP_CODE,

flv.MEANING,

flv.DESCRIPTION,

flv.ENABLED_FLAG,

flv.START_DATE_ACTIVE,

flv.END_DATE_ACTIVE,

flv.DISPLAY_SEQUENCE,

flv.TAG

FROM FND_LOOKUP_VALUES_VL FLV, FND_LOOKUP_TYPES FLT

WHERE FLV.LOOKUP_TYPE = FLT.LOOKUP_TYPE

AND FLV.VIEW_APPLICATION_ID = FLT.VIEW_APPLICATION_ID

AND FLT.MODULE_ID = '61ECAF4AAABAE990E040449821C61C97'

AND FLV.SET_ID = 0

AND FLV.VIEW_APPLICATION_ID = 0