Skip to content

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

VIEW: EC.ECE_MVSTO_DETAILS#

Object Details
Object Name: ECE_MVSTO_DETAILS#
Object Type: VIEW
Owner: EC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
EDI_SENT_FLAG VARCHAR2 (1)
PERIOD_NAME VARCHAR2 (15)
EDI_TRANSACTION_REFERENCE VARCHAR2 (35)
EDI_TRANSACTION_DATE DATE

TRANSACTION_DATE DATE

SET_OF_BOOKS_PERIOD VARCHAR2 (15)
CREATION_METHOD VARCHAR2 (30)
CREATION_METHOD_EXT1 VARCHAR2 (30)
CREATION_METHOD_EXT2 VARCHAR2 (30)
CREATION_METHOD_EXT3 VARCHAR2 (30)
CREATION_METHOD_EXT4 VARCHAR2 (30)
CREATION_METHOD_EXT5 VARCHAR2 (30)
FLOW_INDICATOR_CODE VARCHAR2 (30)
FLOW_INDICATOR_CODE_EXT1 VARCHAR2 (50)
FLOW_INDICATOR_CODE_EXT2 VARCHAR2 (30)
FLOW_INDICATOR_CODE_EXT3 VARCHAR2 (30)
FLOW_INDICATOR_CODE_EXT4 VARCHAR2 (30)
FLOW_INDICATOR_CODE_EXT5 VARCHAR2 (30)
STAT_METHOD VARCHAR2 (30)
STAT_METHOD_EXT1 VARCHAR2 (30)
STAT_METHOD_EXT2 VARCHAR2 (30)
STAT_METHOD_EXT3 VARCHAR2 (30)
STAT_METHOD_EXT4 VARCHAR2 (30)
STAT_METHOD_EXT5 VARCHAR2 (30)
STAT_TYPE VARCHAR2 (30)
STAT_TYPE_EXT1 VARCHAR2 (30)
STAT_TYPE_EXT2 VARCHAR2 (30)
STAT_TYPE_EXT3 VARCHAR2 (30)
STAT_TYPE_EXT4 VARCHAR2 (30)
STAT_TYPE_EXT5 VARCHAR2 (30)
TRANSPORT_MODE VARCHAR2 (30)
TRANSPORT_MODE_EXT1 VARCHAR2 (30)
TRANSPORT_MODE_EXT2 VARCHAR2 (30)
TRANSPORT_MODE_EXT3 VARCHAR2 (30)
TRANSPORT_MODE_EXT4 VARCHAR2 (30)
TRANSPORT_MODE_EXT5 VARCHAR2 (30)
TRANSACTION_NATURE VARCHAR2 (30)
TRANSACTION_NATURE_EXT1 VARCHAR2 (30)
TRANSACTION_NATURE_EXT2 VARCHAR2 (30)
TRANSACTION_NATURE_EXT3 VARCHAR2 (30)
TRANSACTION_NATURE_EXT4 VARCHAR2 (30)
TRANSACTION_NATURE_EXT5 VARCHAR2 (30)
MOVEMENT_NATURE_CODE VARCHAR2 (30)
MOVEMENT_NATURE_CODE_EXT1 VARCHAR2 (30)
MOVEMENT_NATURE_CODE_EXT2 VARCHAR2 (30)
MOVEMENT_NATURE_CODE_EXT3 VARCHAR2 (30)
MOVEMENT_NATURE_CODE_EXT4 VARCHAR2 (30)
MOVEMENT_NATURE_CODE_EXT5 VARCHAR2 (30)
ORIGIN_TERRITORY_EU_CODE VARCHAR2 (3)
ORIGIN_TERRITORY_CODE VARCHAR2 (2)
ORIGIN_TERRITORY_CODE_EXT1 VARCHAR2 (2)
ORIGIN_TERRITORY_CODE_EXT2 VARCHAR2 (30)
ORIGIN_TERRITORY_CODE_EXT3 VARCHAR2 (30)
ORIGIN_TERRITORY_CODE_EXT4 VARCHAR2 (30)
ORIGIN_TERRITORY_CODE_EXT5 VARCHAR2 (30)
DESTINATION_TERRITORY_EU_CODE VARCHAR2 (3)
DESTINATION_TERRITORY_CODE VARCHAR2 (2)
DEST_TERRITORY_CODE_EXT1 VARCHAR2 (2)
DEST_TERRITORY_CODE_EXT2 VARCHAR2 (30)
DEST_TERRITORY_CODE_EXT3 VARCHAR2 (30)
DEST_TERRITORY_CODE_EXT4 VARCHAR2 (30)
DEST_TERRITORY_CODE_EXT5 VARCHAR2 (30)
DISPATCH_TERRITORY_EU_CODE VARCHAR2 (3)
DISPATCH_TERRITORY_CODE VARCHAR2 (2)
DISPATCH_TERRITORY_CODE_EXT1 VARCHAR2 (2)
DISPATCH_TERRITORY_CODE_EXT2 VARCHAR2 (30)
DISPATCH_TERRITORY_CODE_EXT3 VARCHAR2 (30)
DISPATCH_TERRITORY_CODE_EXT4 VARCHAR2 (30)
DISPATCH_TERRITORY_CODE_EXT5 VARCHAR2 (30)
TRIANGULATION_COUNTRY_EU_CODE VARCHAR2 (30)
TRIANGULATION_COUNTRY_CODE VARCHAR2 (30)
TRIANG_COUNTRY_CODE_EXT1 VARCHAR2 (30)
TRIANG_COUNTRY_CODE_EXT2 VARCHAR2 (30)
TRIANG_COUNTRY_CODE_EXT3 VARCHAR2 (30)
TRIANG_COUNTRY_CODE_EXT4 VARCHAR2 (30)
TRIANG_COUNTRY_CODE_EXT5 VARCHAR2 (30)
PORT VARCHAR2 (30)
PORT_EXT1 VARCHAR2 (30)
PORT_EXT2 VARCHAR2 (30)
PORT_EXT3 VARCHAR2 (30)
PORT_EXT4 VARCHAR2 (30)
PORT_EXT5 VARCHAR2 (30)
AREA VARCHAR2 (30)
AREA_EXT1 VARCHAR2 (30)
AREA_EXT2 VARCHAR2 (30)
AREA_EXT3 VARCHAR2 (30)
AREA_EXT4 VARCHAR2 (30)
AREA_EXT5 VARCHAR2 (30)
MOVEMENT_ID NUMBER
Yes
MOVEMENT_TYPE VARCHAR2 (30)
MOVEMENT_TYPE_EXT1 VARCHAR2 (30)
MOVEMENT_TYPE_EXT2 VARCHAR2 (30)
MOVEMENT_TYPE_EXT3 VARCHAR2 (30)
MOVEMENT_TYPE_EXT4 VARCHAR2 (30)
MOVEMENT_TYPE_EXT5 VARCHAR2 (30)
ZONE_CODE VARCHAR2 (10)
ECONOMIC_ZONE_EXT1 VARCHAR2 (10)
ECONOMIC_ZONE_EXT2 VARCHAR2 (30)
ECONOMIC_ZONE_EXT3 VARCHAR2 (30)
ECONOMIC_ZONE_EXT4 VARCHAR2 (30)
ECONOMIC_ZONE_EXT5 VARCHAR2 (30)
CURRENCY_CODE VARCHAR2 (15)
CURRENCY_CODE_EXT1 VARCHAR2 (30)
CURRENCY_CODE_EXT2 VARCHAR2 (30)
CURRENCY_CODE_EXT3 VARCHAR2 (30)
CURRENCY_CODE_EXT4 VARCHAR2 (30)
CURRENCY_CODE_EXT5 VARCHAR2 (30)
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_CONVERSION_TYPE_EXT1 VARCHAR2 (30)
CURRENCY_CONVERSION_TYPE_EXT2 VARCHAR2 (30)
CURRENCY_CONVERSION_TYPE_EXT3 VARCHAR2 (30)
CURRENCY_CONVERSION_TYPE_EXT4 VARCHAR2 (30)
CURRENCY_CONVERSION_TYPE_EXT5 VARCHAR2 (30)
CURRENCY_CONVERSION_DATE DATE

