[Home] [Help]
View: OKL_H_AM_QUOTES_UV
View Text
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'
Columns
Name |
QUOTE_TYPE |
QUOTE_TYPE_DESCRIPTION |