VIEW: APPS.IEC_LIST_STATUSES_V

Source

View Text - Preformatted

SELECT LOOKUP_CODE, MEANING FROM ( (SELECT LOOKUP_CODE, MEANING FROM IEC_LOOKUPS WHERE LOOKUP_TYPE = 'IEC_LIST_STATUS' AND START_DATE_ACTIVE <= SYSDATE AND (END_DATE_ACTIVE IS NULL OR END_DATE_ACTIVE > SYSDATE)) UNION (SELECT LOOKUP_CODE, MEANING FROM AMS_LOOKUPS WHERE LOOKUP_TYPE = 'AMS_LIST_STATUS' AND LOOKUP_CODE NOT IN ('LOCKED', 'EXECUTING') AND START_DATE_ACTIVE <= SYSDATE AND (END_DATE_ACTIVE IS NULL OR END_DATE_ACTIVE > SYSDATE)) )

View Text - HTML Formatted

SELECT LOOKUP_CODE
, MEANING
FROM ( (SELECT LOOKUP_CODE
, MEANING
FROM IEC_LOOKUPS
WHERE LOOKUP_TYPE = 'IEC_LIST_STATUS'
AND START_DATE_ACTIVE <= SYSDATE
AND (END_DATE_ACTIVE IS NULL OR END_DATE_ACTIVE > SYSDATE)) UNION (SELECT LOOKUP_CODE
, MEANING
FROM AMS_LOOKUPS
WHERE LOOKUP_TYPE = 'AMS_LIST_STATUS'
AND LOOKUP_CODE NOT IN ('LOCKED'
, 'EXECUTING')
AND START_DATE_ACTIVE <= SYSDATE
AND (END_DATE_ACTIVE IS NULL OR END_DATE_ACTIVE > SYSDATE)) )