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

Object Details

Object Name:	RCV_OPSM_CUSTOMERADDRESS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.RCV_OPSM_CUSTOMERADDRESS_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
SHIPMENT_HEADER_ID	NUMBER		Yes
SHIPMENT_LINE_ID	NUMBER		Yes
ITEM_ID	NUMBER
ITEM_DESCRIPTION	VARCHAR2	(240)
CHANGEOFOWNERSHIP	NUMBER
SOLDBYORGID	NUMBER
SOLDBYCONTACTID	NUMBER
SOLDBYORGCODE	NUMBER	(15)
SOLDBYORGNAME	VARCHAR2	(360)
SOLDBYLOCATIONID	NUMBER	(15)
SOLDBYLINE1	VARCHAR2	(240)
SOLDBYLINE2	VARCHAR2	(240)
SOLDBYLINE3	VARCHAR2	(240)
SOLDBYLINE4	VARCHAR2	(240)
SOLDBYCITY	VARCHAR2	(60)
SOLDBYPOSTALCODE	VARCHAR2	(60)
SOLDBYCOUNTRY	VARCHAR2	(60)
SOLDBYSTATE	VARCHAR2	(60)
SOLDBYPROVINCE	VARCHAR2	(60)
SOLDBYCONTACTNAME	VARCHAR2	(360)
SOLDBYPHONECOUNTRYCODE	VARCHAR2	(10)
SOLDBYPHONEAREACODE	VARCHAR2	(10)
SOLDBYPHONENUMBER	VARCHAR2	(40)
SOLDBYPHONEEXTENSION	VARCHAR2	(20)
SOLDBYCONTACTEMAIL	VARCHAR2	(2000)
SHIPFROMORGID	NUMBER
SHIPFROMCONTACTID	NUMBER
SHIPFROMORGCODE	NUMBER	(15)
SHIPFROMORGNAME	VARCHAR2	(360)
SHIPFROMLOCATIONID	NUMBER	(15)
SHIPFROMLINE1	VARCHAR2	(240)
SHIPFROMLINE2	VARCHAR2	(240)
SHIPFROMLINE3	VARCHAR2	(240)
SHIPFROMLINE4	VARCHAR2	(240)
SHIPFROMCITY	VARCHAR2	(60)
SHIPFROMSTATE	VARCHAR2	(60)
SHIPFROMPROVINCE	VARCHAR2	(60)
SHIPFROMCOUNTRY	VARCHAR2	(60)
SHIPFROMPOSTALCODE	VARCHAR2	(60)
SHIPFROMCONTACTNAME	VARCHAR2	(360)
SHIPFROMPHONECOUNTRYCODE	VARCHAR2	(10)
SHIPFROMPHONEAREACODE	VARCHAR2	(10)
SHIPFROMPHONENUMBER	VARCHAR2	(40)
SHIPFROMPHONEEXTENSION	VARCHAR2	(20)
SHIPFROMCONTACTEMAIL	VARCHAR2	(2000)
BILLEDBYORGID	NUMBER
BILLEDBYCONTACTID	NUMBER
BILLEDBYORGCODE	NUMBER	(15)	Yes
BILLEDBYORGNAME	VARCHAR2	(360)	Yes
BILLEDBYLOCATIONID	NUMBER	(15)
BILLEDBYLINE1	VARCHAR2	(240)
BILLEDBYLINE2	VARCHAR2	(240)
BILLEDBYLINE3	VARCHAR2	(240)
BILLEDBYLINE4	VARCHAR2	(240)
BILLEDBYCITY	VARCHAR2	(60)
BILLEDBYSTATE	VARCHAR2	(60)
BILLEDBYCOUNTRY	VARCHAR2	(60)
BILLEDBYPROVINCE	VARCHAR2	(60)
BILLEDBYPOSTALCODE	VARCHAR2	(60)
BILLEDBYCONTACTNAME	VARCHAR2	(360)
BILLEDBYPHONECOUNTRYCODE	VARCHAR2	(10)
BILLEDBYPHONEAREACODE	VARCHAR2	(10)
BILLEDBYPHONENUMBER	VARCHAR2	(40)
BILLEDBYPHONEEXTENSION	VARCHAR2	(20)
BILLEDBYCONTACTEMAIL	VARCHAR2	(2000)

