DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.ECE_MVSTO_DETAILS_V

Object Details
Object Name: ECE_MVSTO_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewEC.ECE_MVSTO_DETAILS_V
Subobject Name:
Status: VALID

View Type

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


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


[View Source]

Columns
Name Datatype Length Mandatory Comments
EDI_SENT_FLAG VARCHAR2 (1) Yes EDI Sent Flag
PERIOD_NAME VARCHAR2 (15)
Period Name
EDI_TRANSACTION_REFERENCE VARCHAR2 (35)
EDI Transaction Reference
EDI_TRANSACTION_DATE DATE

EDI Transaction Date
TRANSACTION_DATE DATE
Yes Transaction Date
SET_OF_BOOKS_PERIOD VARCHAR2 (15)
Set Of Books Period
CREATION_METHOD VARCHAR2 (30) Yes Creation Method (Internal)
FLOW_INDICATOR_CODE VARCHAR2 (30)
Flow Indicator Code (Internal)
STAT_METHOD VARCHAR2 (30)
Statistical Method (Internal)
STAT_TYPE VARCHAR2 (30)
Statistical Type (Internal)
TRANSPORT_MODE VARCHAR2 (30)
Transport Mode (Internal)
TRANSACTION_NATURE VARCHAR2 (30)
Transaction Nature(Internal)
MOVEMENT_NATURE_CODE VARCHAR2 (30)
Movement Nature Code (Internal)
ORIGIN_TERRITORY_EU_CODE VARCHAR2 (3)
Origin Territory EU Code
ORIGIN_TERRITORY_CODE VARCHAR2 (2)
Origin Territory Code (Internal)
DESTINATION_TERRITORY_EU_CODE VARCHAR2 (3)
Destination Territory EU Code
DESTINATION_TERRITORY_CODE VARCHAR2 (2)
Destination Territory Code (Internal)
DISPATCH_TERRITORY_EU_CODE VARCHAR2 (3)
Dispatch Territory EU Code
DISPATCH_TERRITORY_CODE VARCHAR2 (2)
Dispatch Territory Code (Internal)
TRIANGULATION_COUNTRY_EU_CODE VARCHAR2 (3)
Triangulation Country EU Code
TRIANGULATION_COUNTRY_CODE VARCHAR2 (30)
Triangulation Country Code (Internal)
PORT VARCHAR2 (30)
Port (Internal)
AREA VARCHAR2 (30)
Area (Internal)
MOVEMENT_ID NUMBER
Yes Movement ID
MOVEMENT_TYPE VARCHAR2 (30) Yes Movement Type (Internal)
ZONE_CODE VARCHAR2 (10)
Economic Zone Code (Internal)
CURRENCY_CODE VARCHAR2 (15)
Currency Code (Internal)
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency Conversion Type (Internal)
CURRENCY_CONVERSION_DATE DATE

Currency Conversion Date
CURRENCY_CONVERSION_RATE NUMBER

Currency Conversion Rate
MOVEMENT_AMOUNT NUMBER

Movement Amount
ITEM_COST NUMBER

Item Cost
DOCUMENT_UNIT_PRICE NUMBER

Document Unit Price
DOCUMENT_LINE_EXT_VALUE NUMBER

Document Line Extend Value
OUTSIDE_CODE VARCHAR2 (30)
Outside Code (Internal)
OUTSIDE_EXT_VALUE NUMBER

Outside Value (Ext)
OUTSIDE_UNIT_PRICE NUMBER

Outside Unit Price
STAT_ADJ_AMOUNT NUMBER

Statistical Adjustment Amount
STAT_ADJ_PERCENT NUMBER

Statistical Adjustment Percent
STAT_EXT_VALUE NUMBER

Statistical Value (Ext)
DELIVERY_TERMS VARCHAR2 (30)
Delivery Terms (Internal)
PRIMARY_QUANTITY NUMBER

Primary Quantity
TRANSACTION_QUANTITY NUMBER

