SELECT LOOKUP_TYPE LOOKUP_TYPE, LOOKUP_CODE LOOKUP_CODE, MEANING MEANING FROM FND_LOOKUPS FLP WHERE LOOKUP_TYPE = 'CP_STATUS_CODE' AND LOOKUP_CODE NOT IN ('I', 'R', 'Z')
View Text - HTML Formatted
SELECT LOOKUP_TYPE LOOKUP_TYPE , LOOKUP_CODE LOOKUP_CODE , MEANING MEANING FROM FND_LOOKUPS FLP WHERE LOOKUP_TYPE = 'CP_STATUS_CODE' AND LOOKUP_CODE NOT IN ('I' , 'R' , 'Z')