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: OZF.OZF_SD_RES_HEADER_INTF

Object Details

Object Name:	OZF_SD_RES_HEADER_INTF
Object Type:	TABLE
Owner:	OZF
FND Design Data:	OZF.OZF_SD_RES_HEADER_INTF
Subobject Name:
Status:	VALID

To hold Vendor and distributor details sent as part of response

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OZF_SD_RES_HEADER_INTF_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RES_HEADER_INTF_ID

Columns

Name	Datatype	Length	Mandatory	Comments
GLBDOCFUNCCODE	VARCHAR2	(100)		To identify the function of the response document
REQDOCDATETIME	DATE			To store the date and time at which the document was generated
REQDOCID	VARCHAR2	(100)		Internal document number at the vendor end
THISDOCGENDTTIME	DATE			To store the date and time at which the document was generated
BLANKET_FLAG	VARCHAR2	(1)		To hold if the request was blanket
SUPP_QUOTE_NUMBER	VARCHAR2	(60)		Original supplier quote number sent as part of request
AUTH_NUMBER	VARCHAR2	(255)		Authorization number returned by vendor
FROMROLE_CINFO_CTNAME	VARCHAR2	(360)		Vendor contact name
FROMROLE_CINFO_EMAIL	VARCHAR2	(2000)		Vendor contact email
FROMROLE_CINFO_TEL_NUMBER	VARCHAR2	(60)		Vendor contact number
FROMROLE_GLBPRTRCCODE	VARCHAR2	(30)		Global partner Classification code for vendor
FROMROLE_B_BNAME	VARCHAR2	(360)		Vendor name
FROMROLE_P_BUSDESC_GLBBUSID	VARCHAR2	(30)		Unique Identifier for vendor business
FROMROLE_P_BUSDESC_GLBSUPPCODE	VARCHAR2	(30)		Vendor supply chain description
FROMROLE_P_CTINFO_CNAME	VARCHAR2	(360)		Vendor partner contact name
FROMROLE_P_CTINFO_EMAIL	VARCHAR2	(2000)		Vendor partner contact email
FROMROLE_P_CTINFO_TELE_NUM	VARCHAR2	(60)		Vendor partner contact telephone number
FROMROLE_P_GLBPRTCCODE	VARCHAR2	(30)		Vendor partner global classification code
FROMROLE_P_PLOC_ADD1	VARCHAR2	(240)		Vendor address1
FROMROLE_P_PLOC_ADD2	VARCHAR2	(240)		Vendor address2
FROMROLE_P_PLOC_ADD3	VARCHAR2	(240)		Vendor address3
FROMROLE_P_PLOC_CITY	VARCHAR2	(60)		Vendor city
FROMROLE_P_PLOC_COUNTRY	VARCHAR2	(60)		Vendor country
FROMROLE_P_PLOC_POSTALCODE	VARCHAR2	(60)		Vendor postal code
FROMROLE_P_PLOC_POBOXID	VARCHAR2	(60)		Vendor PO Box ID
FROMROLE_P_PLOC_REGION	VARCHAR2	(60)		Vendor region
TOROLE_CINFO_CTNAME	VARCHAR2	(360)		Distributor contact name
TOROLE_CINFO_EMAIL	VARCHAR2	(2000)		Distributor contact email
TOROLE_CINFO_TEL_NUMBER	VARCHAR2	(60)		Distributor contact number
TOROLE_GLBPRTRCCODE	VARCHAR2	(30)		Global partner Classification code for Distributor
TOROLE_B_BNAME	VARCHAR2	(360)		Distributor name
TOROLE_P_BUSDESC_GLBBUSID	VARCHAR2	(30)		Unique Identifier for Distributor business
TOROLE_P_BUSDESC_GLBSUPPCODE	VARCHAR2	(30)		Distributor supply chain description
TOROLE_P_CTINFO_CNAME	VARCHAR2	(360)		Distributor partner contact name
TOROLE_P_CTINFO_EMAIL	VARCHAR2	(2000)		Distributor partner contact email
TOROLE_P_CTINFO_TELE_NUM	VARCHAR2	(60)		Distributor partner contact telephone number
TOROLE_P_GLBPRTCCODE	VARCHAR2	(30)		Distributor partner global classification code
TOROLE_P_PLOC_ADD1	VARCHAR2	(240)		Distributor address1
TOROLE_P_PLOC_ADD2	VARCHAR2	(240)		Distributor address2
TOROLE_P_PLOC_ADD3	VARCHAR2	(240)		Distributor address3
TOROLE_P_PLOC_CITY	VARCHAR2	(60)		Distributor city
TOROLE_P_PLOC_COUNTRY	VARCHAR2	(60)		Distributor country
TOROLE_P_PLOC_POSTALCODE	VARCHAR2	(60)		Distributor postal code
TOROLE_P_PLOC_POBOXID	VARCHAR2	(60)		Distributor PO Box ID
TOROLE_P_PLOC_REGION	VARCHAR2	(60)		Distributor region
REQUEST_NUMBER	VARCHAR2	(30)		request number
PROCESSED_FLAG	VARCHAR2	(1)		flag to indicate whether the row is processed or not
ERROR_TXT	VARCHAR2	(2000)		Error reason if the row processing failed
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Structure Defining Column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
RES_HEADER_INTF_ID	NUMBER		Yes	unique identifier