CURRENCY_CONVERSION_RATE NUMBER

MOVEMENT_AMOUNT NUMBER

ITEM_COST NUMBER

DOCUMENT_UNIT_PRICE NUMBER

DOCUMENT_LINE_EXT_VALUE NUMBER

OUTSIDE_CODE VARCHAR2 (30)
OUTSIDE_CODE_EXT1 VARCHAR2 (30)
OUTSIDE_CODE_EXT2 VARCHAR2 (30)
OUTSIDE_CODE_EXT3 VARCHAR2 (30)
OUTSIDE_CODE_EXT4 VARCHAR2 (30)
OUTSIDE_CODE_EXT5 VARCHAR2 (30)
OUTSIDE_EXT_VALUE NUMBER

OUTSIDE_UNIT_PRICE NUMBER

STAT_ADJ_AMOUNT NUMBER

STAT_ADJ_PERCENT NUMBER

STAT_EXT_VALUE NUMBER

DELIVERY_TERMS VARCHAR2 (30)
DELIVERY_TERMS_EXT1 VARCHAR2 (30)
DELIVERY_TERMS_EXT2 VARCHAR2 (30)
DELIVERY_TERMS_EXT3 VARCHAR2 (30)
DELIVERY_TERMS_EXT4 VARCHAR2 (30)
DELIVERY_TERMS_EXT5 VARCHAR2 (30)
PRIMARY_QUANTITY NUMBER

