[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MTL_MOVEMENT_PARAMETERS |
|---|---|
| Object Type: | TABLE |
| Owner: | INV |
| FND Design Data: |  INV.MTL_MOVEMENT_PARAMETERS
|
| Subobject Name: | |
| Status: | VALID |
This table stores all parameters required for movement statistics
gathering and reporting by legal entities. A legal entity is
associated with a statistical calendar, a category set for
commodity codes, and currency conversion parameters. The table also
stores the period name and reference for the latest official 'Frozen'
report runs.
| Tablespace: |  APPS_TS_SEED |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ENTITY_ORG_ID | NUMBER | Yes | Legal entity identifier | |
| PERIOD_SET_NAME | VARCHAR2 | (15) | Yes | Statistical reporting period set |
| WEIGHT_UOM_CODE | VARCHAR2 | (3) | Yes | Entity unit of measure for weight |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Yes | Standard Who column | |
| ENTITY_BRANCH_REFERENCE | VARCHAR2 | (240) | Entity branch reference | |
| CONVERSION_TYPE | VARCHAR2 | (30) | Currency conversion type | |
| CONVERSION_OPTION | VARCHAR2 | (30) | Currency conversion option | |
| CATEGORY_SET_ID | NUMBER | Commodity code category set identifier | ||
| TAX_OFFICE_CODE | VARCHAR2 | (50) | Tax authority office code | |
| TAX_OFFICE_NAME | VARCHAR2 | (240) | Tax authority name | |
| TAX_OFFICE_LOCATION_ID | NUMBER | Tax authority location identifier | ||
| LAST_ARRIVAL_PERIOD | VARCHAR2 | (15) | Latest arrival official report period | |
| LAST_ARRIVAL_ID | NUMBER | Latest arrival official report reference | ||
| LAST_ARRIVAL_ADJ_PERIOD | VARCHAR2 | (15) | Latest arrival adjustment official report period | |
| LAST_ARRIVAL_ADJ_ID | NUMBER | Latest arrival adjustment official report reference | ||
| LAST_DISPATCH_PERIOD | VARCHAR2 | (15) | Latest dispatch official report period | |
| LAST_DISPATCH_ID | NUMBER | Latest dispatch official report reference | ||
| LAST_DISPATCH_ADJ_PERIOD | VARCHAR2 | (15) | Latest dispatch adjustment official report period | |
| LAST_DISPATCH_ADJ_ID | NUMBER | Latest dispatch adjustment official report reference | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE30 | VARCHAR2 | (150) | Descriptive flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT ENTITY_ORG_ID
, PERIOD_SET_NAME
, WEIGHT_UOM_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ENTITY_BRANCH_REFERENCE
, CONVERSION_TYPE
, CONVERSION_OPTION
, CATEGORY_SET_ID
, TAX_OFFICE_CODE
, TAX_OFFICE_NAME
, TAX_OFFICE_LOCATION_ID
, LAST_ARRIVAL_PERIOD
, LAST_ARRIVAL_ID
, LAST_ARRIVAL_ADJ_PERIOD
, LAST_ARRIVAL_ADJ_ID
, LAST_DISPATCH_PERIOD
, LAST_DISPATCH_ID
, LAST_DISPATCH_ADJ_PERIOD
, LAST_DISPATCH_ADJ_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
FROM INV.MTL_MOVEMENT_PARAMETERS;
INV.MTL_MOVEMENT_PARAMETERS does not reference any database object
INV.MTL_MOVEMENT_PARAMETERS is referenced by following:
INV
MTL_MOVEMENT_PARAMETERS#
|
|
|
|