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

ZCA_LOOKUPS

Details

  • Schema: FUSION

  • Object owner: ZCA

  • Object type: VIEW

Columns

Name

LOOKUP_TYPE

LOOKUP_CODE

SET_ID

MEANING

DESCRIPTION

Query

SQL_Statement

SELECT

LOOKUP_TYPE,

LOOKUP_CODE,

SET_ID,

MEANING,

DESCRIPTION

FROM FND_LOOKUP_VALUES_VL

WHERE VIEW_APPLICATION_ID = 10054

AND SET_ID = 0

AND ENABLED_FLAG = 'Y'

AND sysdate BETWEEN nvl(START_DATE_ACTIVE,sysdate-1) AND nvl(END_DATE_ACTIVE,sysdate+1)