[Home] [Help]
View: OKL_QUOTE_AMT_SMRY_ALL_UV
Product: | OKL - Leasing and Finance Management |
Description: | View gives Amount Summary for Quote in all Operating Units. |
Implementation/DBA Data: |
APPS.OKL_QUOTE_AMT_SMRY_ALL_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_ALL_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 <> 'AMCFIA' 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
, 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_ALL_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 (+)
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
Name |
QUOTE_NUMBER |
QLT_CODE |
QTE_ID |
MEANING |
FULL_DESCRIPTION |
AMOUNT |
QST_CODE |
QTP_CODE |
TOTAL_ASSET_VALUE |
TOTAL_RESIDUAL_VALUE |
TOTAL_UNBILLED_RECEIVABLES |
GAIN_LOSS |