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: APPS.MTL_STAT_TYPE_USAGES_V

Object Details

Object Name:	MTL_STAT_TYPE_USAGES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INV.MTL_STAT_TYPE_USAGES_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
ROW_ID	ROWID	(10)	row identifier
LEGAL_ENTITY_ID	NUMBER		legal entity identifier
ZONE_CODE	VARCHAR2	(10)	zone code
STAT_TYPE	VARCHAR2	(30)	statistic type
USAGE_TYPE	VARCHAR2	(30)	usage type
CREATION_DATE	DATE		standard who column
CREATED_BY	NUMBER	(15)	standard who column
LAST_UPDATE_DATE	DATE		standard who column
LAST_UPDATED_BY	NUMBER	(15)	standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)	last update login
NAME	VARCHAR2	(240)	name
ZONE_DISPLAY_NAME	VARCHAR2	(80)	zone display name
PERIOD_SET_NAME	VARCHAR2	(15)	period set name
PERIOD_TYPE	VARCHAR2	(15)	Period type
USER_PERIOD_TYPE	VARCHAR2	(15)	User period type
START_PERIOD_NAME	VARCHAR2	(15)	start period
END_PERIOD_NAME	VARCHAR2	(15)	end period
WEIGHT_UOM_CODE	VARCHAR2	(3)	weight unit of measure code
ENTITY_BRANCH_REFERENCE	VARCHAR2	(240)	entity branch reference
CONVERSION_TYPE	VARCHAR2	(30)	convertion type
CONVERSION_OPTION	VARCHAR2	(30)	convertion type option
CATEGORY_SET_ID	NUMBER		category set id
CATEGORY_SET_NAME	VARCHAR2	(30)	category set name
TAX_OFFICE_CODE	VARCHAR2	(50)	tax office location code
TAX_OFFICE_NAME	VARCHAR2	(240)	tax office location name
TAX_OFFICE_LOCATION_ID	NUMBER		tax office location id
TAX_OFFICE_LOCATION_CODE	VARCHAR2	(60)	tax office location code
ATTRIBUTE_RULE_SET_CODE	VARCHAR2	(30)
ALT_UOM_RULE_SET_CODE	VARCHAR2	(30)	Alternate UOM Rule Set Code
TRIANGULATION_MODE	VARCHAR2	(15)
REFERENCE_PERIOD_RULE	VARCHAR2	(50)	Reference Period Rule
PENDING_INVOICE_DAYS	NUMBER		Pending Invoice Days
PRIOR_INVOICE_DAYS	NUMBER		Prior Invoice Days
RETURNS_PROCESSING	VARCHAR2	(30)	Returns Processing
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 ROW_ID
,      LEGAL_ENTITY_ID
,      ZONE_CODE
,      STAT_TYPE
,      USAGE_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      NAME
,      ZONE_DISPLAY_NAME
,      PERIOD_SET_NAME
,      PERIOD_TYPE
,      USER_PERIOD_TYPE
,      START_PERIOD_NAME
,      END_PERIOD_NAME
,      WEIGHT_UOM_CODE
,      ENTITY_BRANCH_REFERENCE
,      CONVERSION_TYPE
,      CONVERSION_OPTION
,      CATEGORY_SET_ID
,      CATEGORY_SET_NAME
,      TAX_OFFICE_CODE
,      TAX_OFFICE_NAME
,      TAX_OFFICE_LOCATION_ID
,      TAX_OFFICE_LOCATION_CODE
,      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 APPS.MTL_STAT_TYPE_USAGES_V;

Dependencies

[top of page]

APPS.MTL_STAT_TYPE_USAGES_V references the following:

APPS: GL_PERIOD_TYPES; HR_GENERAL - show dependent code; HR_LOCATIONS; HZ_LOCATIONS; MTL_CATEGORY_SETS; MTL_ECONOMIC_ZONES_VL; MTL_STAT_TYPE_USAGES; XLE_FIRSTPARTY_INFORMATION_V

APPS.MTL_STAT_TYPE_USAGES_V is not referenced by any database object