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: INV.MTL_STAT_TYPE_USAGES#

Source

View Text - Preformatted


select LEGAL_ENTITY_ID LEGAL_ENTITY_ID, ZONE_CODE ZONE_CODE, STAT_TYPE STAT_TYPE, USAGE_TYPE USAGE_TYPE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PERIOD_SET_NAME PERIOD_SET_NAME, START_PERIOD_NAME START_PERIOD_NAME, END_PERIOD_NAME END_PERIOD_NAME, WEIGHT_UOM_CODE WEIGHT_UOM_CODE, ENTITY_BRANCH_REFERENCE ENTITY_BRANCH_REFERENCE, CONVERSION_TYPE CONVERSION_TYPE, CONVERSION_OPTION CONVERSION_OPTION, CATEGORY_SET_ID CATEGORY_SET_ID, TAX_OFFICE_CODE TAX_OFFICE_CODE, TAX_OFFICE_NAME TAX_OFFICE_NAME, TAX_OFFICE_LOCATION_ID TAX_OFFICE_LOCATION_ID, PERIOD_TYPE PERIOD_TYPE, ATTRIBUTE_RULE_SET_CODE ATTRIBUTE_RULE_SET_CODE, ALT_UOM_RULE_SET_CODE ALT_UOM_RULE_SET_CODE, TRIANGULATION_MODE TRIANGULATION_MODE, REFERENCE_PERIOD_RULE REFERENCE_PERIOD_RULE, PENDING_INVOICE_DAYS PENDING_INVOICE_DAYS, PRIOR_INVOICE_DAYS PRIOR_INVOICE_DAYS, RETURNS_PROCESSING RETURNS_PROCESSING, KIT_METHOD KIT_METHOD, WEIGHT_PRECISION WEIGHT_PRECISION, REPORTING_ROUNDING REPORTING_ROUNDING, INCLUDE_ESTABLISHMENTS INCLUDE_ESTABLISHMENTS from "INV"."MTL_STAT_TYPE_USAGES"

View Text - HTML Formatted

SELECT LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, ZONE_CODE ZONE_CODE
, STAT_TYPE STAT_TYPE
, USAGE_TYPE USAGE_TYPE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PERIOD_SET_NAME PERIOD_SET_NAME
, START_PERIOD_NAME START_PERIOD_NAME
, END_PERIOD_NAME END_PERIOD_NAME
, WEIGHT_UOM_CODE WEIGHT_UOM_CODE
, ENTITY_BRANCH_REFERENCE ENTITY_BRANCH_REFERENCE
, CONVERSION_TYPE CONVERSION_TYPE
, CONVERSION_OPTION CONVERSION_OPTION
, CATEGORY_SET_ID CATEGORY_SET_ID
, TAX_OFFICE_CODE TAX_OFFICE_CODE
, TAX_OFFICE_NAME TAX_OFFICE_NAME
, TAX_OFFICE_LOCATION_ID TAX_OFFICE_LOCATION_ID
, PERIOD_TYPE PERIOD_TYPE
, ATTRIBUTE_RULE_SET_CODE ATTRIBUTE_RULE_SET_CODE
, ALT_UOM_RULE_SET_CODE ALT_UOM_RULE_SET_CODE
, TRIANGULATION_MODE TRIANGULATION_MODE
, REFERENCE_PERIOD_RULE REFERENCE_PERIOD_RULE
, PENDING_INVOICE_DAYS PENDING_INVOICE_DAYS
, PRIOR_INVOICE_DAYS PRIOR_INVOICE_DAYS
, RETURNS_PROCESSING RETURNS_PROCESSING
, KIT_METHOD KIT_METHOD
, WEIGHT_PRECISION WEIGHT_PRECISION
, REPORTING_ROUNDING REPORTING_ROUNDING
, INCLUDE_ESTABLISHMENTS INCLUDE_ESTABLISHMENTS
FROM "INV"."MTL_STAT_TYPE_USAGES"