View: ECE_MVSTO_DETAILS_V

Product:	EC - e-Commerce Gateway
Description:	This view extracts line informationfor the outbound Movement Statistics (INTRASTAT) transaction.@rep:scope private@rep:product INV@rep:lifecycle active@rep:displayname Movement Statistics Line View@rep:category BUSINESS_ENTITY INV_MOVEMENT_
Implementation/DBA Data:	APPS.ECE_MVSTO_DETAILS_V

View Text

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

Columns