[Home] [Help] [Dependency Information]

TABLE: AP.AP_VENDOR_AUDIT_TMP

Object Details

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

AP_VENDOR_AUDIT_TMP is a temporary table used by your Oracle
Payables application to store potential duplicate suppliers for the
Supplier Audit Report. When you submit the Supplier Audit Report,
your Oracle Payables application clears the table and
inserts a record for each active supplier whose
name matches within the number of characters you specify when you
submit the report.
Your Oracle Payables application then selects from these records
to produce the Supplier Audit Report.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Columns

Query Text

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

SELECT VENDOR_ID
,      VENDOR_NUMBER
,      VENDOR_NAME
FROM AP.AP_VENDOR_AUDIT_TMP;

Dependencies

[top of page]

AP.AP_VENDOR_AUDIT_TMP does not reference any database object

AP.AP_VENDOR_AUDIT_TMP is referenced by following:

APPS

AP_VENDOR_AUDIT_TMP