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.ECE_MVSTO_HEADERS_V

Object Details

Object Name:	ECE_MVSTO_HEADERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EC.ECE_MVSTO_HEADERS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view extracts header information
for the outbound Movement Statistics (INTRASTAT) transaction.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
COMMUNICATION_METHOD	CHAR	(3)		Communication Method
TP_TEST_FLAG	VARCHAR2	(1)	Yes	Test Indicator
TP_DOCUMENT_ID	CHAR	(5)		Document ID
TP_DOCUMENT_TYPE	VARCHAR2	(30)	Yes	Document Type
TRANSLATOR_CODE	VARCHAR2	(30)		Trading Partner Translator Code
TP_LOCATION_CODE_EXT	VARCHAR2	(35)		Trading Partner Location Code
TP_DESCRIPTION	VARCHAR2	(240)		Trading PartnerDescription
TP_REFERENCE_EXT1	VARCHAR2	(240)		Trading Partner Reference 1
TP_REFERENCE_EXT2	VARCHAR2	(240)		Trading Partner Reference 2
TRANSACTION_DATE	DATE			Transaction Date/Time
TRANSACTION_CONTROL1	VARCHAR2	(0)		Transaction Control 1 (Inbound)
TRANSACTION_CONTROL2	VARCHAR2	(0)		Transaction Control 2 (Inbound)
TRANSACTION_CONTROL3	VARCHAR2	(0)		Transaction Control 3 (Inbound)
DOCUMENT_STANDARD	VARCHAR2	(30)		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
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)	Yes	Movement Type (Internal)
REPORT_REFERENCE	VARCHAR2	(200)		Report Reference
REPORT_DATE	DATE			Report Date
STAT_TYPE	VARCHAR2	(30)		Statistical Type (Internal)
USAGE_TYPE	VARCHAR2	(30)		Usage Type (Internal)
MOVEMENT_STATUS	VARCHAR2	(30)	Yes	Movement Status (Internal)
ZONE_CODE	VARCHAR2	(10)		Economic Zone Code (Internal)
LEGAL_ENTITY	NUMBER	(15)	Yes	Legal Entity
LEGAL_ENTITY_NAME	VARCHAR2	(240)	Yes	Legal Entity Name
LEGAL_ENTITY_VAT_CODE	VARCHAR2	(0)		Legal Entity VAT Code
LEGAL_ENTITY_TAX_NAME	VARCHAR2	(15)		Legal Entity Tax Name
ORGANIZATION_ID	NUMBER		Yes	Organization ID
CUSTOMER_ID	NUMBER	(15)	Yes	Legal Entity Code (Internal)
ECE_TP_LOC_CODE	VARCHAR2	(35)		Legal Entity Code 1 (Ext)
CUSTOMER_NAME	VARCHAR2	(60)	Yes	Legal Entity Customer Name
ADDRESS1	VARCHAR2	(240)		Legal Entity Address 1
ADDRESS2	VARCHAR2	(240)		Legal Entity Address 2
ADDRESS3	VARCHAR2	(240)		Legal Entity Address 3
CITY	VARCHAR2	(30)		Legal Entity City
POSTAL_CODE	VARCHAR2	(30)		Legal Entity Postal Code
COUNTRY	VARCHAR2	(60)		Legal Entity Country (Internal)
REGION1	VARCHAR2	(120)		Legal Entity Region 1 (Internal)
REGION2	VARCHAR2	(120)		Legal Entity Region 2 (Internal)
REGION3	VARCHAR2	(120)		Legal Entity Region 3 (Internal)
ENTITY_ORG_ID	NUMBER		Yes	Entity Organization Id
TOTAL_INVOICE_EXT_VALUE	NUMBER			Total Invoice Value (Ext)
TOTAL_SUPPLEMENTARY_UNITS	NUMBER			Total Supplementary Units
TOTAL_STATISTICAL_VALUE	NUMBER			Total Statistical Value
TOTAL_TOTAL_WEIGHT	NUMBER			Total Total Weight
TOTAL_RECORDS	NUMBER			Total Records
MAP_ID	NUMBER	(15)		Mapping Repository ID

Query Text

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


SELECT COMMUNICATION_METHOD
,      TP_TEST_FLAG
,      TP_DOCUMENT_ID
,      TP_DOCUMENT_TYPE
,      TRANSLATOR_CODE
,      TP_LOCATION_CODE_EXT
,      TP_DESCRIPTION
,      TP_REFERENCE_EXT1
,      TP_REFERENCE_EXT2
,      TRANSACTION_DATE
,      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
,      PERIOD_NAME
,      EDI_TRANSACTION_REFERENCE
,      EDI_TRANSACTION_DATE
,      MOVEMENT_TYPE
,      REPORT_REFERENCE
,      REPORT_DATE
,      STAT_TYPE
,      USAGE_TYPE
,      MOVEMENT_STATUS
,      ZONE_CODE
,      LEGAL_ENTITY
,      LEGAL_ENTITY_NAME
,      LEGAL_ENTITY_VAT_CODE
,      LEGAL_ENTITY_TAX_NAME
,      ORGANIZATION_ID
,      CUSTOMER_ID
,      ECE_TP_LOC_CODE
,      CUSTOMER_NAME
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      CITY
,      POSTAL_CODE
,      COUNTRY
,      REGION1
,      REGION2
,      REGION3
,      ENTITY_ORG_ID
,      TOTAL_INVOICE_EXT_VALUE
,      TOTAL_SUPPLEMENTARY_UNITS
,      TOTAL_STATISTICAL_VALUE
,      TOTAL_TOTAL_WEIGHT
,      TOTAL_RECORDS
,      MAP_ID
FROM APPS.ECE_MVSTO_HEADERS_V;

Dependencies

[top of page]

APPS.ECE_MVSTO_HEADERS_V references the following:

APPS: ECE_MTL_MOV_STAT_V; ECE_TP_DETAILS; ECE_TP_HEADERS; FND_GLOBAL - show dependent code; HR_GENERAL - show dependent code; HR_LEGAL_ENTITIES; HR_LOCATIONS; HR_ORGANIZATION_UNITS; HR_SECURITY - show dependent code

APPS.ECE_MVSTO_HEADERS_V is not referenced by any database object