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: AR.AR_GTA_TAX_LIMITS_ALL

Object Details

Object Name:	AR_GTA_TAX_LIMITS_ALL
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_GTA_TAX_LIMITS_ALL
Subobject Name:
Status:	VALID

The AR_GTA_TAX_LIMITS_ALL stores max amount value and max number of lines of a given pair of tax registration number and OU. Transfer program will use this table to decide whether to split a specified AR transaction.
There is no primary key for this table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_GTA_TAX_LIMITS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LIMITATION_ID
AR_GTA_TAX_LIMITS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORG_ID FP_TAX_REGISTRATION_NUMBER INVOICE_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
LIMITATION_ID	NUMBER		Yes	Identifier of limitation line related to tax registration number of first party
ORG_ID	NUMBER		Yes	Organization identifier
FP_TAX_REGISTRATION_NUMBER	VARCHAR2	(50)	Yes	Tax registration number of first party
MAX_AMOUNT	NUMBER		Yes	Maximum amount limitation to a VAT invoice
MAX_NUM_OF_LINE	NUMBER		Yes	The maximum number of lines that is allowed in a VAT invoice
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(22)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created
CREATED_BY	NUMBER	(22)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID)
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID)
INVOICE_TYPE	VARCHAR2	(1)		Invoice type selected within a Tax Limitation. �2� for Common, �0� for Special, and �1� for Recycle.

Query Text

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


SELECT LIMITATION_ID
,      ORG_ID
,      FP_TAX_REGISTRATION_NUMBER
,      MAX_AMOUNT
,      MAX_NUM_OF_LINE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INVOICE_TYPE
FROM AR.AR_GTA_TAX_LIMITS_ALL;

Dependencies

[top of page]

AR.AR_GTA_TAX_LIMITS_ALL does not reference any database object

AR.AR_GTA_TAX_LIMITS_ALL is referenced by following:

AR: AR_GTA_TAX_LIMITS_ALL#