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]

TYPE: APPS.RCV_OPSM_DLVHDR_REC

Object Details

Object Name:	RCV_OPSM_DLVHDR_REC
Object Type:	TYPE
Owner:	APPS
Subobject Name:
Status:	VALID

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length
SHIPMENT_HEADER_ID	NUMBER
ORGANIZATION_ID	NUMBER
ORGANIZATION_CODE	VARCHAR2	(3)
RECEIPT_NUM	VARCHAR2	(30)
CHANGE_OF_OWNERSHIP	VARCHAR2	(10)
BILL_OF_LADING	VARCHAR2	(25)
CREATED_BY	NUMBER
CREATION_DATE	DATE
LAST_UPDATED_BY	NUMBER
LAST_UPDATE_DATE	DATE
SOLDBYORGID	NUMBER
SOLDBYCONTACTID	NUMBER
SOLDBYORGCODE	VARCHAR2	(240)
SOLDBYORGNAME	VARCHAR2	(240)
SOLDBYLINE1	VARCHAR2	(250)
SOLDBYLINE2	VARCHAR2	(250)
SOLDBYLINE3	VARCHAR2	(250)
SOLDBYLINE4	VARCHAR2	(250)
SOLDBYCITY	VARCHAR2	(60)
SOLDBYSTATE	VARCHAR2	(60)
SOLDBYCOUNTRY	VARCHAR2	(60)
SOLDBYPOSTALCODE	VARCHAR2	(60)
SOLDBYCONTACTNAME	VARCHAR2	(650)
SOLDBYCOUNTRYCODE	VARCHAR2	(100)
SOLDBYAREACODE	VARCHAR2	(100)
SOLDBYPHONENUMBER	VARCHAR2	(100)
SOLDBYEXTN	VARCHAR2	(100)
SOLDBYCONTACTEMAIL	VARCHAR2	(2000)
BILLEDBYORGID	NUMBER
BILLEDBYCONTACTID	NUMBER
BILLEDBYORGCODE	VARCHAR2	(240)
BILLEDBYORGNAME	VARCHAR2	(240)
BILLEDBYLINE1	VARCHAR2	(250)
BILLEDBYLINE2	VARCHAR2	(250)
BILLEDBYLINE3	VARCHAR2	(250)
BILLEDBYLINE4	VARCHAR2	(250)
BILLEDBYCITY	VARCHAR2	(60)
BILLEDBYSTATE	VARCHAR2	(60)
BILLEDBYCOUNTRY	VARCHAR2	(60)
BILLEDBYPOSTALCODE	VARCHAR2	(60)
BILLEDBYCONTACTNAME	VARCHAR2	(650)
BILLEDBYCOUNTRYCODE	VARCHAR2	(100)
BILLEDBYAREACODE	VARCHAR2	(100)
BILLEDBYPHONENUMBER	VARCHAR2	(100)
BILLEDBYEXTN	VARCHAR2	(100)
BILLEDBYCONTACTEMAIL	VARCHAR2	(2000)
SHIPFROMORGID	NUMBER
SHIPFROMCONTACTID	NUMBER
SHIPFROMORGCODE	VARCHAR2	(240)
SHIPFROMORGNAME	VARCHAR2	(240)
SHIPFROMLINE1	VARCHAR2	(250)
SHIPFROMLINE2	VARCHAR2	(250)
SHIPFROMLINE3	VARCHAR2	(250)
SHIPFROMLINE4	VARCHAR2	(250)
SHIPFROMCITY	VARCHAR2	(60)
SHIPFROMSTATE	VARCHAR2	(60)
SHIPFROMCOUNTRY	VARCHAR2	(60)
SHIPFROMPOSTALCODE	VARCHAR2	(60)
SHIPFROMCONTACTNAME	VARCHAR2	(650)
SHIPFROMCOUNTRYCODE	VARCHAR2	(100)
SHIPFROMAREACODE	VARCHAR2	(100)
SHIPFROMPHONENUMBER	VARCHAR2	(100)
SHIPFROMEXTN	VARCHAR2	(100)
SHIPFROMCONTACTEMAIL	VARCHAR2	(2000)
SHIPTOORGID	NUMBER
SHIPTOORGCODE	VARCHAR2	(240)
SHIPTOORGNAME	VARCHAR2	(240)
SHIPTOLINE1	VARCHAR2	(250)
SHIPTOLINE2	VARCHAR2	(250)
SHIPTOLINE3	VARCHAR2	(250)
SHIPTOCITY	VARCHAR2	(60)
SHIPTOSTATE	VARCHAR2	(60)
SHIPTOCOUNTRY	VARCHAR2	(60)
SHIPTOPOSTALCODE	VARCHAR2	(60)
SHIPTOCONTACTNAME	VARCHAR2	(650)
SHIPTOCONTACTPHONE	VARCHAR2	(250)
SHIPTOCONTACTEMAIL	VARCHAR2	(2000)
SOLDTOORGID	NUMBER
SOLDTOORGCODE	VARCHAR2	(240)
SOLDTOORGNAME	VARCHAR2	(240)
SOLDTOLINE1	VARCHAR2	(250)
SOLDTOLINE2	VARCHAR2	(250)
SOLDTOLINE3	VARCHAR2	(250)
SOLDTOCITY	VARCHAR2	(60)
SOLDTOSTATE	VARCHAR2	(60)
SOLDTOCOUNTRY	VARCHAR2	(60)
SOLDTOPOSTALCODE	VARCHAR2	(60)
SOLDTOCONTACTNAME	VARCHAR2	(650)
SOLDTOCONTACTPHONE	VARCHAR2	(100)
SOLDTOCONTACTEMAIL	VARCHAR2	(250)

Dependencies

[top of page]

APPS.RCV_OPSM_DLVHDR_REC references the following:

SYS: STANDARD - show dependent code

APPS.RCV_OPSM_DLVHDR_REC is referenced by following:

APPS: RCV_OPSM_DLVHDR_TBL; RCV_OPSM_DLV_BE_PKG - show dependent code