VIEW: APPS.OKL_AM_QUOTE_AMT_SUMMARY_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_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

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_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