View: IGS_CO_ADDR_TYPE

Product:	IGS - Student System
Description:
Implementation/DBA Data:	APPS.IGS_CO_ADDR_TYPE

View Text

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

Columns