[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AP_VENDOR_KEY_IND_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
PERIOD_NAME
ORG_ID |
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 |
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;
AP.AP_VENDOR_KEY_IND_ALL does not reference any database object
AP.AP_VENDOR_KEY_IND_ALL is referenced by following:
|
|
|