VIEW: APPS.IGS_CO_ADDR_TYPE

Source

View Text - Preformatted

SELECT LOOKUP_CODE ADDR_TYPE, MEANING DESCRIPTION, DECODE(ENABLED_FLAG, 'Y', 'N', 'N', 'Y') CLOSED_IND FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'PARTY_SITE_USE_CODE' AND LANGUAGE = USERENV('LANG') AND VIEW_APPLICATION_ID = 222 AND SECURITY_GROUP_ID = 0 ORDER BY 1

View Text - HTML Formatted

SELECT LOOKUP_CODE ADDR_TYPE
, MEANING DESCRIPTION
, DECODE(ENABLED_FLAG
, 'Y'
, 'N'
, 'N'
, 'Y') CLOSED_IND
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'PARTY_SITE_USE_CODE'
AND LANGUAGE = USERENV('LANG')
AND VIEW_APPLICATION_ID = 222
AND SECURITY_GROUP_ID = 0 ORDER BY 1