Transaction Quantity
TRANSACTION_UOM_CODE VARCHAR2 (3)
Transaction Unit of Measure Code (Internal)
WEIGHT_METHOD VARCHAR2 (30)
Weight Method
UNIT_WEIGHT NUMBER

Unit Weight
TOTAL_WEIGHT NUMBER

Total Weight
TOTAL_WEIGHT_UOM_CODE VARCHAR2 (3)
Total Weight Unit of Measure Code (Internal)
ALTERNATE_QUANTITY NUMBER

Alternate Quantity
ALTERNATE_UOM_CODE VARCHAR2 (3)
Alternate Unit of Measure Code (Internal)
COMMODITY_CODE VARCHAR2 (240)
Commodity Code (Internal)
COMMODITY_DESCRIPTION VARCHAR2 (240)
Commodity Description
COMMENTS VARCHAR2 (240)
Comments
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description
DOCUMENT_SOURCE_TYPE VARCHAR2 (30) Yes Document Source Type (Internal)
DOCUMENT_REFERENCE VARCHAR2 (50)
Document Reference
DOCUMENT_LINE_REFERENCE VARCHAR2 (30)
Document Line Reference
TRANSACTING_FROM_ORG VARCHAR2 (50)
Transacting From Organization
TRANSACTING_TO_ORG VARCHAR2 (50)
Transacting To Organization
DISTRIBUTION_LINE_NUMBER NUMBER

Distribution Line Number
AFFILIATION_REFERENCE_CODE VARCHAR2 (30)
Affiliation Reference Code (Internal)
CONTAINER_TYPE_CODE VARCHAR2 (30)
Container Type Code (Internal)
CSA_CODE VARCHAR2 (30)
CSA Code (Internal)
OIL_REFERENCE_CODE VARCHAR2 (30)
Oil Reference Code (Internal)
PICK_SLIP_REFERENCE VARCHAR2 (50)
Pick Slip Reference
PREFERENCE_CODE VARCHAR2 (30)
Preference Code (Internal)
RECEIPT_REFERENCE VARCHAR2 (50)
Receipt Reference (Internal)
SHIPMENT_LINE_REFERENCE VARCHAR2 (30)
Shipment Line Reference (Internal)
SHIPMENT_REFERENCE VARCHAR2 (50)
Shipment Reference (Internal)
TARIC_CODE VARCHAR2 (30)
Taric Code (Internal)
INVOICE_BATCH_REFERENCE VARCHAR2 (50)
Invoice Batch Reference
INVOICE_DATE_REFERENCE DATE

Invoice Date Reference
INVOICE_LINE_EXT_VALUE NUMBER

Invoice Line Value (Ext)
INVOICE_LINE_REFERENCE VARCHAR2 (30)
Invoice Line Reference
INVOICE_QUANTITY NUMBER

Invoice Quantity
INVOICE_REFERENCE VARCHAR2 (50)
Invoice Reference
INVOICE_UNIT_PRICE NUMBER

Invoice Unit Price
INVOICE_BATCH_ID NUMBER

Invoice Batch ID
INVOICE_ID NUMBER

Invoice ID
CUSTOMER_LOCATION VARCHAR2 (50)
Customer Location
CUSTOMER_NAME VARCHAR2 (240)
Customer Name
CUSTOMER_NUMBER VARCHAR2 (50)
Customer Number
BILL_TO_NAME VARCHAR2 (240)
Bill To Name
BILL_TO_NUMBER VARCHAR2 (50)
Bill To Number
BILL_TO_SITE VARCHAR2 (50)
Bill To Site
SHIP_TO_NAME VARCHAR2 (240)
Ship To Name
SHIP_TO_NUMBER VARCHAR2 (50)
Ship To Number
SHIP_TO_SITE VARCHAR2 (50)
Ship To Site
BILL_TO_CUSTOMER_ID NUMBER

Bill To Customer ID
BILL_TO_SITE_USE_ID NUMBER

Bill To Site Use ID
SHIP_TO_CUSTOMER_ID NUMBER

Ship To Customer ID
SHIP_TO_SITE_USE_ID NUMBER