TRANSACTION_QUANTITY NUMBER

TRANSACTION_UOM_CODE VARCHAR2 (3)
TRANSACTION_UOM_CODE_EXT1 VARCHAR2 (3)
TRANSACTION_UOM_CODE_EXT2 VARCHAR2 (30)
TRANSACTION_UOM_CODE_EXT3 VARCHAR2 (30)
TRANSACTION_UOM_CODE_EXT4 VARCHAR2 (30)
TRANSACTION_UOM_CODE_EXT5 VARCHAR2 (30)
WEIGHT_METHOD VARCHAR2 (30)
WEIGHT_METHOD_EXT1 VARCHAR2 (30)
WEIGHT_METHOD_EXT2 VARCHAR2 (30)
WEIGHT_METHOD_EXT3 VARCHAR2 (30)
WEIGHT_METHOD_EXT4 VARCHAR2 (30)
WEIGHT_METHOD_EXT5 VARCHAR2 (30)
UNIT_WEIGHT NUMBER

TOTAL_WEIGHT NUMBER

TOTAL_WEIGHT_UOM_CODE VARCHAR2 (3)
TOTAL_WEIGHT_UOM_CODE_EXT1 VARCHAR2 (30)
TOTAL_WEIGHT_UOM_CODE_EXT2 VARCHAR2 (30)
TOTAL_WEIGHT_UOM_CODE_EXT3 VARCHAR2 (30)
TOTAL_WEIGHT_UOM_CODE_EXT4 VARCHAR2 (30)
TOTAL_WEIGHT_UOM_CODE_EXT5 VARCHAR2 (30)
ALTERNATE_QUANTITY NUMBER

ALTERNATE_UOM_CODE VARCHAR2 (3)
ALTERNATE_UOM_CODE_EXT1 VARCHAR2 (3)
ALTERNATE_UOM_CODE_EXT2 VARCHAR2 (30)
ALTERNATE_UOM_CODE_EXT3 VARCHAR2 (30)
ALTERNATE_UOM_CODE_EXT4 VARCHAR2 (30)
ALTERNATE_UOM_CODE_EXT5 VARCHAR2 (30)
COMMODITY_CODE VARCHAR2 (240)
COMMODITY_DESCRIPTION VARCHAR2 (240)
COMMENTS VARCHAR2 (240)
ITEM_DESCRIPTION VARCHAR2 (240)
DOCUMENT_SOURCE_TYPE VARCHAR2 (30)
DOCUMENT_REFERENCE VARCHAR2 (50)
DOCUMENT_LINE_REFERENCE VARCHAR2 (30)
TRANSACTING_FROM_ORG VARCHAR2 (50)
TRANSACTING_TO_ORG VARCHAR2 (50)
DISTRIBUTION_LINE_NUMBER NUMBER

