[Home] [Help] [Dependency Information]
Object Name: | AP_VENDOR_KEY_IND_ALL# |
---|---|
Object Type: | VIEW |
Owner: | AP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERIOD_NAME | VARCHAR2 | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
NUM_VENDORS | NUMBER | |||
NUM_VENDOR_SITES | NUMBER | |||
NUM_SITES | NUMBER | |||
NUM_INACTIVE_VENDORS | NUMBER | |||
NUM_ONE_TIME_VENDORS | NUMBER | |||
NUM_1099_VENDORS | NUMBER | |||
NUM_VENDORS_HELD | NUMBER | |||
NUM_VENDORS_UPDATED | NUMBER | |||
NUM_SITES_UPDATED | NUMBER | |||
VALUE1 | NUMBER | |||
VALUE2 | NUMBER | |||
VALUE3 | NUMBER | |||
VALUE4 | NUMBER | |||
VALUE5 | NUMBER | |||
VALUE6 | NUMBER | |||
VALUE7 | NUMBER | |||
VALUE8 | NUMBER | |||
VALUE9 | NUMBER | |||
VALUE10 | NUMBER | |||
ORG_ID | NUMBER | (15) |
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#;
|
|
|