eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AP.AP_WHT_ITF

Object Details

Object Name:	AP_WHT_ITF
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_WHT_ITF
Subobject Name:
Status:	VALID

This is an interface table that stores all the records for the submission of the AP Withholding Tax extract program for the AP Withholding Tax Report functionality. AP_WHT_ITF is a denormalized table used for storing the Organization Name and Address, Supplier and Supplier site identifications,
Invoice information and invoice distributions for withholding tax. Each row in this table corresponds to an invoice distribution for withholding tax matching the user parameters specified while running the AP Withholding Tax Extract program. This information can then be published by using RXi or standard reports.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_ID	NUMBER	(15)	Yes	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
ORGANIZATION_NAME	VARCHAR2	(240)	Yes	Name of the organization
FUNCTIONAL_CURRENCY_CODE	VARCHAR2	(15)	Yes	Functional currency code
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ADDRESS_LINE1	VARCHAR2	(240)		Address line 1
ADDRESS_LINE2	VARCHAR2	(240)		Address line 2
ADDRESS_LINE3	VARCHAR2	(240)		Address line 3
CITY	VARCHAR2	(30)		City
ZIP	VARCHAR2	(30)		Zip
PROVINCE	VARCHAR2	(150)		Province
STATE	VARCHAR2	(150)		State
COUNTRY	VARCHAR2	(60)		Country
TAX_AUTHORITY	VARCHAR2	(80)	Yes	Tax Authority Name
SUPPLIER_TYPE	VARCHAR2	(25)		Supplier Type
SUPPLIER_NAME	VARCHAR2	(240)	Yes	Supplier Name
TAXPAYER_ID	VARCHAR2	(30)		Tax Payer Id
SUPPLIER_NUMBER	VARCHAR2	(30)	Yes	Supplier's Number (Internal)
SUPPLIER_SITE_CODE	VARCHAR2	(15)	Yes	Supplier Site Code
VAT_REGISTRATION_NUMBER	VARCHAR2	(20)		Supplier's VAT Registration Number
SUPPLIER_ADDRESS_LINE1	VARCHAR2	(240)		Supplier's address line 1
SUPPLIER_ADDRESS_LINE2	VARCHAR2	(240)		Supplier's address line 2
SUPPLIER_ADDRESS_LINE3	VARCHAR2	(240)		Supplier's address line 3
SUPPLIER_CITY	VARCHAR2	(25)		Supplier's city
SUPPLIER_STATE	VARCHAR2	(150)		Supplier's state
SUPPLIER_ZIP	VARCHAR2	(20)		Supplier's zip
SUPPLIER_PROVINCE	VARCHAR2	(150)		Supplier's province
SUPPLIER_COUNTRY	VARCHAR2	(25)		Supplier's country
INVOICE_NUM	VARCHAR2	(50)	Yes	Invoice number
INVOICE_AMOUNT	NUMBER		Yes	Invoice amount
INVOICE_CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency of the Invoice
INVOICE_DATE	DATE		Yes	Invoice Date
INV_GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		AP_INVOICES Global Attribute1
INV_GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		AP_INVOICES Global Attribute2
INV_GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		AP_INVOICES Global Attribute3
INV_GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		AP_INVOICES Global Attribute4
INV_GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		AP_INVOICES Global Attribute5
INV_GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		AP_INVOICES Global Attribute6
INV_GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		AP_INVOICES Global Attribute7
INV_GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		AP_INVOICES Global Attribute8
INV_GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		AP_INVOICES Global Attribute9
INV_GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		AP_INVOICES Global Attribute10
INV_GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		AP_INVOICES Global Attribute11
INV_GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		AP_INVOICES Global Attribute12
INV_GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		AP_INVOICES Global Attribute13
INV_GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		AP_INVOICES Global Attribute14
INV_GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		AP_INVOICES Global Attribute15
INV_GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		AP_INVOICES Global Attribute16
INV_GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		AP_INVOICES Global Attribute17
INV_GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		AP_INVOICES Global Attribute18
INV_GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		AP_INVOICES Global Attribute19
INV_GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		AP_INVOICES Global Attribute20
PV_GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		PO_VENDORS Global Attribute1
PV_GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		PO_VENDORS Global Attribute2
PV_GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		PO_VENDORS Global Attribute3
PV_GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		PO_VENDORS Global Attribute4
PV_GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		PO_VENDORS Global Attribute5
PV_GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		PO_VENDORS Global Attribute6
PV_GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		PO_VENDORS Global Attribute7
PV_GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		PO_VENDORS Global Attribute8
PV_GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		PO_VENDORS Global Attribute9
PV_GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		PO_VENDORS Global Attribute10
PV_GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		PO_VENDORS Global Attribute11
PV_GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		PO_VENDORS Global Attribute12
PV_GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		PO_VENDORS Global Attribute13
PV_GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		PO_VENDORS Global Attribute14
PV_GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		PO_VENDORS Global Attribute15
PV_GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		PO_VENDORS Global Attribute16
PV_GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		PO_VENDORS Global Attribute17
PV_GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		PO_VENDORS Global Attribute18
PV_GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		PO_VENDORS Global Attribute19
PV_GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		PO_VENDORS Global Attribute20
AWT_CODE	VARCHAR2	(15)	Yes	Withholding Tax Code
AWT_RATE	NUMBER		Yes	Withholding Tax Rate
AWT_AMOUNT	NUMBER		Yes	Amount withheld
AWT_BASE_AMOUNT	NUMBER		Yes	Base amount withheld
AWT_GROUP_NAME	VARCHAR2	(25)		Withholding tax group name
AWT_GL_DATE	DATE		Yes	GL date of withholding
AWT_GROSS_AMOUNT	NUMBER			Amount subject to withholding tax

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REQUEST_ID
,      ORGANIZATION_NAME
,      FUNCTIONAL_CURRENCY_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      CITY
,      ZIP
,      PROVINCE
,      STATE
,      COUNTRY
,      TAX_AUTHORITY
,      SUPPLIER_TYPE
,      SUPPLIER_NAME
,      TAXPAYER_ID
,      SUPPLIER_NUMBER
,      SUPPLIER_SITE_CODE
,      VAT_REGISTRATION_NUMBER
,      SUPPLIER_ADDRESS_LINE1
,      SUPPLIER_ADDRESS_LINE2
,      SUPPLIER_ADDRESS_LINE3
,      SUPPLIER_CITY
,      SUPPLIER_STATE
,      SUPPLIER_ZIP
,      SUPPLIER_PROVINCE
,      SUPPLIER_COUNTRY
,      INVOICE_NUM
,      INVOICE_AMOUNT
,      INVOICE_CURRENCY_CODE
,      INVOICE_DATE
,      INV_GLOBAL_ATTRIBUTE1
,      INV_GLOBAL_ATTRIBUTE2
,      INV_GLOBAL_ATTRIBUTE3
,      INV_GLOBAL_ATTRIBUTE4
,      INV_GLOBAL_ATTRIBUTE5
,      INV_GLOBAL_ATTRIBUTE6
,      INV_GLOBAL_ATTRIBUTE7
,      INV_GLOBAL_ATTRIBUTE8
,      INV_GLOBAL_ATTRIBUTE9
,      INV_GLOBAL_ATTRIBUTE10
,      INV_GLOBAL_ATTRIBUTE11
,      INV_GLOBAL_ATTRIBUTE12
,      INV_GLOBAL_ATTRIBUTE13
,      INV_GLOBAL_ATTRIBUTE14
,      INV_GLOBAL_ATTRIBUTE15
,      INV_GLOBAL_ATTRIBUTE16
,      INV_GLOBAL_ATTRIBUTE17
,      INV_GLOBAL_ATTRIBUTE18
,      INV_GLOBAL_ATTRIBUTE19
,      INV_GLOBAL_ATTRIBUTE20
,      PV_GLOBAL_ATTRIBUTE1
,      PV_GLOBAL_ATTRIBUTE2
,      PV_GLOBAL_ATTRIBUTE3
,      PV_GLOBAL_ATTRIBUTE4
,      PV_GLOBAL_ATTRIBUTE5
,      PV_GLOBAL_ATTRIBUTE6
,      PV_GLOBAL_ATTRIBUTE7
,      PV_GLOBAL_ATTRIBUTE8
,      PV_GLOBAL_ATTRIBUTE9
,      PV_GLOBAL_ATTRIBUTE10
,      PV_GLOBAL_ATTRIBUTE11
,      PV_GLOBAL_ATTRIBUTE12
,      PV_GLOBAL_ATTRIBUTE13
,      PV_GLOBAL_ATTRIBUTE14
,      PV_GLOBAL_ATTRIBUTE15
,      PV_GLOBAL_ATTRIBUTE16
,      PV_GLOBAL_ATTRIBUTE17
,      PV_GLOBAL_ATTRIBUTE18
,      PV_GLOBAL_ATTRIBUTE19
,      PV_GLOBAL_ATTRIBUTE20
,      AWT_CODE
,      AWT_RATE
,      AWT_AMOUNT
,      AWT_BASE_AMOUNT
,      AWT_GROUP_NAME
,      AWT_GL_DATE
,      AWT_GROSS_AMOUNT
FROM AP.AP_WHT_ITF;

Dependencies

[top of page]

AP.AP_WHT_ITF does not reference any database object

AP.AP_WHT_ITF is referenced by following:

APPS: AP_WHT_ITF