SELECT 'BS:' || LOOKUP_CODE CODE , LANGUAGE , MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'POS_SUPP_PROF_EXT_BASE' AND VIEW_APPLICATION_ID = 0 AND LANGUAGE = USERENV('LANG') UNION ALL SELECT 'ST:' || LOOKUP_CODE CODE , LANGUAGE , MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'VENDOR TYPE' AND VIEW_APPLICATION_ID = 201 AND LANGUAGE = USERENV('LANG') UNION ALL SELECT 'BC:' || LOOKUP_CODE CODE , LANGUAGE , MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'POS_BUSINESS_CLASSIFICATIONS' AND VIEW_APPLICATION_ID = 0 AND LANGUAGE = USERENV('LANG') UNION ALL SELECT 'HZ:' || FND.LOOKUP_TYPE || ':' || FND.LOOKUP_CODE CODE , FND.LANGUAGE , FND.MEANING FROM FND_LOOKUP_VALUES FND , HZ_CLASS_CATEGORIES HZ WHERE FND.VIEW_APPLICATION_ID = 222 AND FND.LOOKUP_TYPE = HZ.CLASS_CATEGORY AND FND.LANGUAGE = USERENV('LANG') UNION ALL SELECT 'AC:' || TERRITORY_CODE CODE , LANGUAGE , TERRITORY_SHORT_NAME MEANING FROM FND_TERRITORIES_TL WHERE LANGUAGE = USERENV('LANG') UNION ALL SELECT 'AP:PAY' CODE , LANGUAGE_CODE LANGUAGE , MESSAGE_TEXT MEANING FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = 'POS_PAY_NEW' AND LANGUAGE_CODE = USERENV('LANG') AND APPLICATION_ID = 177 UNION ALL SELECT 'AP:PURCHASING' CODE , LANGUAGE_CODE LANGUAGE , MESSAGE_TEXT MEANING FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = 'POS_HT_B_PURCHASING' AND LANGUAGE_CODE = USERENV('LANG') AND APPLICATION_ID = 177 UNION ALL SELECT 'AP:RFQ' CODE , LANGUAGE_CODE LANGUAGE , MESSAGE_TEXT MEANING FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = 'PON_AUC_NEG_R' AND LANGUAGE_CODE = USERENV('LANG') AND APPLICATION_ID = 396 UNION ALL SELECT 'AP:PCARD' CODE , LANGUAGE_CODE LANGUAGE , MESSAGE_TEXT MEANING FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = 'PON_AUCTS_PAY_PROC_CARD' AND LANGUAGE_CODE = USERENV('LANG') AND APPLICATION_ID = 396 UNION ALL SELECT 'AP:PRIMARY_PAY' CODE , LANGUAGE_CODE LANGUAGE , MESSAGE_TEXT MEANING FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = 'POS_PRIMARY_PAY' AND APPLICATION_ID = 177 UNION ALL SELECT 'PS:'||CODE , USERENV('LANG') LANGUAGE , MEANING FROM TABLE(POS_PRODUCT_SERVICE_UTL_PKG.PRODUCT_SERVICE_OCV)