SELECT LOOKUP_CODE ,MEANING FROM FND_LOOKUP_VALUES WHERE ( (LOOKUP_TYPE = 'FIELD_TYPE' AND LOOKUP_CODE IN ('Y', 'X','N', 'C')) OR (LOOKUP_TYPE = 'EGO_FIELD_TYPE' AND LOOKUP_CODE IN ('A')) ) AND VIEW_APPLICATION_ID = 0 AND LANGUAGE = USERENV('LANG')
SELECT LOOKUP_CODE
, MEANING
FROM FND_LOOKUP_VALUES
WHERE ( (LOOKUP_TYPE = 'FIELD_TYPE'
AND LOOKUP_CODE IN ('Y'
, 'X'
, 'N'
, 'C')) OR (LOOKUP_TYPE = 'EGO_FIELD_TYPE'
AND LOOKUP_CODE IN ('A')) )
AND VIEW_APPLICATION_ID = 0
AND LANGUAGE = USERENV('LANG')
|
|
|