VIEW: APPS.POS_SUPP_PROF_EXT_OCV

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)