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]

TABLE: EC.ECE_MVSTO_LOCATIONS

Object Details

Object Name:	ECE_MVSTO_LOCATIONS
Object Type:	TABLE
Owner:	EC
FND Design Data:	EC.ECE_MVSTO_LOCATIONS
Subobject Name:
Status:	VALID

ECE_MVSTO_LOCATIONS contains movement statistics
location data (BILL_TO, SHIP_TO and VENDOR codes,
names and addresses) to support the outbound Movement
Statistics transaction.

ECE_MVSTO_LOCATIONS is based primarily on data stored
in RA_ADDRESSES from Oracle Receivables.

All columns denoted with "Int" or "Internal" represent Oracle
Applications internal values. All columns denoted with "Ext"
or "External" represent the equivalent external values sourced
from the ECE_XREF_DATA table if code conversion is enabled
for the column.

TRANSACTION_RECORD_ID is the unique key that links the
ECE_MVSTO_LOCATIONS table to its corresponding extension
table ECE_MVSTO_LOCATIONS_X.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ECE_MVSTO_LOCATIONS_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	TRANSACTION_RECORD_ID TRANSACTION_HEADER_ID TRANSACTION_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BILL_TO_CODE_INTERNAL	VARCHAR2	(240)		Bill To Code (Internal)
BILL_TO_CODE_EXTERNAL	VARCHAR2	(35)		Bill To Code (Ext)
BILL_TO_NAME	VARCHAR2	(50)		Bill To Customer Name
BILL_TO_ADDRESS1	VARCHAR2	(240)		Bill To Address 1
BILL_TO_ADDRESS2	VARCHAR2	(240)		Bill To Address 2
BILL_TO_ADDRESS3	VARCHAR2	(240)		Bill To Address 3
BILL_TO_ADDRESS4	VARCHAR2	(240)		Bill To Address 4
BILL_TO_CITY	VARCHAR2	(60)		Bill To City
BILL_TO_POSTAL_CODE	VARCHAR2	(60)		Bill To Postal Code
BILL_TO_COUNTRY_INT	VARCHAR2	(60)		Bill To Country (Internal)
BILL_TO_COUNTRY_EXT	VARCHAR2	(80)		Bill To Country (Ext)
BILL_TO_STATE_INT	VARCHAR2	(60)		Bill To State (Internal)
BILL_TO_STATE_EXT	VARCHAR2	(80)		Bill To State (Ext)
BILL_TO_PROVINCE_INT	VARCHAR2	(60)		Bill To Province (Internal)
BILL_TO_PROVINCE_EXT	VARCHAR2	(80)		Bill To Province (Ext)
BILL_TO_COUNTY_INT	VARCHAR2	(60)		Bill To County
BILL_TO_ADDRESS_ID	NUMBER			Bill To Address ID
SHIP_TO_CODE_INTERNAL	VARCHAR2	(240)		Ship To Code (Internal)
SHIP_TO_CODE_EXTERNAL	VARCHAR2	(35)		Ship To Code (Ext)
SHIP_TO_NAME	VARCHAR2	(50)		Ship To Customer Name
SHIP_TO_ADDRESS1	VARCHAR2	(240)		Ship To Address 1
SHIP_TO_ADDRESS2	VARCHAR2	(240)		Ship To Address 2
SHIP_TO_ADDRESS3	VARCHAR2	(240)		Ship To Address 3
SHIP_TO_ADDRESS4	VARCHAR2	(240)		Ship To Address 4
SHIP_TO_CITY	VARCHAR2	(60)		Ship To City
SHIP_TO_POSTAL_CODE	VARCHAR2	(60)		Ship To Postal Code
SHIP_TO_COUNTRY_INT	VARCHAR2	(60)		Ship To Country (Internal)
SHIP_TO_COUNTRY_EXT	VARCHAR2	(80)		Ship To Country (Ext)
SHIP_TO_STATE_INT	VARCHAR2	(60)		Ship To State (Internal)
SHIP_TO_STATE_EXT	VARCHAR2	(80)		Ship To State (Ext)
SHIP_TO_PROVINCE_INT	VARCHAR2	(60)		Ship To Province (Internal)
SHIP_TO_PROVINCE_EXT	VARCHAR2	(80)		Ship To Province (Ext)
SHIP_TO_COUNTY_INT	VARCHAR2	(60)		Ship To County
SHIP_TO_ADDRESS_ID	NUMBER			Ship To Address ID
VENDOR_CODE_INT	VARCHAR2	(240)		Vendor Code (Internal)
VENDOR_CODE_EXT	VARCHAR2	(35)		Vendor Code (Ext)
VENDOR_CUSTOMER_NAME	VARCHAR2	(50)		Vendor Customer Name
VENDOR_ADDRESS1	VARCHAR2	(240)		Vendor Address 1
VENDOR_ADDRESS2	VARCHAR2	(240)		Vendor Address 2
VENDOR_ADDRESS3	VARCHAR2	(240)		Vendor Address 3
VENDOR_ADDRESS4	VARCHAR2	(240)		Vendor Address 4
VENDOR_CITY	VARCHAR2	(60)		Vendor City
VENDOR_POSTAL_CODE	VARCHAR2	(60)		Vendor Postal Code
VENDOR_COUNTRY_INT	VARCHAR2	(60)		Vendor Country (Internal)
VENDOR_COUNTRY_EXT1	VARCHAR2	(80)		Vendor Country (Ext)
VENDOR_STATE_INT	VARCHAR2	(60)		Vendor State (Internal)
VENDOR_STATE_EXT1	VARCHAR2	(80)		Vendor State (Ext)
VENDOR_PROVINCE_INT	VARCHAR2	(60)		Vendor Province (Internal)
VENDOR_PROVINCE_EXT1	VARCHAR2	(80)		Vendor Province (Ext)
VENDOR_COUNTY	VARCHAR2	(60)		Vendor County
TRANSACTION_RECORD_ID	NUMBER		Yes	Transaction Record ID
TRANSACTION_HEADER_ID	NUMBER		Yes	Transaction Header ID
TRANSACTION_LINE_ID	NUMBER		Yes	Transaction Line ID
RUN_ID	NUMBER			Transaction Run ID
SECURITY_GROUP_ID	NUMBER