Ship To Site Use ID
VENDOR_NAME VARCHAR2 (240)
Vendor Name
VENDOR_NUMBER VARCHAR2 (50)
Vendor Number
VENDOR_SITE VARCHAR2 (50)
Vendor Site
VENDOR_ID NUMBER

Vendor ID
VENDOR_SITE_ID NUMBER

Vendor Site ID
CATEGORY_ID NUMBER

Category ID
CUSTOMER_TRX_LINE_ID NUMBER

Customer Transaction Line ID
FROM_ORGANIZATION_ID NUMBER

From Organization ID
TO_ORGANIZATION_ID NUMBER

To Organization ID
INVENTORY_ITEM_ID NUMBER

Inventory Item ID
MTL_TRANSACTION_ID NUMBER

Material Transaction Id
RCV_TRANSACTION_ID NUMBER

Receiving Transaction ID
ORDER_HEADER_ID NUMBER

Order Header ID
ORDER_LINE_ID NUMBER

Order Line ID
ORGANIZATION_ID NUMBER
Yes Organization ID
PARENT_MOVEMENT_ID NUMBER
Yes Parent Movement ID
PICKING_LINE_DETAIL_ID NUMBER

Picking Line Detail ID
PICKING_LINE_ID NUMBER

Picking Line ID
PO_HEADER_ID NUMBER

Po Header ID
PO_LINE_ID NUMBER

Po Line ID
PO_LINE_LOCATION_ID NUMBER

Po Line Location ID
REQUISITION_HEADER_ID NUMBER

Requisition Header ID
REQUISITION_LINE_ID NUMBER

Requisition Line ID
SHIPMENT_HEADER_ID NUMBER

Shipment Header ID
SHIPMENT_LINE_ID NUMBER

Shipment Line ID
CREATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
ENTITY_ORG_ID NUMBER
Yes Entity Organization ID
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Detail Flexfiled Context
ATTRIBUTE1 VARCHAR2 (150)
Detail Flexfield 1
ATTRIBUTE2 VARCHAR2 (150)
Detail Flexfield 2
ATTRIBUTE3 VARCHAR2 (150)
Detail Flexfield 3
ATTRIBUTE4 VARCHAR2 (150)
Detail Flexfield 4
ATTRIBUTE5 VARCHAR2 (150)
Detail Flexfield 5
ATTRIBUTE6 VARCHAR2 (150)
Detail Flexfield 6
ATTRIBUTE7 VARCHAR2 (150)
Detail Flexfield 7
ATTRIBUTE8 VARCHAR2 (150)
Detail Flexfield 8
ATTRIBUTE9 VARCHAR2 (150)
Detail Flexfield 9
ATTRIBUTE10 VARCHAR2 (150)
Detail Flexfield 10
ATTRIBUTE11 VARCHAR2 (150)
Detail Flexfield 11
ATTRIBUTE12 VARCHAR2 (150)
Detail Flexfield 12
ATTRIBUTE13 VARCHAR2 (150)
Detail Flexfield 13
ATTRIBUTE14 VARCHAR2 (150)
Detail Flexfield 14
ATTRIBUTE15 VARCHAR2 (150)
Detail Flexfield 15
TRANSACTION_HEADER_ID VARCHAR2 (0)
Transaction Header ID
Query Text

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


