eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.INVBV_MOVEMENT_STATISTICS

Object Details

Object Name:	INVBV_MOVEMENT_STATISTICS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INV.INVBV_MOVEMENT_STATISTICS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This shows movement statistics of dispatches, dispatch adjustments, arrivals, and arrival adjustments.

[View Source]

Columns

Name	Datatype	Length	Mandatory
MOVEMENT_ID	NUMBER		Yes
ORGANIZATION_ID	NUMBER		Yes
_LA:MOVEMENT_STATUS	CHAR	(56)
_LA:MOVEMENT_TYPE	CHAR	(59)
_LA:DOCUMENT_SOURCE_TYPE	CHAR	(74)
ENTITY_ORGANIZATION_ID	NUMBER		Yes
TRANSACTION_DATE	DATE		Yes
BILL_TO_CUSTOMER_ID	NUMBER
BILL_TO_SITE_USE_ID	NUMBER
INVOICE_BATCH_ID	NUMBER
INVOICE_ID	NUMBER
CUSTOMER_TRX_LINE_ID	NUMBER
FROM_ORGANIZATION_ID	NUMBER
TO_ORGANIZATION_ID	NUMBER
VENDOR_ID	NUMBER
VENDOR	VARCHAR2	(240)
VENDOR_NUMBER	VARCHAR2	(50)
VENDOR_SITE_ID	NUMBER
VENDOR_SITE	VARCHAR2	(50)
CUSTOMER	VARCHAR2	(240)
CUSTOMER_NUMBER	VARCHAR2	(50)
CUSTOMER_LOCATION	VARCHAR2	(50)
PO_HEADER_ID	NUMBER
PO_LINE_ID	NUMBER
PO_LINE_LOCATION_ID	NUMBER
ORDER_HEADER_ID	NUMBER
ORDER_LINE_ID	NUMBER
REQUISITION_HEADER_ID	NUMBER
REQUISITION_LINE_ID	NUMBER
PICKING_LINE_ID	NUMBER
PICKING_LINE_DETAIL_ID	NUMBER
SHIPMENT_HEADER_ID	NUMBER
SHIPMENT_LINE_ID	NUMBER
SHIP_TO_CUSTOMER_ID	NUMBER
SHIP_TO_SITE_USE_ID	NUMBER
DOCUMENT_REFERENCE	VARCHAR2	(50)
DOCUMENT_LINE_REFERENCE	VARCHAR2	(30)
SHIPMENT_REFERENCE	VARCHAR2	(50)
SHIPMENT_LINE_REFERENCE	VARCHAR2	(30)
PICK_SLIP_REFERENCE	VARCHAR2	(50)
RECEIPT_REFERENCE	VARCHAR2	(50)
TRANSACTING_FROM_ORG	VARCHAR2	(50)
TRANSACTING_TO_ORG	VARCHAR2	(50)
INVOICE_BATCH_REFERENCE	VARCHAR2	(50)
INVOICE_REFERENCE	VARCHAR2	(50)
INVOICE_LINE_REFERENCE	VARCHAR2	(30)
PARENT_MOVEMENT_ID	NUMBER		Yes
CURRENCY_CODE	VARCHAR2	(15)
INVENTORY_ITEM_ID	NUMBER
ITEM_DESCRIPTION	VARCHAR2	(240)
ITEM_COST	NUMBER
TRANSACTION_UOM_CODE	VARCHAR2	(3)
CATEGORY_ID	NUMBER
COMMODITY_CODE	VARCHAR2	(240)
COMMODITY_DESCRIPTION	VARCHAR2	(240)
TRANSACTION_QUANTITY	NUMBER
PRIMARY_QUANTITY	NUMBER
DOCUMENT_UNIT_PRICE	NUMBER
DOCUMENT_LINE_EXT_VALUE	NUMBER
_LA:TRANSACTION_NATURE	CHAR	(69)
_LA:DELIVERY_TERMS	CHAR	(61)
_LA:TRANSPORT_MODE	CHAR	(61)
_LA:PORT	CHAR	(41)
_LA:AREA	CHAR	(41)
_LA:STATISTICAL_TYPE	CHAR	(58)
WEIGHT_METHOD	VARCHAR2	(30)
UNIT_WEIGHT	NUMBER
TOTAL_WEIGHT	NUMBER
STATISTICAL_METHOD	VARCHAR2	(30)
STATISTICAL_ADJ_PERCENT	NUMBER
STATISTICAL_ADJ_AMOUNT	NUMBER
STATISTICAL_EXT_VALUE	NUMBER
COMMENTS	VARCHAR2	(240)
ALTERNATE_QUANTITY	NUMBER
ALTERNATE_UOM_CODE	VARCHAR2	(3)
_LA:OUTSIDE_CODE	CHAR	(57)
DISPATCH_TERRITORY_CODE	VARCHAR2	(2)
DESTINATION_TERRITORY_CODE	VARCHAR2	(2)
ORIGIN_TERRITORY_CODE	VARCHAR2	(2)
OUTSIDE_UNIT_PRICE	NUMBER
OUTSIDE_EXT_VALUE	NUMBER
REPORT_REFERENCE	VARCHAR2	(200)
PERIOD_NAME	VARCHAR2	(15)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes

