VIEW: APPS.IGI_CIS_AWT_TAX_RATES

Source

View Text - Preformatted

SELECT aatr.TAX_RATE_ID, aatr.TAX_NAME, aatr.TAX_RATE, aatr. RATE_TYPE, aatr.START_DATE, aatr.END_DATE, aatr.START_AMOUNT, aatr.END_AMOUNT, aatr.LAST_UPDATE_DATE, aatr. LAST_UPDATED_BY, aatr.LAST_UPDATE_LOGIN, aatr. CREATION_DATE, aatr. CREATED_BY, aatr.VENDOR_ID, aatr. VENDOR_SITE_ID, aatr. INVOICE_NUM, aatr.CERTIFICATE_NUMBER, aatr.CERTIFICATE_TYPE, aatr. COMMENTS, PRIORITY, aatr. ATTRIBUTE_CATEGORY, aatr.ATTRIBUTE1, aatr. ATTRIBUTE2, aatr.ATTRIBUTE3, aatr. ATTRIBUTE4, aatr. ATTRIBUTE5, aatr. ATTRIBUTE6, aatr.ATTRIBUTE7, aatr. ATTRIBUTE8, aatr.ATTRIBUTE9, aatr. ATTRIBUTE10, aatr.ATTRIBUTE11, aatr.ATTRIBUTE12, aatr. ATTRIBUTE13, aatr. ATTRIBUTE14, aatr.ATTRIBUTE15, aatr.ORG_ID, aatr. GLOBAL_ATTRIBUTE_CATEGORY, aatr. GLOBAL_ATTRIBUTE1, aatr.GLOBAL_ATTRIBUTE2, aatr. GLOBAL_ATTRIBUTE3, aatr.GLOBAL_ATTRIBUTE4, aatr.GLOBAL_ATTRIBUTE5, aatr.GLOBAL_ATTRIBUTE6, aatr.GLOBAL_ATTRIBUTE7, aatr.GLOBAL_ATTRIBUTE8, aatr. GLOBAL_ATTRIBUTE9, aatr. GLOBAL_ATTRIBUTE10, aatr.GLOBAL_ATTRIBUTE11, aatr. GLOBAL_ATTRIBUTE12, aatr.GLOBAL_ATTRIBUTE13, aatr.GLOBAL_ATTRIBUTE14, aatr. GLOBAL_ATTRIBUTE15, aatr.GLOBAL_ATTRIBUTE16, aatr.GLOBAL_ATTRIBUTE17, aatr.GLOBAL_ATTRIBUTE18, aatr. GLOBAL_ATTRIBUTE19, aatr. GLOBAL_ATTRIBUTE20, ICCNN.ROW_ID, ICCNN.NI_NUMBER FROM AP_AWT_TAX_RATES AATR,IGI_CIS_CERT_NI_NUMBERS ICCNN WHERE aatr.tax_rate_id = iccnn.tax_rate_id (+)

View Text - HTML Formatted

SELECT AATR.TAX_RATE_ID
, AATR.TAX_NAME
, AATR.TAX_RATE
, AATR. RATE_TYPE
, AATR.START_DATE
, AATR.END_DATE
, AATR.START_AMOUNT
, AATR.END_AMOUNT
, AATR.LAST_UPDATE_DATE
, AATR. LAST_UPDATED_BY
, AATR.LAST_UPDATE_LOGIN
, AATR. CREATION_DATE
, AATR. CREATED_BY
, AATR.VENDOR_ID
, AATR. VENDOR_SITE_ID
, AATR. INVOICE_NUM
, AATR.CERTIFICATE_NUMBER
, AATR.CERTIFICATE_TYPE
, AATR. COMMENTS
, PRIORITY
, AATR. ATTRIBUTE_CATEGORY
, AATR.ATTRIBUTE1
, AATR. ATTRIBUTE2
, AATR.ATTRIBUTE3
, AATR. ATTRIBUTE4
, AATR. ATTRIBUTE5
, AATR. ATTRIBUTE6
, AATR.ATTRIBUTE7
, AATR. ATTRIBUTE8
, AATR.ATTRIBUTE9
, AATR. ATTRIBUTE10
, AATR.ATTRIBUTE11
, AATR.ATTRIBUTE12
, AATR. ATTRIBUTE13
, AATR. ATTRIBUTE14
, AATR.ATTRIBUTE15
, AATR.ORG_ID
, AATR. GLOBAL_ATTRIBUTE_CATEGORY
, AATR. GLOBAL_ATTRIBUTE1
, AATR.GLOBAL_ATTRIBUTE2
, AATR. GLOBAL_ATTRIBUTE3
, AATR.GLOBAL_ATTRIBUTE4
, AATR.GLOBAL_ATTRIBUTE5
, AATR.GLOBAL_ATTRIBUTE6
, AATR.GLOBAL_ATTRIBUTE7
, AATR.GLOBAL_ATTRIBUTE8
, AATR. GLOBAL_ATTRIBUTE9
, AATR. GLOBAL_ATTRIBUTE10
, AATR.GLOBAL_ATTRIBUTE11
, AATR. GLOBAL_ATTRIBUTE12
, AATR.GLOBAL_ATTRIBUTE13
, AATR.GLOBAL_ATTRIBUTE14
, AATR. GLOBAL_ATTRIBUTE15
, AATR.GLOBAL_ATTRIBUTE16
, AATR.GLOBAL_ATTRIBUTE17
, AATR.GLOBAL_ATTRIBUTE18
, AATR. GLOBAL_ATTRIBUTE19
, AATR. GLOBAL_ATTRIBUTE20
, ICCNN.ROW_ID
, ICCNN.NI_NUMBER
FROM AP_AWT_TAX_RATES AATR
, IGI_CIS_CERT_NI_NUMBERS ICCNN
WHERE AATR.TAX_RATE_ID = ICCNN.TAX_RATE_ID (+)