VIEW: APPS.OKL_QUOTE_AMT_SMRY_ALL_UV

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'