[Home] [Help] [Dependency Information]
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 |
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.
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 |
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;
|
|
|