View: AR_ADDR_CATEGORIES_ACTIVE_V

Product:	AR - Receivables
Description:	Information about active address categories
Implementation/DBA Data:	APPS.AR_ADDR_CATEGORIES_ACTIVE_V

View Text

SELECT ARLKP.LOOKUP_CODE
, ARLKP.MEANING
, ARLKP.DESCRIPTION
FROM AR_LOOKUPS ARLKP
WHERE LOOKUP_TYPE = 'ADDRESS_CATEGORY'
AND ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN TRUNC(START_DATE_ACTIVE)
AND NVL(TRUNC(END_DATE_ACTIVE)
, SYSDATE)

Columns