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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: INV.MTL_STAT_TYPE_USAGES

Object Details

Object Name:	MTL_STAT_TYPE_USAGES
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_STAT_TYPE_USAGES
Subobject Name:
Status:	VALID

MTL_STAT_TYPE_USAGES stores information which determines the statistical type data that needs to be reported for each legal entity (I.E. Intrastat or Extrastat). This table could contain multiple statistical types for each legal entity and economic zone.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_STAT_TYPE_USAGES_U1	NORMAL	UNIQUE	APPS_TS_SEED	LEGAL_ENTITY_ID ZONE_CODE STAT_TYPE USAGE_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
LEGAL_ENTITY_ID	NUMBER		Yes	legal entity identifier
ZONE_CODE	VARCHAR2	(10)	Yes	zone code
STAT_TYPE	VARCHAR2	(30)	Yes	statistic type
USAGE_TYPE	VARCHAR2	(30)	Yes	usage type
CREATION_DATE	DATE		Yes	standard who column
CREATED_BY	NUMBER	(15)	Yes	standard who column
LAST_UPDATE_DATE	DATE		Yes	standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	last update login
PERIOD_SET_NAME	VARCHAR2	(15)	Yes	period set name
START_PERIOD_NAME	VARCHAR2	(15)	Yes	start period
END_PERIOD_NAME	VARCHAR2	(15)		end period
WEIGHT_UOM_CODE	VARCHAR2	(3)	Yes	weight unit of measure code
ENTITY_BRANCH_REFERENCE	VARCHAR2	(240)		entity branch reference
CONVERSION_TYPE	VARCHAR2	(30)		conversion type
CONVERSION_OPTION	VARCHAR2	(30)		conversion option
CATEGORY_SET_ID	NUMBER		Yes	category set identifier
TAX_OFFICE_CODE	VARCHAR2	(50)		tax office code
TAX_OFFICE_NAME	VARCHAR2	(240)		tax office name
TAX_OFFICE_LOCATION_ID	NUMBER		Yes	tax office location identifier
PERIOD_TYPE	VARCHAR2	(15)	Yes	Period type
ATTRIBUTE_RULE_SET_CODE	VARCHAR2	(30)	Yes	foreign key to mtl_mvt_stats_rule_sets
ALT_UOM_RULE_SET_CODE	VARCHAR2	(30)		Alternative Unit Of Measure Rule Set Code
TRIANGULATION_MODE	VARCHAR2	(15)		Triangulation Mode
REFERENCE_PERIOD_RULE	VARCHAR2	(50)		Defines the reference period rule used. Values: Shipment based , Invoice based
PENDING_INVOICE_DAYS	NUMBER			Number of (prospective) days after the end of the current period to examine for invoice.
PRIOR_INVOICE_DAYS	NUMBER			Number of (retrospective) days to look for an invoice from the transaction date.
RETURNS_PROCESSING	VARCHAR2	(30)		Value determines whether separate return from parent or aggregate into parent
KIT_METHOD	VARCHAR2	(30)
WEIGHT_PRECISION	NUMBER			Precision used to round total weight
REPORTING_ROUNDING	VARCHAR2	(30)
INCLUDE_ESTABLISHMENTS	VARCHAR2	(1)

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

INV.MTL_STAT_TYPE_USAGES does not reference any database object

INV.MTL_STAT_TYPE_USAGES is referenced by following:

APPS: MTL_STAT_TYPE_USAGES