View: INVBV_MOVEMENT_STATISTICS

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.INVBV_MOVEMENT_STATISTICS

View Text

SELECT MMS.MOVEMENT_ID
, MMS.ORGANIZATION_ID
, '_LA:MMS.MOVEMENT_STATUS:FND_LOOKUPS:MVT_STATUSES:MEANING'
, /* LOOKUP */ '_LA:MMS.MOVEMENT_TYPE:FND_LOOKUPS:MVT_MOVEMENT_TYPE:MEANING'
, /* LOOKUP */ '_LA:MMS.DOCUMENT_SOURCE_TYPE:FND_LOOKUPS:MVT_SOURCE_DOCUMENT_TYPES:MEANING'
, /* LOOKUP */ MMS.ENTITY_ORG_ID
, MMS.TRANSACTION_DATE
, /* BILL TO CUSTOMER */ MMS.BILL_TO_CUSTOMER_ID
, MMS.BILL_TO_SITE_USE_ID
, /* INVOICE */ MMS.INVOICE_BATCH_ID
, MMS.INVOICE_ID
, MMS.CUSTOMER_TRX_LINE_ID
, /* ORGANIZATIONS */ MMS.FROM_ORGANIZATION_ID
, MMS.TO_ORGANIZATION_ID
, /* VENDOR */ MMS.VENDOR_ID
, MMS.VENDOR_NAME
, MMS.VENDOR_NUMBER
, MMS.VENDOR_SITE_ID
, MMS.VENDOR_SITE
, /* CUSTOMER */ MMS.CUSTOMER_NAME
, MMS.CUSTOMER_NUMBER
, MMS.CUSTOMER_LOCATION
, /* PO */ MMS.PO_HEADER_ID
, MMS.PO_LINE_ID
, MMS.PO_LINE_LOCATION_ID
, /* SO */ MMS.ORDER_HEADER_ID
, MMS.ORDER_LINE_ID
, /* REQ */ MMS.REQUISITION_HEADER_ID
, MMS.REQUISITION_LINE_ID
, /* OTHERS */ MMS.PICKING_LINE_ID
, MMS.PICKING_LINE_DETAIL_ID
, MMS.SHIPMENT_HEADER_ID
, MMS.SHIPMENT_LINE_ID
, MMS.SHIP_TO_CUSTOMER_ID
, MMS.SHIP_TO_SITE_USE_ID
, MMS.DOCUMENT_REFERENCE
, MMS.DOCUMENT_LINE_REFERENCE
, MMS.SHIPMENT_REFERENCE
, MMS.SHIPMENT_LINE_REFERENCE
, MMS.PICK_SLIP_REFERENCE
, MMS.RECEIPT_REFERENCE
, MMS.TRANSACTING_FROM_ORG
, MMS.TRANSACTING_TO_ORG
, MMS.INVOICE_BATCH_REFERENCE
, MMS.INVOICE_REFERENCE
, MMS.INVOICE_LINE_REFERENCE
, MMS.PARENT_MOVEMENT_ID
, MMS.CURRENCY_CODE
, MMS.INVENTORY_ITEM_ID
, MMS.ITEM_DESCRIPTION
, MMS.ITEM_COST
, MMS.TRANSACTION_UOM_CODE
, MMS.CATEGORY_ID
, MMS.COMMODITY_CODE
, MMS.COMMODITY_DESCRIPTION
, MMS.TRANSACTION_QUANTITY
, MMS.PRIMARY_QUANTITY
, MMS.DOCUMENT_UNIT_PRICE
, MMS.DOCUMENT_LINE_EXT_VALUE
, '_LA:MMS.TRANSACTION_NATURE:FND_LOOKUPS:MVT_TRANSACTION_NATURE:MEANING'
, /* LOOKUP */ '_LA:MMS.DELIVERY_TERMS:FND_LOOKUPS:MVT_DELIVERY_TERMS:MEANING'
, /* LOOKUP */ '_LA:MMS.TRANSPORT_MODE:FND_LOOKUPS:MVT_TRANSPORT_MODE:MEANING'
, /* LOOKUP */ '_LA:MMS.PORT:FND_LOOKUPS:MVT_PORT:MEANING'
, /* LOOKUP */ '_LA:MMS.AREA:FND_LOOKUPS:MVT_AREA:MEANING'
, /* LOOKUP */ '_LA:MMS.STAT_TYPE:FND_LOOKUPS:MVT_STATISTICAL_TYPE:MEANING'
, /* LOOKUP */ MMS.WEIGHT_METHOD
, MMS.UNIT_WEIGHT
, MMS.TOTAL_WEIGHT
, MMS.STAT_METHOD
, MMS.STAT_ADJ_PERCENT
, MMS.STAT_ADJ_AMOUNT
, MMS.STAT_EXT_VALUE
, MMS.COMMENTS
, MMS.ALTERNATE_QUANTITY
, MMS.ALTERNATE_UOM_CODE
, '_LA:MMS.OUTSIDE_CODE:FND_LOOKUPS:MVT_OUTSIDE_CODE:MEANING'
, /* LOOKUP */MMS.DISPATCH_TERRITORY_CODE
, MMS.DESTINATION_TERRITORY_CODE
, MMS.ORIGIN_TERRITORY_CODE
, MMS.OUTSIDE_UNIT_PRICE
, MMS.OUTSIDE_EXT_VALUE
, MMS.REPORT_REFERENCE
, MMS.PERIOD_NAME
, MMS.LAST_UPDATE_DATE
, MMS.LAST_UPDATED_BY
, MMS.CREATION_DATE
, MMS.CREATED_BY
FROM MTL_MOVEMENT_STATISTICS MMS
WHERE '_SEC:MMS.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns