[Home] [Help]
View: 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
Name |
ID |
QUOTE_LINE_TYPE_CODE |
INVOICABLE_YN |
OBJECT_VERSION_NUMBER |
STY_ID |
STY_NAME |
STY_DESCRIPTION |
STY_BILLABLE_YN |
STY_TAXABLE_DEFAULT_YN |
FND_LOOKUP_CODE |
QUOTE_LINE_TYPE_MEANING |
ORG_ID |