AFFILIATION_REFERENCE_CODE VARCHAR2 (30)
AFFILIATION_REF_CODE_EXT1 VARCHAR2 (30)
AFFILIATION_REF_CODE_EXT2 VARCHAR2 (30)
AFFILIATION_REF_CODE_EXT3 VARCHAR2 (30)
AFFILIATION_REF_CODE_EXT4 VARCHAR2 (30)
AFFILIATION_REF_CODE_EXT5 VARCHAR2 (30)
CONTAINER_TYPE_CODE VARCHAR2 (30)
CONTAINER_TYPE_CODE_EXT1 VARCHAR2 (30)
CONTAINER_TYPE_CODE_EXT2 VARCHAR2 (30)
CONTAINER_TYPE_CODE_EXT3 VARCHAR2 (30)
CONTAINER_TYPE_CODE_EXT4 VARCHAR2 (30)
CONTAINER_TYPE_CODE_EXT5 VARCHAR2 (30)
CSA_CODE VARCHAR2 (30)
CSA_CODE_EXT1 VARCHAR2 (30)
CSA_CODE_EXT2 VARCHAR2 (30)
CSA_CODE_EXT3 VARCHAR2 (30)
CSA_CODE_EXT4 VARCHAR2 (30)
CSA_CODE_EXT5 VARCHAR2 (30)
OIL_REFERENCE_CODE VARCHAR2 (30)
OIL_REFERENCE_CODE_EXT1 VARCHAR2 (50)
OIL_REFERENCE_CODE_EXT2 VARCHAR2 (50)
OIL_REFERENCE_CODE_EXT3 VARCHAR2 (50)
OIL_REFERENCE_CODE_EXT4 VARCHAR2 (50)
OIL_REFERENCE_CODE_EXT5 VARCHAR2 (50)
PICK_SLIP_REFERENCE VARCHAR2 (50)
PREFERENCE_CODE VARCHAR2 (30)
PREFERENCE_CODE_EXT1 VARCHAR2 (50)
PREFERENCE_CODE_EXT2 VARCHAR2 (50)
PREFERENCE_CODE_EXT3 VARCHAR2 (50)
PREFERENCE_CODE_EXT4 VARCHAR2 (50)
PREFERENCE_CODE_EXT5 VARCHAR2 (50)
RECEIPT_REFERENCE VARCHAR2 (50)
RECEIPT_REFERENCE_EXT1 VARCHAR2 (50)
RECEIPT_REFERENCE_EXT2 VARCHAR2 (50)
RECEIPT_REFERENCE_EXT3 VARCHAR2 (50)
RECEIPT_REFERENCE_EXT4 VARCHAR2 (50)
RECEIPT_REFERENCE_EXT5 VARCHAR2 (50)
SHIPMENT_LINE_REFERENCE VARCHAR2 (30)
SHIPMENT_LINE_REFERENCE_EXT1 VARCHAR2 (30)
SHIPMENT_LINE_REFERENCE_EXT2 VARCHAR2 (30)
SHIPMENT_LINE_REFERENCE_EXT3 VARCHAR2 (30)
SHIPMENT_LINE_REFERENCE_EXT4 VARCHAR2 (30)
SHIPMENT_LINE_REFERENCE_EXT5 VARCHAR2 (30)
SHIPMENT_REFERENCE VARCHAR2 (50)
SHIPMENT_REFERENCE_EXT1 VARCHAR2 (50)
SHIPMENT_REFERENCE_EXT2 VARCHAR2 (50)
SHIPMENT_REFERENCE_EXT3 VARCHAR2 (50)
SHIPMENT_REFERENCE_EXT4 VARCHAR2 (50)
SHIPMENT_REFERENCE_EXT5 VARCHAR2 (50)
TARIC_CODE VARCHAR2 (30)
TARIC_CODE_EXT1 VARCHAR2 (30)
TARIC_CODE_EXT2 VARCHAR2 (30)
TARIC_CODE_EXT3 VARCHAR2 (30)
TARIC_CODE_EXT4 VARCHAR2 (30)
TARIC_CODE_EXT5 VARCHAR2 (30)
INVOICE_BATCH_REFERENCE VARCHAR2 (50)
INVOICE_DATE_REFERENCE DATE

INVOICE_LINE_EXT_VALUE NUMBER

INVOICE_LINE_REFERENCE VARCHAR2 (30)
INVOICE_QUANTITY NUMBER

INVOICE_REFERENCE VARCHAR2 (50)
INVOICE_UNIT_PRICE NUMBER

INVOICE_BATCH_ID NUMBER

INVOICE_ID NUMBER

