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_VENDOR_KEY_IND_ALL

Object Details

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

AP_VENDOR_KEY_IND is a table that stores compiled
invoice information for the Key Indicators Report. The
data in this table is denormalized for reporting
purposes. There is one row for each period you report
on.
This table has no foreign keys.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_VENDOR_KEY_IND_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	PERIOD_NAME ORG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PERIOD_NAME	VARCHAR2	(15)	Yes	Period name
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
NUM_VENDORS	NUMBER			Number of new suppliers
NUM_VENDOR_SITES	NUMBER			Number of sites for new suppliers
NUM_SITES	NUMBER			Number of additional sites for existing suppliers
NUM_INACTIVE_VENDORS	NUMBER			Number of new suppliers with inactive dates
NUM_ONE_TIME_VENDORS	NUMBER			Number of new suppliers designated as one-time suppliers
NUM_1099_VENDORS	NUMBER			Number of new suppliers of type 1099
NUM_VENDORS_HELD	NUMBER			Number of new suppliers on hold
NUM_VENDORS_UPDATED	NUMBER			Number of existing suppliers for which supplier information updated
NUM_SITES_UPDATED	NUMBER			Number of existing supplier sites for which site information updated
VALUE1	NUMBER			Custom statistical tracking
VALUE2	NUMBER			Custom statistical tracking
VALUE3	NUMBER			Custom statistical tracking
VALUE4	NUMBER			Custom statistical tracking
VALUE5	NUMBER			Custom statistical tracking
VALUE6	NUMBER			Custom statistical tracking
VALUE7	NUMBER			Custom statistical tracking
VALUE8	NUMBER			Custom statistical tracking
VALUE9	NUMBER			Custom statistical tracking
VALUE10	NUMBER			Custom statistical tracking
ORG_ID	NUMBER	(15)		Organization identifier

Query Text

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


SELECT PERIOD_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      NUM_VENDORS
,      NUM_VENDOR_SITES
,      NUM_SITES
,      NUM_INACTIVE_VENDORS
,      NUM_ONE_TIME_VENDORS
,      NUM_1099_VENDORS
,      NUM_VENDORS_HELD
,      NUM_VENDORS_UPDATED
,      NUM_SITES_UPDATED
,      VALUE1
,      VALUE2
,      VALUE3
,      VALUE4
,      VALUE5
,      VALUE6
,      VALUE7
,      VALUE8
,      VALUE9
,      VALUE10
,      ORG_ID
FROM AP.AP_VENDOR_KEY_IND_ALL;

Dependencies

[top of page]

AP.AP_VENDOR_KEY_IND_ALL does not reference any database object

AP.AP_VENDOR_KEY_IND_ALL is referenced by following:

APPS: AP_VENDOR_KEY_IND; AP_VENDOR_KEY_IND_ALL