View: POS_SUPP_PROF_EXT_OCV

Product:	POS - iSupplier Portal
Description:	Supplier Data Hub project. Supplier Profile Extension Classification View
Implementation/DBA Data:	APPS.POS_SUPP_PROF_EXT_OCV

View Text

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)

Columns