CUSTOMER_LOCATION VARCHAR2 (50)
CUSTOMER_NAME VARCHAR2 (240)
CUSTOMER_NUMBER VARCHAR2 (50)
BILL_TO_NAME VARCHAR2 (240)
BILL_TO_NUMBER VARCHAR2 (50)
BILL_TO_SITE VARCHAR2 (50)
SHIP_TO_NAME VARCHAR2 (240)
SHIP_TO_NUMBER VARCHAR2 (50)
SHIP_TO_SITE VARCHAR2 (50)
BILL_TO_CUSTOMER_ID NUMBER

BILL_TO_SITE_USE_ID NUMBER

SHIP_TO_CUSTOMER_ID NUMBER

SHIP_TO_SITE_USE_ID NUMBER

VENDOR_NAME VARCHAR2 (240)
VENDOR_NUMBER VARCHAR2 (50)
VENDOR_SITE VARCHAR2 (50)
VENDOR_ID NUMBER

VENDOR_SITE_ID NUMBER

CATEGORY_ID NUMBER

CUSTOMER_TRX_LINE_ID NUMBER

FROM_ORGANIZATION_ID NUMBER

TO_ORGANIZATION_ID NUMBER

INVENTORY_ITEM_ID NUMBER

MTL_TRANSACTION_ID NUMBER

RCV_TRANSACTION_ID NUMBER

ORDER_HEADER_ID NUMBER

ORDER_LINE_ID NUMBER

ORGANIZATION_ID NUMBER

PARENT_MOVEMENT_ID NUMBER

PICKING_LINE_DETAIL_ID NUMBER

PICKING_LINE_ID NUMBER

PO_HEADER_ID NUMBER

PO_LINE_ID NUMBER

PO_LINE_LOCATION_ID NUMBER

REQUISITION_HEADER_ID NUMBER

REQUISITION_LINE_ID NUMBER

SHIPMENT_HEADER_ID NUMBER

SHIPMENT_LINE_ID NUMBER

CREATED_BY NUMBER

CREATION_DATE DATE

LAST_UPDATE_LOGIN NUMBER

LAST_UPDATED_BY NUMBER

LAST_UPDATE_DATE DATE

ENTITY_ORG_ID NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
TRANSACTION_RECORD_ID NUMBER
Yes
TRANSACTION_HEADER_ID NUMBER
Yes
RUN_ID NUMBER

