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.

[Home] [Help]

VIEW: CSP.CSP_USAGE_HEADERS#

Source

View Text - Preformatted


select USAGE_HEADER_ID USAGE_HEADER_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ORGANIZATION_ID ORGANIZATION_ID, SECONDARY_INVENTORY SECONDARY_INVENTORY, RAW_AWU RAW_AWU, AWU AWU, HEADER_DATA_TYPE HEADER_DATA_TYPE, STANDARD_DEVIATION STANDARD_DEVIATION, PLANNING_PARAMETERS_ID PLANNING_PARAMETERS_ID, ITEM_COST ITEM_COST, LEAD_TIME LEAD_TIME, PROCESS_STATUS PROCESS_STATUS, RECOMMENDED_MIN_QUANTITY RECOMMENDED_MIN_QUANTITY, RECOMMENDED_MAX_QUANTITY RECOMMENDED_MAX_QUANTITY, EXTERNAL_DATA EXTERNAL_DATA, COMMENTS COMMENTS, SECURITY_GROUP_ID SECURITY_GROUP_ID, TRACKING_SIGNAL TRACKING_SIGNAL from "CSP"."CSP_USAGE_HEADERS"

View Text - HTML Formatted

SELECT USAGE_HEADER_ID USAGE_HEADER_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ORGANIZATION_ID ORGANIZATION_ID
, SECONDARY_INVENTORY SECONDARY_INVENTORY
, RAW_AWU RAW_AWU
, AWU AWU
, HEADER_DATA_TYPE HEADER_DATA_TYPE
, STANDARD_DEVIATION STANDARD_DEVIATION
, PLANNING_PARAMETERS_ID PLANNING_PARAMETERS_ID
, ITEM_COST ITEM_COST
, LEAD_TIME LEAD_TIME
, PROCESS_STATUS PROCESS_STATUS
, RECOMMENDED_MIN_QUANTITY RECOMMENDED_MIN_QUANTITY
, RECOMMENDED_MAX_QUANTITY RECOMMENDED_MAX_QUANTITY
, EXTERNAL_DATA EXTERNAL_DATA
, COMMENTS COMMENTS
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, TRACKING_SIGNAL TRACKING_SIGNAL
FROM "CSP"."CSP_USAGE_HEADERS"