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_TOLERANCE_TEMPLATES

Object Details

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

AP_TOLERANCE_TEMPLATES contains the tolerance levels you set for matching and invoice variance testing. Oracle Payables uses this information to determine during Invoice Validation to hold an invoice for exceeding tolerance.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_TOLERANCE_TEMPLATES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TOLERANCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TOLERANCE_ID	NUMBER	(15)	Yes	Tolerance Template Identifier
TOLERANCE_NAME	VARCHAR2	(255)	Yes	Tolerance Template Name
DESCRIPTION	VARCHAR2	(255)		Tolerance Template Description
PRICE_TOLERANCE	NUMBER			Percentage based tolerance level for price variance
QUANTITY_TOLERANCE	NUMBER			Percentage based tolerance level for quantity variance
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
QTY_RECEIVED_TOLERANCE	NUMBER			Percentage based tolerance level for quantity received tolerance
TAX_TOLERANCE	NUMBER			Percentage based tolerance level for tax variance
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column - operating system login of user who last updated this row
CREATION_DATE	DATE			Standard Who column - date when this row was created
CREATED_BY	NUMBER	(15)	Yes	Standard Who column - user who created this row
MAX_QTY_ORD_TOLERANCE	NUMBER			Tolerance level for maximum quantity ordered variance
MAX_QTY_REC_TOLERANCE	NUMBER			Tolerance level for maximum quantity received variance
SHIP_AMT_TOLERANCE	NUMBER			Tolerance level for purchase order shipment amount variance
RATE_AMT_TOLERANCE	NUMBER			Tolerance level for exchange rate amount variance
TOTAL_AMT_TOLERANCE	NUMBER			Tolerance level for total amount variance
TAX_TOL_AMT_RANGE	NUMBER			Tolerance level for total tax amount variance
TOLERANCE_TYPE	VARCHAR2	(30)		Designates the type of tolerance template as either Goods or Services

Query Text

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


SELECT TOLERANCE_ID
,      TOLERANCE_NAME
,      DESCRIPTION
,      PRICE_TOLERANCE
,      QUANTITY_TOLERANCE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      QTY_RECEIVED_TOLERANCE
,      TAX_TOLERANCE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      MAX_QTY_ORD_TOLERANCE
,      MAX_QTY_REC_TOLERANCE
,      SHIP_AMT_TOLERANCE
,      RATE_AMT_TOLERANCE
,      TOTAL_AMT_TOLERANCE
,      TAX_TOL_AMT_RANGE
,      TOLERANCE_TYPE
FROM AP.AP_TOLERANCE_TEMPLATES;

Dependencies

[top of page]

AP.AP_TOLERANCE_TEMPLATES does not reference any database object

AP.AP_TOLERANCE_TEMPLATES is referenced by following:

AP: AP_TOLERANCE_TEMPLATES#