VIEW: APPS.OKL_QUOTE_AMOUNTS_ALL_UV

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'