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: EC.ECE_MVSTO_LOCATIONS#

Object Details

Object Name:	ECE_MVSTO_LOCATIONS#
Object Type:	VIEW
Owner:	EC
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
BILL_TO_CODE_INTERNAL	VARCHAR2	(240)
BILL_TO_CODE_EXTERNAL	VARCHAR2	(35)
BILL_TO_NAME	VARCHAR2	(50)
BILL_TO_ADDRESS1	VARCHAR2	(240)
BILL_TO_ADDRESS2	VARCHAR2	(240)
BILL_TO_ADDRESS3	VARCHAR2	(240)
BILL_TO_ADDRESS4	VARCHAR2	(240)
BILL_TO_CITY	VARCHAR2	(60)
BILL_TO_POSTAL_CODE	VARCHAR2	(60)
BILL_TO_COUNTRY_INT	VARCHAR2	(60)
BILL_TO_COUNTRY_EXT	VARCHAR2	(80)
BILL_TO_STATE_INT	VARCHAR2	(60)
BILL_TO_STATE_EXT	VARCHAR2	(80)
BILL_TO_PROVINCE_INT	VARCHAR2	(60)
BILL_TO_PROVINCE_EXT	VARCHAR2	(80)
BILL_TO_COUNTY_INT	VARCHAR2	(60)
BILL_TO_ADDRESS_ID	NUMBER
SHIP_TO_CODE_INTERNAL	VARCHAR2	(240)
SHIP_TO_CODE_EXTERNAL	VARCHAR2	(35)
SHIP_TO_NAME	VARCHAR2	(50)
SHIP_TO_ADDRESS1	VARCHAR2	(240)
SHIP_TO_ADDRESS2	VARCHAR2	(240)
SHIP_TO_ADDRESS3	VARCHAR2	(240)
SHIP_TO_ADDRESS4	VARCHAR2	(240)
SHIP_TO_CITY	VARCHAR2	(60)
SHIP_TO_POSTAL_CODE	VARCHAR2	(60)
SHIP_TO_COUNTRY_INT	VARCHAR2	(60)
SHIP_TO_COUNTRY_EXT	VARCHAR2	(80)
SHIP_TO_STATE_INT	VARCHAR2	(60)
SHIP_TO_STATE_EXT	VARCHAR2	(80)
SHIP_TO_PROVINCE_INT	VARCHAR2	(60)
SHIP_TO_PROVINCE_EXT	VARCHAR2	(80)
SHIP_TO_COUNTY_INT	VARCHAR2	(60)
SHIP_TO_ADDRESS_ID	NUMBER
VENDOR_CODE_INT	VARCHAR2	(240)
VENDOR_CODE_EXT	VARCHAR2	(35)
VENDOR_CUSTOMER_NAME	VARCHAR2	(50)
VENDOR_ADDRESS1	VARCHAR2	(240)
VENDOR_ADDRESS2	VARCHAR2	(240)
VENDOR_ADDRESS3	VARCHAR2	(240)
VENDOR_ADDRESS4	VARCHAR2	(240)
VENDOR_CITY	VARCHAR2	(60)
VENDOR_POSTAL_CODE	VARCHAR2	(60)
VENDOR_COUNTRY_INT	VARCHAR2	(60)
VENDOR_COUNTRY_EXT1	VARCHAR2	(80)
VENDOR_STATE_INT	VARCHAR2	(60)
VENDOR_STATE_EXT1	VARCHAR2	(80)
VENDOR_PROVINCE_INT	VARCHAR2	(60)
VENDOR_PROVINCE_EXT1	VARCHAR2	(80)
VENDOR_COUNTY	VARCHAR2	(60)
TRANSACTION_RECORD_ID	NUMBER		Yes
TRANSACTION_HEADER_ID	NUMBER		Yes
TRANSACTION_LINE_ID	NUMBER		Yes
RUN_ID	NUMBER
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# references the following:

EC: ECE_MVSTO_LOCATIONS

EC.ECE_MVSTO_LOCATIONS# is referenced by following:

APPS: ECE_MVSTO_LOCATIONS