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

TABLE: AP.AP_TOLERANCES_ALL

Object Details
Object Name: AP_TOLERANCES_ALL
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_TOLERANCES_ALL
Subobject Name:
Status: VALID


AP_TOLERANCES_ALL contains the tolerance levels you set for matching and invoice variance testing. Your Oracle Payables application uses this information to determine during Invoice Validation whether to hold an invoice for exceeding amounts and quantities that you actually ordered or received, or for being taxed at significantly more or less than the proper tax rate.
This table corresponds to the Invoice Tolerances window.
There is only one row in this table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
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 (foreign key to FND_USER.USER_ID).
QTY_RECEIVED_TOLERANCE NUMBER

Percentage-based tolerance level for quantity received tolerance
TAX_TOLERANCE NUMBER

No longer used
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

Standard who column - date when this row was created.
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
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

No longer used
ORG_ID NUMBER (15)
Organization identifier
Query Text

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


SELECT 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
,      ORG_ID
FROM AP.AP_TOLERANCES_ALL;

Dependencies

[top of page]

AP.AP_TOLERANCES_ALL does not reference any database object

AP.AP_TOLERANCES_ALL is referenced by following:

SchemaAPPS
SynonymAP_TOLERANCES_ALL