View: OKL_QUOTE_AMOUNTS_ALL_UV

Product:	OKL - Lease and Finance Management
Description:	View gives Quote Amounts for all Operating Units.
Implementation/DBA Data:	APPS.OKL_QUOTE_AMOUNTS_ALL_UV

View Text

SELECT TQ.QUOTE_NUMBER
, FND.MEANING
, OTQ.ID
, OTQ.OBJECT_VERSION_NUMBER
, OTQ.SFWT_FLAG
, OTQ.QLT_CODE
, OTQ.KLE_ID
, KLE.NAME KLE_NAME
, OTQ.STY_ID
, STY.NAME STREAM_TYPE_NAME
, STY.DESCRIPTION STREAM_TYPE_DESCRIPTION
, OTQ.QTE_ID
, OTQ.LINE_NUMBER
, OTQ.DESCRIPTION
, FND.MEANING || NVL2 (STY.NAME
, ' - ' || STY.NAME
, NULL) FULL_DESCRIPTION
, OTQ.AMOUNT
, OTQ.MODIFIED_YN
, OTQ.TAXED_YN
, OTQ.DEFAULTED_YN
, OTQ.ATTRIBUTE_CATEGORY
, OTQ.ATTRIBUTE1
, OTQ.ATTRIBUTE2
, OTQ.ATTRIBUTE3
, OTQ.ATTRIBUTE4
, OTQ.ATTRIBUTE5
, OTQ.ATTRIBUTE6
, OTQ.ATTRIBUTE7
, OTQ.ATTRIBUTE8
, OTQ.ATTRIBUTE9
, OTQ.ATTRIBUTE10
, OTQ.ATTRIBUTE11
, OTQ.ATTRIBUTE12
, OTQ.ATTRIBUTE13
, OTQ.ATTRIBUTE14
, OTQ.ATTRIBUTE15
, OTQ.ORG_ID
, OTQ.REQUEST_ID
, OTQ.PROGRAM_APPLICATION_ID
, OTQ.PROGRAM_ID
, OTQ.PROGRAM_UPDATE_DATE
, OTQ.CREATED_BY
, OTQ.CREATION_DATE
, OTQ.LAST_UPDATED_BY
, OTQ.LAST_UPDATE_DATE
, OTQ.LAST_UPDATE_LOGIN
, TQ.ACCEPTED_YN ACCEPTED_YN
, OTQ.ASSET_VALUE
, OTQ.RESIDUAL_VALUE
, OTQ.UNBILLED_RECEIVABLES
, OTQ.ASSET_QUANTITY
, OTQ.QUOTE_QUANTITY
, OTQ.SPLIT_KLE_ID
, TQ.ASSET_VALUE
, TQ.RESIDUAL_VALUE
, TQ.UNBILLED_RECEIVABLES
, TQ.GAIN_LOSS
, TQ.QST_CODE
, TQ.QTP_CODE
, OTQ.DUE_DATE
, TQ.PERDIEM_AMOUNT
FROM OKL_TRX_QUOTES_ALL_B TQ
, OKL_TXL_QTE_LINES_ALL_V OTQ
, FND_LOOKUPS FND
, OKC_K_LINES_B KLEB
, OKC_K_LINES_TL KLE
, OKL_STRM_TYPE_B STYB
, OKL_STRM_TYPE_TL STY
WHERE OTQ.QTE_ID = TQ.ID
AND FND.LOOKUP_TYPE='OKL_QUOTE_LINE_TYPE'
AND FND.LOOKUP_CODE = OTQ.QLT_CODE
AND OTQ.KLE_ID = KLEB.ID (+)
AND OTQ.STY_ID = STYB.ID (+)
AND OTQ.QLT_CODE NOT IN ('AMCFIA'
, 'AMCTAX')
AND KLEB.ID = KLE.ID (+)
AND KLE.LANGUAGE (+) = USERENV('LANG')
AND STYB.ID = STY.ID (+)
AND STY.LANGUAGE (+) = USERENV('LANG') UNION SELECT QTE.QUOTE_NUMBER
, FND.MEANING
, TXS.TRX_LINE_ID
, NULL OBJECT_VERSION_NUMBER
, NULL SFWT_FLAG
, 'AMCTAX' QLT_CODE
, TXS.KLE_ID
, KLE.NAME KLE_NAME
, TXS.STY_ID
, STY.NAME STREAM_TYPE_NAME
, STY.DESCRIPTION STREAM_TYPE_DESCRIPTION
, QTE.ID QTE_ID
, NULL LINE_NUMBER
, NULL DESCRIPTION
, FND.MEANING || NVL2 (STY.NAME
, ' - ' || STY.NAME
, NULL) FULL_DESCRIPTION
, TXS.TOTAL_TAX AMOUNT
, NULL MODIFIED_YN
, NULL TAXED_YN
, NULL DEFAULTED_YN
, NULL ATTRIBUTE_CATEGORY
, NULL ATTRIBUTE1
, NULL ATTRIBUTE2
, NULL ATTRIBUTE3
, NULL ATTRIBUTE4
, NULL ATTRIBUTE5
, NULL ATTRIBUTE6
, NULL ATTRIBUTE7
, NULL ATTRIBUTE8
, NULL ATTRIBUTE9
, NULL ATTRIBUTE10
, NULL ATTRIBUTE11
, NULL ATTRIBUTE12
, NULL ATTRIBUTE13
, NULL ATTRIBUTE14
, NULL ATTRIBUTE15
, QTE.ORG_ID
, NULL REQUEST_ID
, NULL PROGRAM_APPLICATION_ID
, NULL PROGRAM_ID
, NULL PROGRAM_UPDATE_DATE
, NULL CREATED_BY
, NULL CREATION_DATE
, NULL LAST_UPDATED_BY
, NULL LAST_UPDATE_DATE
, NULL LAST_UPDATE_LOGIN
, QTE.ACCEPTED_YN ACCEPTED_YN
, NULL ASSET_VALUE
, NULL RESIDUAL_VALUE
, NULL UNBILLED_RECEIVABLES
, NULL ASSET_QUANTITY
, NULL QUOTE_QUANTITY
, NULL SPLIT_KLE_ID
, QTE.ASSET_VALUE
, QTE.RESIDUAL_VALUE
, QTE.UNBILLED_RECEIVABLES
, QTE.GAIN_LOSS
, QTE.QST_CODE
, QTE.QTP_CODE
, NULL DUE_DATE
, QTE.PERDIEM_AMOUNT
FROM OKL_TRX_QUOTES_ALL_B QTE
, FND_LOOKUPS FND
, OKC_K_LINES_B KLEB
, OKC_K_LINES_TL KLE
, OKL_STRM_TYPE_B STYB
, OKL_STRM_TYPE_TL STY
, OKL_TAX_SOURCES TXS
WHERE FND.LOOKUP_TYPE='OKL_QUOTE_LINE_TYPE'
AND FND.LOOKUP_CODE = 'AMCTAX'
AND TXS.KLE_ID = KLEB.ID (+)
AND TXS.STY_ID = STYB.ID (+)
AND TXS.TRX_ID = QTE.ID
AND KLEB.ID = KLE.ID (+)
AND KLE.LANGUAGE (+) = USERENV('LANG')
AND STYB.ID = STY.ID (+)
AND STY.LANGUAGE (+) = USERENV('LANG')
AND TXS.TAX_LINE_STATUS_CODE = 'ACTIVE'
AND TXS.TAX_CALL_TYPE_CODE = 'INVOICE_TAX'
AND TXS.ENTITY_CODE = 'AM_QUOTES'
AND TXS.APPLICATION_ID = 540
AND TXS.EVENT_CLASS_CODE = 'ESTIMATED_BILLING'
AND TXS.TRX_LEVEL_TYPE = 'LINE'

Columns