FND Design Data [Home] [Help]

View: AR_CUST_CATEGORIES_ACTIVE_V

Product: AR - Receivables
Description: (Release 10SC Only)
Implementation/DBA Data: ViewAPPS.AR_CUST_CATEGORIES_ACTIVE_V
View Text

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

Columns

Name
LOOKUP_CODE
MEANING
DESCRIPTION