SELECT EDI_SENT_FLAG
,      PERIOD_NAME
,      EDI_TRANSACTION_REFERENCE
,      EDI_TRANSACTION_DATE
,      TRANSACTION_DATE
,      SET_OF_BOOKS_PERIOD
,      CREATION_METHOD
,      FLOW_INDICATOR_CODE
,      STAT_METHOD
,      STAT_TYPE
,      TRANSPORT_MODE
,      TRANSACTION_NATURE
,      MOVEMENT_NATURE_CODE
,      ORIGIN_TERRITORY_EU_CODE
,      ORIGIN_TERRITORY_CODE
,      DESTINATION_TERRITORY_EU_CODE
,      DESTINATION_TERRITORY_CODE
,      DISPATCH_TERRITORY_EU_CODE
,      DISPATCH_TERRITORY_CODE
,      TRIANGULATION_COUNTRY_EU_CODE
,      TRIANGULATION_COUNTRY_CODE
,      PORT
,      AREA
,      MOVEMENT_ID
,      MOVEMENT_TYPE
,      ZONE_CODE
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      MOVEMENT_AMOUNT
,      ITEM_COST
,      DOCUMENT_UNIT_PRICE
,      DOCUMENT_LINE_EXT_VALUE
,      OUTSIDE_CODE
,      OUTSIDE_EXT_VALUE
,      OUTSIDE_UNIT_PRICE
,      STAT_ADJ_AMOUNT
,      STAT_ADJ_PERCENT
,      STAT_EXT_VALUE
,      DELIVERY_TERMS
,      PRIMARY_QUANTITY
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM_CODE
,      WEIGHT_METHOD
,      UNIT_WEIGHT
,      TOTAL_WEIGHT
,      TOTAL_WEIGHT_UOM_CODE
,      ALTERNATE_QUANTITY
,      ALTERNATE_UOM_CODE
,      COMMODITY_CODE
,      COMMODITY_DESCRIPTION
,      COMMENTS
,      ITEM_DESCRIPTION
,      DOCUMENT_SOURCE_TYPE
,      DOCUMENT_REFERENCE
,      DOCUMENT_LINE_REFERENCE
,      TRANSACTING_FROM_ORG
,      TRANSACTING_TO_ORG
,      DISTRIBUTION_LINE_NUMBER
,      AFFILIATION_REFERENCE_CODE
,      CONTAINER_TYPE_CODE
,      CSA_CODE
,      OIL_REFERENCE_CODE
,      PICK_SLIP_REFERENCE
,      PREFERENCE_CODE
,      RECEIPT_REFERENCE
,      SHIPMENT_LINE_REFERENCE
,      SHIPMENT_REFERENCE
,      TARIC_CODE
,      INVOICE_BATCH_REFERENCE
,      INVOICE_DATE_REFERENCE
,      INVOICE_LINE_EXT_VALUE
,      INVOICE_LINE_REFERENCE
,      INVOICE_QUANTITY
,      INVOICE_REFERENCE
,      INVOICE_UNIT_PRICE
,      INVOICE_BATCH_ID
,      INVOICE_ID
,      CUSTOMER_LOCATION
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      BILL_TO_NAME
,      BILL_TO_NUMBER
,      BILL_TO_SITE
,      SHIP_TO_NAME
,      SHIP_TO_NUMBER
,      SHIP_TO_SITE
,      BILL_TO_CUSTOMER_ID
,      BILL_TO_SITE_USE_ID
,      SHIP_TO_CUSTOMER_ID
,      SHIP_TO_SITE_USE_ID
,      VENDOR_NAME
,      VENDOR_NUMBER
,      VENDOR_SITE
,      VENDOR_ID
,      VENDOR_SITE_ID
,      CATEGORY_ID
,      CUSTOMER_TRX_LINE_ID
,      FROM_ORGANIZATION_ID
,      TO_ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      MTL_TRANSACTION_ID
,      RCV_TRANSACTION_ID
,      ORDER_HEADER_ID
,      ORDER_LINE_ID
,      ORGANIZATION_ID
,      PARENT_MOVEMENT_ID
,      PICKING_LINE_DETAIL_ID
,      PICKING_LINE_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      REQUISITION_HEADER_ID
,      REQUISITION_LINE_ID
,      SHIPMENT_HEADER_ID
,      SHIPMENT_LINE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      ENTITY_ORG_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      TRANSACTION_HEADER_ID
FROM APPS.ECE_MVSTO_DETAILS_V;

Dependencies

[top of page]

APPS.ECE_MVSTO_DETAILS_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymMTL_MOVEMENT_STATISTICS

APPS.ECE_MVSTO_DETAILS_V is not referenced by any database object