SECURITY_GROUP_ID NUMBER

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
,      CREATION_METHOD_EXT1
,      CREATION_METHOD_EXT2
,      CREATION_METHOD_EXT3
,      CREATION_METHOD_EXT4
,      CREATION_METHOD_EXT5
,      FLOW_INDICATOR_CODE
,      FLOW_INDICATOR_CODE_EXT1
,      FLOW_INDICATOR_CODE_EXT2
,      FLOW_INDICATOR_CODE_EXT3
,      FLOW_INDICATOR_CODE_EXT4
,      FLOW_INDICATOR_CODE_EXT5
,      STAT_METHOD
,      STAT_METHOD_EXT1
,      STAT_METHOD_EXT2
,      STAT_METHOD_EXT3
,      STAT_METHOD_EXT4
,      STAT_METHOD_EXT5
,      STAT_TYPE
,      STAT_TYPE_EXT1
,      STAT_TYPE_EXT2
,      STAT_TYPE_EXT3
,      STAT_TYPE_EXT4
,      STAT_TYPE_EXT5
,      TRANSPORT_MODE
,      TRANSPORT_MODE_EXT1
,      TRANSPORT_MODE_EXT2
,      TRANSPORT_MODE_EXT3
,      TRANSPORT_MODE_EXT4
,      TRANSPORT_MODE_EXT5
,      TRANSACTION_NATURE
,      TRANSACTION_NATURE_EXT1
,      TRANSACTION_NATURE_EXT2
,      TRANSACTION_NATURE_EXT3
,      TRANSACTION_NATURE_EXT4
,      TRANSACTION_NATURE_EXT5
,      MOVEMENT_NATURE_CODE
,      MOVEMENT_NATURE_CODE_EXT1
,      MOVEMENT_NATURE_CODE_EXT2
,      MOVEMENT_NATURE_CODE_EXT3
,      MOVEMENT_NATURE_CODE_EXT4
,      MOVEMENT_NATURE_CODE_EXT5
,      ORIGIN_TERRITORY_EU_CODE
,      ORIGIN_TERRITORY_CODE
,      ORIGIN_TERRITORY_CODE_EXT1
,      ORIGIN_TERRITORY_CODE_EXT2
,      ORIGIN_TERRITORY_CODE_EXT3
,      ORIGIN_TERRITORY_CODE_EXT4
,      ORIGIN_TERRITORY_CODE_EXT5
,      DESTINATION_TERRITORY_EU_CODE
,      DESTINATION_TERRITORY_CODE
,      DEST_TERRITORY_CODE_EXT1
,      DEST_TERRITORY_CODE_EXT2
,      DEST_TERRITORY_CODE_EXT3
,      DEST_TERRITORY_CODE_EXT4
,      DEST_TERRITORY_CODE_EXT5
,      DISPATCH_TERRITORY_EU_CODE
,      DISPATCH_TERRITORY_CODE
,      DISPATCH_TERRITORY_CODE_EXT1
,      DISPATCH_TERRITORY_CODE_EXT2
,      DISPATCH_TERRITORY_CODE_EXT3
,      DISPATCH_TERRITORY_CODE_EXT4
,      DISPATCH_TERRITORY_CODE_EXT5
,      TRIANGULATION_COUNTRY_EU_CODE
,      TRIANGULATION_COUNTRY_CODE
,      TRIANG_COUNTRY_CODE_EXT1
,      TRIANG_COUNTRY_CODE_EXT2
,      TRIANG_COUNTRY_CODE_EXT3
,      TRIANG_COUNTRY_CODE_EXT4
,      TRIANG_COUNTRY_CODE_EXT5
,      PORT
,      PORT_EXT1
,      PORT_EXT2
,      PORT_EXT3
,      PORT_EXT4
,      PORT_EXT5
,      AREA
,      AREA_EXT1
,      AREA_EXT2
,      AREA_EXT3
,      AREA_EXT4
,      AREA_EXT5
,      MOVEMENT_ID
,      MOVEMENT_TYPE
,      MOVEMENT_TYPE_EXT1
,      MOVEMENT_TYPE_EXT2
,      MOVEMENT_TYPE_EXT3
,      MOVEMENT_TYPE_EXT4
,      MOVEMENT_TYPE_EXT5
,      ZONE_CODE
,      ECONOMIC_ZONE_EXT1
,      ECONOMIC_ZONE_EXT2
,      ECONOMIC_ZONE_EXT3
,      ECONOMIC_ZONE_EXT4
,      ECONOMIC_ZONE_EXT5
,      CURRENCY_CODE
,      CURRENCY_CODE_EXT1
,      CURRENCY_CODE_EXT2
,      CURRENCY_CODE_EXT3
,      CURRENCY_CODE_EXT4
,      CURRENCY_CODE_EXT5
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_TYPE_EXT1
,      CURRENCY_CONVERSION_TYPE_EXT2
,      CURRENCY_CONVERSION_TYPE_EXT3
,      CURRENCY_CONVERSION_TYPE_EXT4
,      CURRENCY_CONVERSION_TYPE_EXT5
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      MOVEMENT_AMOUNT
,      ITEM_COST
,      DOCUMENT_UNIT_PRICE
,      DOCUMENT_LINE_EXT_VALUE
,      OUTSIDE_CODE
,      OUTSIDE_CODE_EXT1
,      OUTSIDE_CODE_EXT2
,      OUTSIDE_CODE_EXT3
,      OUTSIDE_CODE_EXT4
,      OUTSIDE_CODE_EXT5
,      OUTSIDE_EXT_VALUE
,      OUTSIDE_UNIT_PRICE
,      STAT_ADJ_AMOUNT
,      STAT_ADJ_PERCENT
,      STAT_EXT_VALUE
,      DELIVERY_TERMS
,      DELIVERY_TERMS_EXT1
,      DELIVERY_TERMS_EXT2
,      DELIVERY_TERMS_EXT3
,      DELIVERY_TERMS_EXT4
,      DELIVERY_TERMS_EXT5
,      PRIMARY_QUANTITY
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM_CODE
,      TRANSACTION_UOM_CODE_EXT1
,      TRANSACTION_UOM_CODE_EXT2
,      TRANSACTION_UOM_CODE_EXT3
,      TRANSACTION_UOM_CODE_EXT4
,      TRANSACTION_UOM_CODE_EXT5
,      WEIGHT_METHOD
,      WEIGHT_METHOD_EXT1
,      WEIGHT_METHOD_EXT2
,      WEIGHT_METHOD_EXT3
,      WEIGHT_METHOD_EXT4
,      WEIGHT_METHOD_EXT5
,      UNIT_WEIGHT
,      TOTAL_WEIGHT
,      TOTAL_WEIGHT_UOM_CODE
,      TOTAL_WEIGHT_UOM_CODE_EXT1
,      TOTAL_WEIGHT_UOM_CODE_EXT2
,      TOTAL_WEIGHT_UOM_CODE_EXT3
,      TOTAL_WEIGHT_UOM_CODE_EXT4
,      TOTAL_WEIGHT_UOM_CODE_EXT5
,      ALTERNATE_QUANTITY
,      ALTERNATE_UOM_CODE
,      ALTERNATE_UOM_CODE_EXT1
,      ALTERNATE_UOM_CODE_EXT2
,      ALTERNATE_UOM_CODE_EXT3
,      ALTERNATE_UOM_CODE_EXT4
,      ALTERNATE_UOM_CODE_EXT5
,      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
,      AFFILIATION_REF_CODE_EXT1
,      AFFILIATION_REF_CODE_EXT2
,      AFFILIATION_REF_CODE_EXT3
,      AFFILIATION_REF_CODE_EXT4
,      AFFILIATION_REF_CODE_EXT5
,      CONTAINER_TYPE_CODE
,      CONTAINER_TYPE_CODE_EXT1
,      CONTAINER_TYPE_CODE_EXT2
,      CONTAINER_TYPE_CODE_EXT3
,      CONTAINER_TYPE_CODE_EXT4
,      CONTAINER_TYPE_CODE_EXT5
,      CSA_CODE
,      CSA_CODE_EXT1
,      CSA_CODE_EXT2
,      CSA_CODE_EXT3
,      CSA_CODE_EXT4
,      CSA_CODE_EXT5
,      OIL_REFERENCE_CODE
,      OIL_REFERENCE_CODE_EXT1
,      OIL_REFERENCE_CODE_EXT2
,      OIL_REFERENCE_CODE_EXT3
,      OIL_REFERENCE_CODE_EXT4
,      OIL_REFERENCE_CODE_EXT5
,      PICK_SLIP_REFERENCE
,      PREFERENCE_CODE
,      PREFERENCE_CODE_EXT1
,      PREFERENCE_CODE_EXT2
,      PREFERENCE_CODE_EXT3
,      PREFERENCE_CODE_EXT4
,      PREFERENCE_CODE_EXT5
,      RECEIPT_REFERENCE
,      RECEIPT_REFERENCE_EXT1
,      RECEIPT_REFERENCE_EXT2
,      RECEIPT_REFERENCE_EXT3
,      RECEIPT_REFERENCE_EXT4
,      RECEIPT_REFERENCE_EXT5
,      SHIPMENT_LINE_REFERENCE
,      SHIPMENT_LINE_REFERENCE_EXT1
,      SHIPMENT_LINE_REFERENCE_EXT2
,      SHIPMENT_LINE_REFERENCE_EXT3
,      SHIPMENT_LINE_REFERENCE_EXT4
,      SHIPMENT_LINE_REFERENCE_EXT5
,      SHIPMENT_REFERENCE
,      SHIPMENT_REFERENCE_EXT1
,      SHIPMENT_REFERENCE_EXT2
,      SHIPMENT_REFERENCE_EXT3
,      SHIPMENT_REFERENCE_EXT4
,      SHIPMENT_REFERENCE_EXT5
,      TARIC_CODE
,      TARIC_CODE_EXT1
,      TARIC_CODE_EXT2
,      TARIC_CODE_EXT3
,      TARIC_CODE_EXT4
,      TARIC_CODE_EXT5
,      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_RECORD_ID
,      TRANSACTION_HEADER_ID
,      RUN_ID
,      SECURITY_GROUP_ID
FROM EC.ECE_MVSTO_DETAILS#;

Dependencies

[top of page]

EC.ECE_MVSTO_DETAILS# references the following:

SchemaEC
TableECE_MVSTO_DETAILS
EC.ECE_MVSTO_DETAILS# is referenced by following:

SchemaAPPS
SynonymECE_MVSTO_DETAILS