VIEW: APPS.OKL_AM_QUOTE_AMOUNTS_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_B TQ,OKL_TXL_QUOTE_LINES_V OTQ,FND_LOOKUPS FND,OKC_K_LINES_V KLE,OKL_STRM_TYPE_V 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 = KLE.ID (+) AND OTQ.STY_ID = STY.ID (+) AND OTQ.QLT_CODE NOT IN ('AMCFIA','AMCTAX') UNION SELECT QTE.QUOTE_NUMBER, FND.MEANING, TXS.TRX_LINE_ID 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_B QTE ,FND_LOOKUPS FND ,OKC_K_LINES_V KLE ,OKL_STRM_TYPE_V STY , OKL_TAX_SOURCES TXS WHERE 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.TRX_ID = QTE.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 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_B TQ
, OKL_TXL_QUOTE_LINES_V OTQ
, FND_LOOKUPS FND
, OKC_K_LINES_V KLE
, OKL_STRM_TYPE_V 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 = KLE.ID (+)
AND OTQ.STY_ID = STY.ID (+)
AND OTQ.QLT_CODE NOT IN ('AMCFIA'
, 'AMCTAX') UNION SELECT QTE.QUOTE_NUMBER
, FND.MEANING
, TXS.TRX_LINE_ID 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_B QTE
, FND_LOOKUPS FND
, OKC_K_LINES_V KLE
, OKL_STRM_TYPE_V STY
, OKL_TAX_SOURCES TXS
WHERE 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.TRX_ID = QTE.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'