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.

VIEW: AP.AP_VENDOR_KEY_IND_ALL#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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