View: OKL_AM_QUOTE_LINE_STRM_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_AM_QUOTE_LINE_STRM_UV

View Text

SELECT QLSB.ID ID
, QLSB.QUOTE_LINE_TYPE_CODE QUOTE_LINE_TYPE_CODE
, QLSB.INVOICABLE_YN INVOICABLE_YN
, QLSB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, QLSB.STY_ID STY_ID
, STY.NAME STY_NAME
, STY.DESCRIPTION STY_DESCRIPTION
, STY.BILLABLE_YN STY_BILLABLE_YN
, STY.TAXABLE_DEFAULT_YN STY_TAXABLE_DEFAULT_YN
, FND.LOOKUP_CODE FND_LOOKUP_CODE
, FND.MEANING QUOTE_LINE_TYPE_MEANING
, QLSB.ORG_ID ORG_ID
FROM OKL_QUOTE_LINE_STRM QLSB
, FND_LOOKUPS FND
, OKL_STRM_TYPE_V STY
WHERE QLSB.QUOTE_LINE_TYPE_CODE(+) = FND.LOOKUP_CODE
AND FND.LOOKUP_TYPE = 'OKL_QUOTE_LINE_TYPE'
AND QLSB.STY_ID = STY.ID(+)

Columns