[Home] [Help] [Dependency Information]
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 |
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.
Name | Datatype | Length | Mandatory | 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) |
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;
APPS.MTL_STAT_TYPE_USAGES_V is not referenced by any database object
|
|
|