Query Text

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


SELECT MOVEMENT_ID
,      ORGANIZATION_ID
,      _LA:MOVEMENT_STATUS
,      _LA:MOVEMENT_TYPE
,      _LA:DOCUMENT_SOURCE_TYPE
,      ENTITY_ORGANIZATION_ID
,      TRANSACTION_DATE
,      BILL_TO_CUSTOMER_ID
,      BILL_TO_SITE_USE_ID
,      INVOICE_BATCH_ID
,      INVOICE_ID
,      CUSTOMER_TRX_LINE_ID
,      FROM_ORGANIZATION_ID
,      TO_ORGANIZATION_ID
,      VENDOR_ID
,      VENDOR
,      VENDOR_NUMBER
,      VENDOR_SITE_ID
,      VENDOR_SITE
,      CUSTOMER
,      CUSTOMER_NUMBER
,      CUSTOMER_LOCATION
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      ORDER_HEADER_ID
,      ORDER_LINE_ID
,      REQUISITION_HEADER_ID
,      REQUISITION_LINE_ID
,      PICKING_LINE_ID
,      PICKING_LINE_DETAIL_ID
,      SHIPMENT_HEADER_ID
,      SHIPMENT_LINE_ID
,      SHIP_TO_CUSTOMER_ID
,      SHIP_TO_SITE_USE_ID
,      DOCUMENT_REFERENCE
,      DOCUMENT_LINE_REFERENCE
,      SHIPMENT_REFERENCE
,      SHIPMENT_LINE_REFERENCE
,      PICK_SLIP_REFERENCE
,      RECEIPT_REFERENCE
,      TRANSACTING_FROM_ORG
,      TRANSACTING_TO_ORG
,      INVOICE_BATCH_REFERENCE
,      INVOICE_REFERENCE
,      INVOICE_LINE_REFERENCE
,      PARENT_MOVEMENT_ID
,      CURRENCY_CODE
,      INVENTORY_ITEM_ID
,      ITEM_DESCRIPTION
,      ITEM_COST
,      TRANSACTION_UOM_CODE
,      CATEGORY_ID
,      COMMODITY_CODE
,      COMMODITY_DESCRIPTION
,      TRANSACTION_QUANTITY
,      PRIMARY_QUANTITY
,      DOCUMENT_UNIT_PRICE
,      DOCUMENT_LINE_EXT_VALUE
,      _LA:TRANSACTION_NATURE
,      _LA:DELIVERY_TERMS
,      _LA:TRANSPORT_MODE
,      _LA:PORT
,      _LA:AREA
,      _LA:STATISTICAL_TYPE
,      WEIGHT_METHOD
,      UNIT_WEIGHT
,      TOTAL_WEIGHT
,      STATISTICAL_METHOD
,      STATISTICAL_ADJ_PERCENT
,      STATISTICAL_ADJ_AMOUNT
,      STATISTICAL_EXT_VALUE
,      COMMENTS
,      ALTERNATE_QUANTITY
,      ALTERNATE_UOM_CODE
,      _LA:OUTSIDE_CODE
,      DISPATCH_TERRITORY_CODE
,      DESTINATION_TERRITORY_CODE
,      ORIGIN_TERRITORY_CODE
,      OUTSIDE_UNIT_PRICE
,      OUTSIDE_EXT_VALUE
,      REPORT_REFERENCE
,      PERIOD_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.INVBV_MOVEMENT_STATISTICS;

Dependencies

[top of page]

APPS.INVBV_MOVEMENT_STATISTICS references the following:

APPS: MTL_MOVEMENT_STATISTICS

APPS.INVBV_MOVEMENT_STATISTICS is not referenced by any database object