Product: | IGI - Public Sector Financials International |
---|---|
Description: | Displays CIS WIthholding Certificate records coupled with NI Number details. |
Implementation/DBA Data: | APPS.IGI_CIS_AWT_TAX_RATES |
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 (+)