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_MVSTO_LOCATIONS_V

Object Details

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

View Type

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

This view extracts line location information
for the outbound Movement Statistics (INTRASTAT) transaction.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BILL_TO_CODE_INTERNAL	VARCHAR2	(240)	Yes	Bill To Code (Internal)
BILL_TO_CODE_EXTERNAL	VARCHAR2	(40)		Bill To Code (Ext)
BILL_TO_NAME	VARCHAR2	(360)	Yes	Bill To Customer Name
BILL_TO_ADDRESS1	VARCHAR2	(240)	Yes	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	VARCHAR2	(60)	Yes	Bill To Country (Internal)
BILL_TO_STATE	VARCHAR2	(60)		Bill To State (Internal)
BILL_TO_PROVINCE	VARCHAR2	(60)		Bill To Province (Internal)
BILL_TO_COUNTY	VARCHAR2	(60)		Bill To County
BILL_TO_ADDRESS_ID	NUMBER	(15)	Yes	Bill To Address ID
BILL_TO_CUSTOMER_ID	NUMBER	(15)	Yes	Bill To Customer ID
BILL_TO_SITE_USE_ID	NUMBER	(15)		Bill To Site Use ID
SHIP_TO_CODE_INTERNAL	VARCHAR2	(240)	Yes	Ship To Code (Internal)
SHIP_TO_CODE_EXTERNAL	VARCHAR2	(40)		Ship To Code (Ext)
SHIP_TO_NAME	VARCHAR2	(360)	Yes	Ship To Customer Name
SHIP_TO_ADDRESS1	VARCHAR2	(240)	Yes	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	VARCHAR2	(60)	Yes	Ship To Country (Internal)
SHIP_TO_STATE	VARCHAR2	(60)		Ship To State (Internal)
SHIP_TO_PROVINCE	VARCHAR2	(60)		Ship To Province (Internal)
SHIP_TO_COUNTY	VARCHAR2	(60)		Ship To County
SHIP_TO_ADDRESS_ID	NUMBER	(15)	Yes	Ship To Address ID
SHIP_TO_CUSTOMER_ID	NUMBER	(15)	Yes	Ship To Customer ID
SHIP_TO_SITE_USE_ID	NUMBER	(15)	Yes	Ship To Site Use ID
VENDOR_CODE_INT	NUMBER		Yes	Vendor Code (Internal)
VENDOR_CODE_EXT	VARCHAR2	(60)		Vendor Code (Ext)
VENDOR_CUSTOMER_NAME	VARCHAR2	(240)		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	(20)		Vendor Postal Code
VENDOR_COUNTRY_INT	VARCHAR2	(25)		Vendor Country (Internal)
VENDOR_TO_POSTAL_CODE	VARCHAR2	(20)		vendor to postal code
VENDOR_STATE_INT	VARCHAR2	(60)		Vendor State (Internal)
VENDOR_PROVINCE_INT	VARCHAR2	(60)		Vendor Province (Internal)
VENDOR_COUNTY	VARCHAR2	(60)		Vendor County
TRANSACTION_HEADER_ID	VARCHAR2	(0)		Transaction Header ID
TRANSACTION_LINE_ID	VARCHAR2	(0)		Transaction Line ID

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
,      BILL_TO_STATE
,      BILL_TO_PROVINCE
,      BILL_TO_COUNTY
,      BILL_TO_ADDRESS_ID
,      BILL_TO_CUSTOMER_ID
,      BILL_TO_SITE_USE_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
,      SHIP_TO_STATE
,      SHIP_TO_PROVINCE
,      SHIP_TO_COUNTY
,      SHIP_TO_ADDRESS_ID
,      SHIP_TO_CUSTOMER_ID
,      SHIP_TO_SITE_USE_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_TO_POSTAL_CODE
,      VENDOR_STATE_INT
,      VENDOR_PROVINCE_INT
,      VENDOR_COUNTY
,      TRANSACTION_HEADER_ID
,      TRANSACTION_LINE_ID
FROM APPS.ECE_MVSTO_LOCATIONS_V;

Dependencies

[top of page]

APPS.ECE_MVSTO_LOCATIONS_V references the following:

APPS: FND_GLOBAL - show dependent code; HZ_CUST_ACCOUNTS; HZ_CUST_ACCT_SITES_ALL; HZ_CUST_SITE_USES_ALL; HZ_LOCATIONS; HZ_PARTIES; HZ_PARTY_SITES; PO_VENDORS; PO_VENDOR_SITES

APPS.ECE_MVSTO_LOCATIONS_V is not referenced by any database object