View: CSP_PART_CATEGORIES_V

Product:	CSP - Spares Management
Description:	Shows the spare part categories.
Implementation/DBA Data:	APPS.CSP_PART_CATEGORIES_V

View Text

SELECT FL1.MEANING
, TO_NUMBER(FL1.LOOKUP_CODE)
, LEAST(MIN(TO_NUMBER(FL2.LOOKUP_CODE))
, 100) FROM FND_LOOKUPS FL1
, FND_LOOKUPS FL2
WHERE FL1.LOOKUP_TYPE = 'CSP_PARTS_CATEGORY'
AND FL2.LOOKUP_TYPE = 'CSP_PARTS_CATEGORY'
AND LEAST(TO_NUMBER(FL2.LOOKUP_CODE)
, 100) > TO_NUMBER(FL1.LOOKUP_CODE)
AND FL1.ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(FL1.START_DATE_ACTIVE
, SYSDATE)
AND NVL(FL1.END_DATE_ACTIVE
, SYSDATE)
AND FL2.ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(FL2.START_DATE_ACTIVE
, SYSDATE)
AND NVL(FL2.END_DATE_ACTIVE
, SYSDATE) GROUP BY FL1.MEANING
, FL1.LOOKUP_CODE UNION SELECT FL.MEANING
, TO_NUMBER(FL.LOOKUP_CODE) LOW
, TO_NUMBER(FL.LOOKUP_CODE) HIGH
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'CSP_PARTS_CATEGORY'
AND TO_NUMBER(FL.LOOKUP_CODE) > 100
AND FL.ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(FL.START_DATE_ACTIVE
, SYSDATE)
AND NVL(FL.END_DATE_ACTIVE
, SYSDATE)

Columns