VIEW: INV.MTL_MOVEMENT_STATISTICS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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