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]

VIEW: INV.MTL_STAT_TYPE_USAGES#

Object Details

Object Name:	MTL_STAT_TYPE_USAGES#
Object Type:	VIEW
Owner:	INV
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
LEGAL_ENTITY_ID	NUMBER		Yes
ZONE_CODE	VARCHAR2	(10)	Yes
STAT_TYPE	VARCHAR2	(30)	Yes
USAGE_TYPE	VARCHAR2	(30)	Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes
PERIOD_SET_NAME	VARCHAR2	(15)	Yes
START_PERIOD_NAME	VARCHAR2	(15)	Yes
END_PERIOD_NAME	VARCHAR2	(15)
WEIGHT_UOM_CODE	VARCHAR2	(3)	Yes
ENTITY_BRANCH_REFERENCE	VARCHAR2	(240)
CONVERSION_TYPE	VARCHAR2	(30)
CONVERSION_OPTION	VARCHAR2	(30)
CATEGORY_SET_ID	NUMBER		Yes
TAX_OFFICE_CODE	VARCHAR2	(50)
TAX_OFFICE_NAME	VARCHAR2	(240)
TAX_OFFICE_LOCATION_ID	NUMBER		Yes
PERIOD_TYPE	VARCHAR2	(15)	Yes
ATTRIBUTE_RULE_SET_CODE	VARCHAR2	(30)	Yes
ALT_UOM_RULE_SET_CODE	VARCHAR2	(30)
TRIANGULATION_MODE	VARCHAR2	(15)
REFERENCE_PERIOD_RULE	VARCHAR2	(50)
PENDING_INVOICE_DAYS	NUMBER
PRIOR_INVOICE_DAYS	NUMBER
RETURNS_PROCESSING	VARCHAR2	(30)
KIT_METHOD	VARCHAR2	(30)
WEIGHT_PRECISION	NUMBER
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# references the following:

INV: MTL_STAT_TYPE_USAGES

INV.MTL_STAT_TYPE_USAGES# is referenced by following:

APPS: MTL_STAT_TYPE_USAGES