SELECT 'ALL' ALL_FK , LOOKUP_CODE CUSTOMER_CATEGORY_CODE , MEANING CUSTOMER_CATEGORY_NAME , DESCRIPTION CUSTOMER_CATEGORY_DESC FROM AR_LOOKUPS WHERE LOOKUP_TYPE = 'CUSTOMER_CATEGORY' AND ENABLED_FLAG = 'Y' UNION ALL SELECT 'ALL' ALL_FK , MEANING CUSTOMER_CATEGORY_CODE , MEANING CUSTOMER_CATEGORY_NAME , DESCRIPTION CUSTOMER_CATEGORY_DESC FROM FND_LOOKUPS FL WHERE FL.LOOKUP_TYPE = 'BIC_VALUE_TYPE' AND FL.LOOKUP_CODE = '-999' WITH READ ONLY