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.ECE_MTL_MOV_STAT_V

Object Details

Object Name:	ECE_MTL_MOV_STAT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EC.ECE_MTL_MOV_STAT_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

The ECE_MTL_MOV_STAT_V view contains customer order header data for the
delivery of a closed departure to support the outbound Movement Statistics transaction.
ECE_MTL_MOV_STAT_V is based primarily on data stored in MTL_MOVEMENT_STATISTICS
from Oracle Inventory and FND_LOOKUPS.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
MOVEMENT_TYPE	VARCHAR2	(30)	Yes	Movement Type
PERIOD_NAME	VARCHAR2	(15)		Period Name
EDI_TRANSACTION_REFERENCE	VARCHAR2	(35)		EDI Transaction Reference
EDI_TRANSACTION_DATE	DATE			EDI Transaction Date
REPORT_REFERENCE	VARCHAR2	(200)		Report Reference
REPORT_DATE	DATE			Report Date
STAT_TYPE	VARCHAR2	(30)		Statistics Type
USAGE_TYPE	VARCHAR2	(30)		Usage Type
MOVEMENT_STATUS	VARCHAR2	(30)	Yes	Movement Status
ZONE_CODE	VARCHAR2	(10)		Zone Code
ORGANIZATION_ID	NUMBER		Yes	Organization ID
ENTITY_ORG_ID	NUMBER		Yes	Entity Organization ID
TOTAL_INVOICE_EXT_VALUE	NUMBER			Total Invoice Value (Ext)
TOTAL_SUPPLEMENTARY_UNITS	NUMBER			Total Supplementary Units
TOTAL_STATISTICAL_VALUE	NUMBER			Total Statistical Value
TOTAL_TOTAL_WEIGHT	NUMBER			Total of Total Weight
TOTAL_RECORDS	NUMBER			Total no. of Records

Query Text

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


SELECT MOVEMENT_TYPE
,      PERIOD_NAME
,      EDI_TRANSACTION_REFERENCE
,      EDI_TRANSACTION_DATE
,      REPORT_REFERENCE
,      REPORT_DATE
,      STAT_TYPE
,      USAGE_TYPE
,      MOVEMENT_STATUS
,      ZONE_CODE
,      ORGANIZATION_ID
,      ENTITY_ORG_ID
,      TOTAL_INVOICE_EXT_VALUE
,      TOTAL_SUPPLEMENTARY_UNITS
,      TOTAL_STATISTICAL_VALUE
,      TOTAL_TOTAL_WEIGHT
,      TOTAL_RECORDS
FROM APPS.ECE_MTL_MOV_STAT_V;

Dependencies

[top of page]

APPS.ECE_MTL_MOV_STAT_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; MTL_MOVEMENT_STATISTICS

APPS.ECE_MTL_MOV_STAT_V is referenced by following:

APPS: ECE_MVSTO_HEADERS_V