1. Tables and Views for Project Management
  2. PJC_LOOKUPS

PJC_LOOKUPS

Details

  • Schema: FUSION

  • Object owner: PJC

  • Object type: VIEW

Columns

Name

LOOKUP_TYPE

LOOKUP_CODE

MEANING

DESCRIPTION

ENABLED_FLAG

DISPLAY_SEQUENCE

START_DATE_ACTIVE

END_DATE_ACTIVE

Query

SQL_Statement

SELECT

flv.LOOKUP_TYPE ,

flv.LOOKUP_CODE ,

flv.MEANING ,

flv.DESCRIPTION ,

flv.ENABLED_FLAG ,

flv.DISPLAY_SEQUENCE,

flv.START_DATE_ACTIVE,

flv.END_DATE_ACTIVE

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 = '61ECAF4AAABBE990E040449821C61C97'

AND FLV.SET_ID = 0

AND FLV.VIEW_APPLICATION_ID = 0