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_AWT_TEMP_DISTRIBUTIONS_ALL

Object Details

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

AP_AWT_TEMP_DISTRIBUTIONS_ALL contains temporary
withholding tax type invoice distributions for projected withholding
tax or unconfirmed payment batches.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_AWT_TEMP_DISTRIBUTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	INVOICE_ID PAYMENT_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
INVOICE_ID	NUMBER	(15)	Yes	Unique invoice identifier
PAYMENT_NUM	NUMBER	(15)		Payment number
GROUP_ID	NUMBER	(15)	Yes	Withholding Tax group unique identifier
TAX_NAME	VARCHAR2	(15)	Yes	Withholding tax code
TAX_CODE_COMBINATION_ID	NUMBER	(15)	Yes	Accounting Flexfield identifier for account to which withholding taxes are posted
GROSS_AMOUNT	NUMBER		Yes	Amount subject to withholding
WITHHOLDING_AMOUNT	NUMBER		Yes	Amount of withholding tax
BASE_WITHHOLDING_AMOUNT	NUMBER			Amount of withholding tax in the functional currency
ACCOUNTING_DATE	DATE		Yes	Accounting date
PERIOD_NAME	VARCHAR2	(15)	Yes	Period name
CHECKRUN_NAME	VARCHAR2	(255)		Identifies the payment batch name in which this distribution was created during automatic withholding. This column is only populated if automatic withholding of tax is performed during payment
TAX_RATE_ID	NUMBER	(15)	Yes	Tax rate unique identifier
ORG_ID	NUMBER	(15)		Organization identifier
INVOICE_PAYMENT_ID	NUMBER	(15)		Payment number unique identifier
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for country-specific functionality
AWT_RELATED_ID	NUMBER	(15)		Identifier linking related distributions. Used for linking related Invoice Distribution. Populated from INVOICE_DISTRIBUTION_ID of the related distribution.
CHECKRUN_ID	NUMBER	(15)		Payment batch identifier

Query Text

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


SELECT INVOICE_ID
,      PAYMENT_NUM
,      GROUP_ID
,      TAX_NAME
,      TAX_CODE_COMBINATION_ID
,      GROSS_AMOUNT
,      WITHHOLDING_AMOUNT
,      BASE_WITHHOLDING_AMOUNT
,      ACCOUNTING_DATE
,      PERIOD_NAME
,      CHECKRUN_NAME
,      TAX_RATE_ID
,      ORG_ID
,      INVOICE_PAYMENT_ID
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      AWT_RELATED_ID
,      CHECKRUN_ID
FROM AP.AP_AWT_TEMP_DISTRIBUTIONS_ALL;

Dependencies

[top of page]

AP.AP_AWT_TEMP_DISTRIBUTIONS_ALL does not reference any database object

AP.AP_AWT_TEMP_DISTRIBUTIONS_ALL is referenced by following:

APPS: AP_AWT_TEMP_DISTRIBUTIONS; AP_AWT_TEMP_DISTRIBUTIONS_ALL