[Home] [Help]
VIEW: APPS.OKL_H_AM_QUOTES_UV
Source
View Text - Preformatted
SELECT OTQ.QTP_CODE QUOTE_TYPE, FL2.MEANING QUOTE_TYPE_DESCRIPTION FROM OKL_TRX_QUOTES_B OTQ,FND_LOOKUPS FL2 WHERE FL2.LOOKUP_TYPE = 'OKL_QUOTE_TYPE' AND FL2.LOOKUP_CODE = OTQ.QTP_CODE AND OTQ.CONSOLIDATED_YN = 'N'
View Text - HTML Formatted
SELECT OTQ.QTP_CODE QUOTE_TYPE
, FL2.MEANING QUOTE_TYPE_DESCRIPTION
FROM OKL_TRX_QUOTES_B OTQ
, FND_LOOKUPS FL2
WHERE FL2.LOOKUP_TYPE = 'OKL_QUOTE_TYPE'
AND FL2.LOOKUP_CODE = OTQ.QTP_CODE
AND OTQ.CONSOLIDATED_YN = 'N'