Query Text

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


SELECT BILL_TO_CODE_INTERNAL
,      BILL_TO_CODE_EXTERNAL
,      BILL_TO_NAME
,      BILL_TO_ADDRESS1
,      BILL_TO_ADDRESS2
,      BILL_TO_ADDRESS3
,      BILL_TO_ADDRESS4
,      BILL_TO_CITY
,      BILL_TO_POSTAL_CODE
,      BILL_TO_COUNTRY_INT
,      BILL_TO_COUNTRY_EXT
,      BILL_TO_STATE_INT
,      BILL_TO_STATE_EXT
,      BILL_TO_PROVINCE_INT
,      BILL_TO_PROVINCE_EXT
,      BILL_TO_COUNTY_INT
,      BILL_TO_ADDRESS_ID
,      SHIP_TO_CODE_INTERNAL
,      SHIP_TO_CODE_EXTERNAL
,      SHIP_TO_NAME
,      SHIP_TO_ADDRESS1
,      SHIP_TO_ADDRESS2
,      SHIP_TO_ADDRESS3
,      SHIP_TO_ADDRESS4
,      SHIP_TO_CITY
,      SHIP_TO_POSTAL_CODE
,      SHIP_TO_COUNTRY_INT
,      SHIP_TO_COUNTRY_EXT
,      SHIP_TO_STATE_INT
,      SHIP_TO_STATE_EXT
,      SHIP_TO_PROVINCE_INT
,      SHIP_TO_PROVINCE_EXT
,      SHIP_TO_COUNTY_INT
,      SHIP_TO_ADDRESS_ID
,      VENDOR_CODE_INT
,      VENDOR_CODE_EXT
,      VENDOR_CUSTOMER_NAME
,      VENDOR_ADDRESS1
,      VENDOR_ADDRESS2
,      VENDOR_ADDRESS3
,      VENDOR_ADDRESS4
,      VENDOR_CITY
,      VENDOR_POSTAL_CODE
,      VENDOR_COUNTRY_INT
,      VENDOR_COUNTRY_EXT1
,      VENDOR_STATE_INT
,      VENDOR_STATE_EXT1
,      VENDOR_PROVINCE_INT
,      VENDOR_PROVINCE_EXT1
,      VENDOR_COUNTY
,      TRANSACTION_RECORD_ID
,      TRANSACTION_HEADER_ID
,      TRANSACTION_LINE_ID
,      RUN_ID
,      SECURITY_GROUP_ID
FROM EC.ECE_MVSTO_LOCATIONS;

Dependencies

[top of page]

EC.ECE_MVSTO_LOCATIONS does not reference any database object

EC.ECE_MVSTO_LOCATIONS is referenced by following:

EC: ECE_MVSTO_LOCATIONS#