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: EC.ECE_MVSTO_HEADERS

Object Details

Object Name:	ECE_MVSTO_HEADERS
Object Type:	TABLE
Owner:	EC
FND Design Data:	EC.ECE_MVSTO_HEADERS
Subobject Name:
Status:	VALID

ECE_MVSTO_HEADERS contains movement statistics header
data to support the outbound Movement Statistics transaction.

ECE_MVSTO_HEADERS is based primarily on data stored in
MTL_MOVEMENT_STATISTICS from Oracle Inventory. It contains
statistical data related to material movements and gives the
ability to track movement of goods regardless of countries
involved.

All columns denoted with "Int" or "Internal" represent Oracle
Applications internal values. All columns denoted with "Ext" or
"External" represent the equivalent external values sourced
from the ECE_XREF_DATA table if code conversion is enabled
for the column.

TRANSACTION_RECORD_ID is the unique key that links the
ECE_MVSTO_HEADERS table to its corresponding extension
table ECE_MVSTO_HEADERS_X.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ECE_MVSTO_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	TRANSACTION_RECORD_ID

Columns

Name	Datatype	Length	Mandatory	Comments
COMMUNICATION_METHOD	VARCHAR2	(30)		Communication Method
TP_TEST_FLAG	VARCHAR2	(1)		Test Indicator
TP_DOCUMENT_ID	VARCHAR2	(6)		Document ID
DOCUMENT_TYPE	VARCHAR2	(25)		Document Type
TP_DOC_PURPOSE_CODE	VARCHAR2	(2)		Document Purpose Code
TP_DOCUMENT_CODE	VARCHAR2	(20)		Document Code
TRANSLATOR_CODE	VARCHAR2	(30)		Trading Partner Translator Code
TP_LOCATION_CODE_EXT	VARCHAR2	(35)		Trading Partner Location Code
TP_DESCRIPTION	VARCHAR2	(240)		Trading Partner Description
TP_REFERENCE_EXT1	VARCHAR2	(240)		Trading Partner Reference 1
TP_REFERENCE_EXT2	VARCHAR2	(240)		Trading Partner Reference 2
TRANSACTION_DATE	DATE			Transaction Date/Time
RUN_ID	NUMBER			Transaction Run ID
TRANSACTION_CONTROL1	VARCHAR2	(10)		Transaction Control 1
TRANSACTION_CONTROL2	VARCHAR2	(10)		Transaction Control 2
TRANSACTION_CONTROL3	VARCHAR2	(10)		Transaction Control 3
DOCUMENT_STANDARD	VARCHAR2	(10)		Document Standard
TPH_ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Trading Partner Header Flexfield Context
TPH_ATTRIBUTE1	VARCHAR2	(150)		Trading Partner Header Flexfield 1
TPH_ATTRIBUTE2	VARCHAR2	(150)		Trading Partner Header Flexfield 2
TPH_ATTRIBUTE3	VARCHAR2	(150)		Trading Partner Header Flexfield 3
TPH_ATTRIBUTE4	VARCHAR2	(150)		Trading Partner Header Flexfield 4
TPH_ATTRIBUTE5	VARCHAR2	(150)		Trading Partner Header Flexfield 5
TPH_ATTRIBUTE6	VARCHAR2	(150)		Trading Partner Header Flexfield 6
TPH_ATTRIBUTE7	VARCHAR2	(150)		Trading Partner Header Flexfield 7
TPH_ATTRIBUTE8	VARCHAR2	(150)		Trading Partner Header Flexfield 8
TPH_ATTRIBUTE9	VARCHAR2	(150)		Trading Partner Header Flexfield 9
TPH_ATTRIBUTE10	VARCHAR2	(150)		Trading Partner Header Flexfield 10
TPH_ATTRIBUTE11	VARCHAR2	(150)		Trading Partner Header Flexfield 11
TPH_ATTRIBUTE12	VARCHAR2	(150)		Trading Partner Header Flexfield 12
TPH_ATTRIBUTE13	VARCHAR2	(150)		Trading Partner Header Flexfield 13
TPH_ATTRIBUTE14	VARCHAR2	(150)		Trading Partner Header Flexfield 14
TPH_ATTRIBUTE15	VARCHAR2	(150)		Trading Partner Header Flexfield 15
TPD_ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Trading Partner Detail Flexfield Context
TPD_ATTRIBUTE1	VARCHAR2	(150)		Trading Partner Detail Flexfield 1
TPD_ATTRIBUTE2	VARCHAR2	(150)		Trading Partner Detail Flexfield 2
TPD_ATTRIBUTE3	VARCHAR2	(150)		Trading Partner Detail Flexfield 3
TPD_ATTRIBUTE4	VARCHAR2	(150)		Trading Partner Detail Flexfield 4
TPD_ATTRIBUTE5	VARCHAR2	(150)		Trading Partner Detail Flexfield 5
HEADER_DATA_EXIST_FLAG	VARCHAR2	(1)		Header Data Exist Flag
PERIOD_NAME	VARCHAR2	(15)		Period Name
EDI_TRANSACTION_REFERENCE	VARCHAR2	(35)		EDI Transaction Reference
EDI_TRANSACTION_DATE	DATE			EDI Transaction Date
MOVEMENT_TYPE	VARCHAR2	(30)		Movement Type (Internal)
MOVEMENT_TYPE_EXT1	VARCHAR2	(30)		Movement Type 1 (Ext)
MOVEMENT_TYPE_EXT2	VARCHAR2	(30)		Movement Type 2 (Ext)
MOVEMENT_TYPE_EXT3	VARCHAR2	(30)		Movement Type 3 (Ext)
MOVEMENT_TYPE_EXT4	VARCHAR2	(30)		Movement Type 4 (Ext)
MOVEMENT_TYPE_EXT5	VARCHAR2	(30)		Movement Type 5 (Ext)
REPORT_REFERENCE	VARCHAR2	(35)		Report Reference
REPORT_DATE	DATE			Report Date
STAT_TYPE	VARCHAR2	(30)		Statistical Type (Internal)
STAT_TYPE_EXT1	VARCHAR2	(30)		Statistical Type 1 (Ext)
STAT_TYPE_EXT2	VARCHAR2	(30)		Statistical Type 2 (Ext)
STAT_TYPE_EXT3	VARCHAR2	(30)		Statistical Type 3 (Ext)
STAT_TYPE_EXT4	VARCHAR2	(30)		Statistical Type 4 (Ext)
STAT_TYPE_EXT5	VARCHAR2	(30)		Statistical Type 5 (Ext)
USAGE_TYPE	VARCHAR2	(30)		Usage Type (Internal)
USAGE_TYPE_EXT1	VARCHAR2	(30)		Usage Type 1 (Ext)
USAGE_TYPE_EXT2	VARCHAR2	(30)		Usage Type 2 (Ext)
USAGE_TYPE_EXT3	VARCHAR2	(30)		Usage Type 3 (Ext)
USAGE_TYPE_EXT4	VARCHAR2	(30)		Usage Type 4 (Ext)
USAGE_TYPE_EXT5	VARCHAR2	(30)		Usage Type 5 (Ext)
MOVEMENT_STATUS	VARCHAR2	(30)		Movement Status (Internal)
MOVEMENT_STATUS_EXT1	VARCHAR2	(30)		Movement Status 1 (Ext)
MOVEMENT_STATUS_EXT2	VARCHAR2	(30)		Movement Status 2 (Ext)
MOVEMENT_STATUS_EXT3	VARCHAR2	(30)		Movement Status 3 (Ext)
MOVEMENT_STATUS_EXT4	VARCHAR2	(30)		Movement Status 4 (Ext)
MOVEMENT_STATUS_EXT5	VARCHAR2	(30)		Movement Status 5 (Ext)
ZONE_CODE	VARCHAR2	(10)		Economic Zone Code (Internal)
ECONOMIC_ZONE_EXT1	VARCHAR2	(10)		Economic Zone Code 1 (Ext)
ECONOMIC_ZONE_EXT2	VARCHAR2	(30)		Economic Zone Code 2 (Ext)
ECONOMIC_ZONE_EXT3	VARCHAR2	(30)		Economic Zone Code 3 (Ext)
ECONOMIC_ZONE_EXT4	VARCHAR2	(30)		Economic Zone Code 4 (Ext)
ECONOMIC_ZONE_EXT5	VARCHAR2	(30)		Economic Zone Code 5 (Ext)
LEGAL_ENTITY	NUMBER			Legal Entity
LEGAL_ENTITY_NAME	VARCHAR2	(60)		Legal Entity Name
LEGAL_ENTITY_VAT_CODE	VARCHAR2	(150)		Legal Entity VAT Code
LEGAL_ENTITY_TAX_NAME	VARCHAR2	(15)		Legal Entity Tax Name
ORGANIZATION_ID	NUMBER			Organization ID
LEGAL_ENTITY_CODE_INT	NUMBER			Legal Entity Code (Internal)
ECE_TP_LOC_CODE	VARCHAR2	(35)		Legal Entity Code (Ext)
LEGAL_ENTITY_CUSTOMER_NAME	VARCHAR2	(50)		Legal Entity Customer Name
LEGAL_ENTITY_ADDRESS1	VARCHAR2	(60)		Legal Entity Address 1
LEGAL_ENTITY_ADDRESS2	VARCHAR2	(60)		Legal Entity Address 2
LEGAL_ENTITY_ADDRESS3	VARCHAR2	(60)		Legal Entity Address 3
LEGAL_ENTITY_CITY	VARCHAR2	(30)		Legal Entity City
LEGAL_ENTITY_POSTAL_CODE	VARCHAR2	(30)		Legal Entity Postal Code
LEGAL_ENTITY_COUNTRY_INT	VARCHAR2	(20)		Legal Entity Country (Internal)
LEGAL_ENTITY_COUNTRY_EXT1	VARCHAR2	(80)		Legal Entity Country (Ext)
LEGAL_ENTITY_REGION1_INT	VARCHAR2	(60)		Legal Entity Region 1 (Internal)
LEGAL_ENTITY_REGION1_EXT1	VARCHAR2	(80)		Legal Entity Region 1 (Ext)
LEGAL_ENTITY_REGION2_INT	VARCHAR2	(60)		Legal Entity Region 2 (Internal)
LEGAL_ENTITY_REGION2_EXT1	VARCHAR2	(80)		Legal Entity Region 2 (Ext)
LEGAL_ENTITY_REGION3_INT	VARCHAR2	(60)		Legal Entity Region 3 (Internal)
LEGAL_ENTITY_REGION3_EXT1	VARCHAR2	(80)		Legal Entity Region 3 (Ext)
LEGAL_ENTITY_ID	NUMBER			Legal Entity ID
ENTITY_ORG_ID	NUMBER			Entity Organization ID
TRANSACTION_RECORD_ID	NUMBER		Yes	Transaction Record ID
TOTAL_INVOICE_EXT_VALUE	NUMBER			Total Invoice External Value
TOTAL_SUPPLEMENTARY_UNITS	NUMBER			Total Supplementary Units
TOTAL_STATISTICAL_VALUE	NUMBER			Total Statistical Value
TOTAL_TOTAL_WEIGHT	NUMBER			Total Weight
TOTAL_RECORDS	NUMBER			Total Records
MAP_ID	NUMBER			Map ID
SECURITY_GROUP_ID	NUMBER