Query Text

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


SELECT GLBDOCFUNCCODE
,      REQDOCDATETIME
,      REQDOCID
,      THISDOCGENDTTIME
,      BLANKET_FLAG
,      SUPP_QUOTE_NUMBER
,      AUTH_NUMBER
,      FROMROLE_CINFO_CTNAME
,      FROMROLE_CINFO_EMAIL
,      FROMROLE_CINFO_TEL_NUMBER
,      FROMROLE_GLBPRTRCCODE
,      FROMROLE_B_BNAME
,      FROMROLE_P_BUSDESC_GLBBUSID
,      FROMROLE_P_BUSDESC_GLBSUPPCODE
,      FROMROLE_P_CTINFO_CNAME
,      FROMROLE_P_CTINFO_EMAIL
,      FROMROLE_P_CTINFO_TELE_NUM
,      FROMROLE_P_GLBPRTCCODE
,      FROMROLE_P_PLOC_ADD1
,      FROMROLE_P_PLOC_ADD2
,      FROMROLE_P_PLOC_ADD3
,      FROMROLE_P_PLOC_CITY
,      FROMROLE_P_PLOC_COUNTRY
,      FROMROLE_P_PLOC_POSTALCODE
,      FROMROLE_P_PLOC_POBOXID
,      FROMROLE_P_PLOC_REGION
,      TOROLE_CINFO_CTNAME
,      TOROLE_CINFO_EMAIL
,      TOROLE_CINFO_TEL_NUMBER
,      TOROLE_GLBPRTRCCODE
,      TOROLE_B_BNAME
,      TOROLE_P_BUSDESC_GLBBUSID
,      TOROLE_P_BUSDESC_GLBSUPPCODE
,      TOROLE_P_CTINFO_CNAME
,      TOROLE_P_CTINFO_EMAIL
,      TOROLE_P_CTINFO_TELE_NUM
,      TOROLE_P_GLBPRTCCODE
,      TOROLE_P_PLOC_ADD1
,      TOROLE_P_PLOC_ADD2
,      TOROLE_P_PLOC_ADD3
,      TOROLE_P_PLOC_CITY
,      TOROLE_P_PLOC_COUNTRY
,      TOROLE_P_PLOC_POSTALCODE
,      TOROLE_P_PLOC_POBOXID
,      TOROLE_P_PLOC_REGION
,      REQUEST_NUMBER
,      PROCESSED_FLAG
,      ERROR_TXT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      RES_HEADER_INTF_ID
FROM OZF.OZF_SD_RES_HEADER_INTF;

Dependencies

[top of page]

OZF.OZF_SD_RES_HEADER_INTF does not reference any database object

OZF.OZF_SD_RES_HEADER_INTF is referenced by following:

OZF: OZF_SD_RES_HEADER_INTF#