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_DUPLICATE_VENDORS_ALL

Object Details

Object Name:	AP_DUPLICATE_VENDORS_ALL
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_DUPLICATE_VENDORS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROCESS_FLAG

Columns

Name	Datatype	Length	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:

APPS: AP_DUPLICATE_VENDORS; AP_DUPLICATE_VENDORS_ALL; JAI_AP_DVA_ARIUD_T1