Query Text

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


SELECT SHIPMENT_HEADER_ID
,      SHIPMENT_LINE_ID
,      ITEM_ID
,      ITEM_DESCRIPTION
,      CHANGEOFOWNERSHIP
,      SOLDBYORGID
,      SOLDBYCONTACTID
,      SOLDBYORGCODE
,      SOLDBYORGNAME
,      SOLDBYLOCATIONID
,      SOLDBYLINE1
,      SOLDBYLINE2
,      SOLDBYLINE3
,      SOLDBYLINE4
,      SOLDBYCITY
,      SOLDBYPOSTALCODE
,      SOLDBYCOUNTRY
,      SOLDBYSTATE
,      SOLDBYPROVINCE
,      SOLDBYCONTACTNAME
,      SOLDBYPHONECOUNTRYCODE
,      SOLDBYPHONEAREACODE
,      SOLDBYPHONENUMBER
,      SOLDBYPHONEEXTENSION
,      SOLDBYCONTACTEMAIL
,      SHIPFROMORGID
,      SHIPFROMCONTACTID
,      SHIPFROMORGCODE
,      SHIPFROMORGNAME
,      SHIPFROMLOCATIONID
,      SHIPFROMLINE1
,      SHIPFROMLINE2
,      SHIPFROMLINE3
,      SHIPFROMLINE4
,      SHIPFROMCITY
,      SHIPFROMSTATE
,      SHIPFROMPROVINCE
,      SHIPFROMCOUNTRY
,      SHIPFROMPOSTALCODE
,      SHIPFROMCONTACTNAME
,      SHIPFROMPHONECOUNTRYCODE
,      SHIPFROMPHONEAREACODE
,      SHIPFROMPHONENUMBER
,      SHIPFROMPHONEEXTENSION
,      SHIPFROMCONTACTEMAIL
,      BILLEDBYORGID
,      BILLEDBYCONTACTID
,      BILLEDBYORGCODE
,      BILLEDBYORGNAME
,      BILLEDBYLOCATIONID
,      BILLEDBYLINE1
,      BILLEDBYLINE2
,      BILLEDBYLINE3
,      BILLEDBYLINE4
,      BILLEDBYCITY
,      BILLEDBYSTATE
,      BILLEDBYCOUNTRY
,      BILLEDBYPROVINCE
,      BILLEDBYPOSTALCODE
,      BILLEDBYCONTACTNAME
,      BILLEDBYPHONECOUNTRYCODE
,      BILLEDBYPHONEAREACODE
,      BILLEDBYPHONENUMBER
,      BILLEDBYPHONEEXTENSION
,      BILLEDBYCONTACTEMAIL
FROM APPS.RCV_OPSM_CUSTOMERADDRESS_V;

Dependencies

[top of page]

APPS.RCV_OPSM_CUSTOMERADDRESS_V references the following:

APPS: AR_CUSTOMERS_ACTIVE_V; HZ_CONTACT_POINTS; HZ_CUST_ACCOUNT_ROLES; HZ_CUST_ACCT_SITES_ALL; HZ_CUST_SITE_USES_ALL; HZ_LOCATIONS; HZ_ORG_CONTACTS; HZ_PARTIES; HZ_PARTY_SITES; HZ_RELATIONSHIPS; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; RCV_SHIPMENT_LINES

APPS.RCV_OPSM_CUSTOMERADDRESS_V is referenced by following:

APPS: RCV_OPSM_DLV_BE_PKG - show dependent code