Query Text

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


SELECT COMMUNICATION_METHOD
,      TP_TEST_FLAG
,      TP_DOCUMENT_ID
,      DOCUMENT_TYPE
,      TP_DOC_PURPOSE_CODE
,      TP_DOCUMENT_CODE
,      TRANSLATOR_CODE
,      TP_LOCATION_CODE_EXT
,      TP_DESCRIPTION
,      TP_REFERENCE_EXT1
,      TP_REFERENCE_EXT2
,      TRANSACTION_DATE
,      RUN_ID
,      TRANSACTION_CONTROL1
,      TRANSACTION_CONTROL2
,      TRANSACTION_CONTROL3
,      DOCUMENT_STANDARD
,      TPH_ATTRIBUTE_CATEGORY
,      TPH_ATTRIBUTE1
,      TPH_ATTRIBUTE2
,      TPH_ATTRIBUTE3
,      TPH_ATTRIBUTE4
,      TPH_ATTRIBUTE5
,      TPH_ATTRIBUTE6
,      TPH_ATTRIBUTE7
,      TPH_ATTRIBUTE8
,      TPH_ATTRIBUTE9
,      TPH_ATTRIBUTE10
,      TPH_ATTRIBUTE11
,      TPH_ATTRIBUTE12
,      TPH_ATTRIBUTE13
,      TPH_ATTRIBUTE14
,      TPH_ATTRIBUTE15
,      TPD_ATTRIBUTE_CATEGORY
,      TPD_ATTRIBUTE1
,      TPD_ATTRIBUTE2
,      TPD_ATTRIBUTE3
,      TPD_ATTRIBUTE4
,      TPD_ATTRIBUTE5
,      HEADER_DATA_EXIST_FLAG
,      PERIOD_NAME
,      EDI_TRANSACTION_REFERENCE
,      EDI_TRANSACTION_DATE
,      MOVEMENT_TYPE
,      MOVEMENT_TYPE_EXT1
,      MOVEMENT_TYPE_EXT2
,      MOVEMENT_TYPE_EXT3
,      MOVEMENT_TYPE_EXT4
,      MOVEMENT_TYPE_EXT5
,      REPORT_REFERENCE
,      REPORT_DATE
,      STAT_TYPE
,      STAT_TYPE_EXT1
,      STAT_TYPE_EXT2
,      STAT_TYPE_EXT3
,      STAT_TYPE_EXT4
,      STAT_TYPE_EXT5
,      USAGE_TYPE
,      USAGE_TYPE_EXT1
,      USAGE_TYPE_EXT2
,      USAGE_TYPE_EXT3
,      USAGE_TYPE_EXT4
,      USAGE_TYPE_EXT5
,      MOVEMENT_STATUS
,      MOVEMENT_STATUS_EXT1
,      MOVEMENT_STATUS_EXT2
,      MOVEMENT_STATUS_EXT3
,      MOVEMENT_STATUS_EXT4
,      MOVEMENT_STATUS_EXT5
,      ZONE_CODE
,      ECONOMIC_ZONE_EXT1
,      ECONOMIC_ZONE_EXT2
,      ECONOMIC_ZONE_EXT3
,      ECONOMIC_ZONE_EXT4
,      ECONOMIC_ZONE_EXT5
,      LEGAL_ENTITY
,      LEGAL_ENTITY_NAME
,      LEGAL_ENTITY_VAT_CODE
,      LEGAL_ENTITY_TAX_NAME
,      ORGANIZATION_ID
,      LEGAL_ENTITY_CODE_INT
,      ECE_TP_LOC_CODE
,      LEGAL_ENTITY_CUSTOMER_NAME
,      LEGAL_ENTITY_ADDRESS1
,      LEGAL_ENTITY_ADDRESS2
,      LEGAL_ENTITY_ADDRESS3
,      LEGAL_ENTITY_CITY
,      LEGAL_ENTITY_POSTAL_CODE
,      LEGAL_ENTITY_COUNTRY_INT
,      LEGAL_ENTITY_COUNTRY_EXT1
,      LEGAL_ENTITY_REGION1_INT
,      LEGAL_ENTITY_REGION1_EXT1
,      LEGAL_ENTITY_REGION2_INT
,      LEGAL_ENTITY_REGION2_EXT1
,      LEGAL_ENTITY_REGION3_INT
,      LEGAL_ENTITY_REGION3_EXT1
,      LEGAL_ENTITY_ID
,      ENTITY_ORG_ID
,      TRANSACTION_RECORD_ID
,      TOTAL_INVOICE_EXT_VALUE
,      TOTAL_SUPPLEMENTARY_UNITS
,      TOTAL_STATISTICAL_VALUE
,      TOTAL_TOTAL_WEIGHT
,      TOTAL_RECORDS
,      MAP_ID
,      SECURITY_GROUP_ID
FROM EC.ECE_MVSTO_HEADERS;

Dependencies

[top of page]

EC.ECE_MVSTO_HEADERS does not reference any database object

EC.ECE_MVSTO_HEADERS is referenced by following:

APPS: ECE_MVSTO_HEADERS