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

TABLE: AP.AP_DUPLICATE_VENDORS_ALL

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


AP_DUPLICATE_VENDORS_ALL stores information about suppliers
that Supplier Merge updates. The Supplier Merge window
inserts information into this table and then the Supplier Merge
concurrent process uses this information to merge suppliers.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_DUPLICATE_VENDORS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROCESS_FLAG
Columns
Name Datatype Length Mandatory Comments
ENTRY_ID NUMBER (15)
Entry identifier
VENDOR_ID NUMBER (15)
Supplier identifier
DUPLICATE_VENDOR_ID NUMBER (15)
Duplicate supplier identifier
VENDOR_SITE_ID NUMBER (15)
Supplier site identifier
DUPLICATE_VENDOR_SITE_ID NUMBER (15)
Duplicate supplier site identifier
NUMBER_UNPAID_INVOICES NUMBER (15)
Number of unpaid invoices transferred
NUMBER_PAID_INVOICES NUMBER (15)
Number of paid invoices transferred
NUMBER_PO_HEADERS_CHANGED NUMBER (15)
Number of purchase orders transferred
AMOUNT_UNPAID_INVOICES NUMBER

Invoice amount of transferred unpaid invoices
AMOUNT_PAID_INVOICES NUMBER

Invoice amount of transferred paid invoices
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
PROCESS_FLAG VARCHAR2 (1)
Flag that indicates if supplier has been processed
PROCESS VARCHAR2 (25)
Items (purchase orders, invoices, both) to be merged
KEEP_SITE_FLAG VARCHAR2 (1)
Flag that indicates if old supplier site will be transferred to new supplier as a new supplier site
PAID_INVOICES_FLAG VARCHAR2 (1)
Flag that indicates if paid invoices will be transferred
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).
ORG_ID NUMBER (15)
Organization identifier
Query Text

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


SELECT ENTRY_ID
,      VENDOR_ID
,      DUPLICATE_VENDOR_ID
,      VENDOR_SITE_ID
,      DUPLICATE_VENDOR_SITE_ID
,      NUMBER_UNPAID_INVOICES
,      NUMBER_PAID_INVOICES
,      NUMBER_PO_HEADERS_CHANGED
,      AMOUNT_UNPAID_INVOICES
,      AMOUNT_PAID_INVOICES
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      PROCESS_FLAG
,      PROCESS
,      KEEP_SITE_FLAG
,      PAID_INVOICES_FLAG
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ORG_ID
FROM AP.AP_DUPLICATE_VENDORS_ALL;

Dependencies

[top of page]

AP.AP_DUPLICATE_VENDORS_ALL does not reference any database object

AP.AP_DUPLICATE_VENDORS_ALL is referenced by following:

SchemaAP
ViewAP_DUPLICATE_VENDORS_ALL#