View: OKL_AM_QUOTE_AMT_SUMMARY_UV

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

View Text

SELECT QTE.QUOTE_NUMBER QUOTE_NUMBER
, TQL.QLT_CODE QLT_CODE
, TQL.QTE_ID QTE_ID
, FND.MEANING MEANING
, FND.MEANING || NVL2 (STY.NAME
, ' - ' || STY.NAME
, NULL) FULL_DESCRIPTION
, SUM(TQL.AMOUNT) AMOUNT
, QTE.QST_CODE QST_CODE
, QTE.QTP_CODE QTP_CODE
, QTE.ASSET_VALUE TOTAL_ASSET_VALUE
, QTE.RESIDUAL_VALUE TOTAL_RESIDUAL_VALUE
, QTE.UNBILLED_RECEIVABLES TOTAL_UNBILLED_RECEIVABLES
, QTE.GAIN_LOSS GAIN_LOSS
FROM OKL_TRX_QUOTES_B QTE
, OKL_TXL_QTE_LINES_ALL_B TQL
, FND_LOOKUPS FND
, OKC_K_LINES_B KLE
, OKL_STRM_TYPE_V STY
WHERE TQL.QTE_ID = QTE.ID
AND FND.LOOKUP_TYPE='OKL_QUOTE_LINE_TYPE'
AND FND.LOOKUP_CODE = TQL.QLT_CODE
AND TQL.KLE_ID = KLE.ID (+)
AND TQL.STY_ID = STY.ID (+)
AND TQL.QLT_CODE NOT IN ('AMCFIA'
, 'AMCTAX') GROUP BY QUOTE_NUMBER
, QLT_CODE
, QTE_ID
, MEANING
, FND.MEANING || NVL2 (STY.NAME
, ' - ' || STY.NAME
, NULL)
, QST_CODE
, QTP_CODE
, QTE.ASSET_VALUE
, QTE.RESIDUAL_VALUE
, QTE.UNBILLED_RECEIVABLES
, QTE.GAIN_LOSS UNION SELECT QTE.QUOTE_NUMBER QUOTE_NUMBER
, 'AMCTAX' QLT_CODE
, QTE.ID QTE_ID
, FND.MEANING MEANING
, FND.MEANING ||NVL2(STY.NAME
, ' - ' ||STY.NAME
, NULL) FULL_DESCRIPTION
, SUM(TXS.TOTAL_TAX) AMOUNT
, QTE.QST_CODE QST_CODE
, QTE.QTP_CODE QTP_CODE
, QTE.ASSET_VALUE TOTAL_ASSET_VALUE
, QTE.RESIDUAL_VALUE TOTAL_RESIDUAL_VALUE
, QTE.UNBILLED_RECEIVABLES TOTAL_UNBILLED_RECEIVABLES
, QTE.GAIN_LOSS GAIN_LOSS
FROM OKL_TRX_QUOTES_B QTE
, OKL_TAX_SOURCES TXS
, FND_LOOKUPS FND
, OKC_K_LINES_B KLE
, OKL_STRM_TYPE_V STY
WHERE TXS.TRX_ID = QTE.ID
AND FND.LOOKUP_TYPE = 'OKL_QUOTE_LINE_TYPE'
AND FND.LOOKUP_CODE = 'AMCTAX'
AND TXS.KLE_ID = KLE.ID(+)
AND TXS.STY_ID = STY.ID (+) GROUP BY QTE.QUOTE_NUMBER
, QTE.ID
, FND.MEANING
, FND.MEANING ||NVL2(STY.NAME
, ' - ' ||STY.NAME
, NULL)
, QTE.QST_CODE
, QTE.QTP_CODE
, QTE.ASSET_VALUE
, QTE.RESIDUAL_VALUE
, QTE.UNBILLED_RECEIVABLES
, QTE.GAIN_LOSS

Columns