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_CUST_INTF

Object Details

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

To hold the customer 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_CUST_INTF_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RES_CUST_INTF_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CUSTNAME	VARCHAR2	(360)		Customer Name
CUST_DUNS_NUMBER	VARCHAR2	(100)		DUNS Number of the customer
CUST_CAT_CODE	VARCHAR2	(100)		Category code for customer
CUST_EMAIL	VARCHAR2	(2000)		Customer email
CUST_TEL_NUMBER	VARCHAR2	(60)		Customer telephone number
PRTCCODE	VARCHAR2	(30)		Partner classification code for customer
PADD_ADD1	VARCHAR2	(240)		Physical address1
PADD_ADD2	VARCHAR2	(240)		Physical address2
PADD_ADD3	VARCHAR2	(240)		Physical address3
PADD_CITY	VARCHAR2	(60)		Customer city
PADD_COUNTRY	VARCHAR2	(60)		Country where customer is located
PADD_POSTAL_CODE	VARCHAR2	(60)		Postal code
PADD_PO_BOX	VARCHAR2	(60)		PO Box Identifier
REQUEST_NUMBER	VARCHAR2	(30)		request number
SITE_USE_CODE	VARCHAR2	(30)		site use code
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_CUST_INTF_ID	NUMBER		Yes	unique identifier

Query Text

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


SELECT CUSTNAME
,      CUST_DUNS_NUMBER
,      CUST_CAT_CODE
,      CUST_EMAIL
,      CUST_TEL_NUMBER
,      PRTCCODE
,      PADD_ADD1
,      PADD_ADD2
,      PADD_ADD3
,      PADD_CITY
,      PADD_COUNTRY
,      PADD_POSTAL_CODE
,      PADD_PO_BOX
,      REQUEST_NUMBER
,      SITE_USE_CODE
,      PROCESSED_FLAG
,      ERROR_TXT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      RES_CUST_INTF_ID
FROM OZF.OZF_SD_RES_CUST_INTF;

Dependencies

[top of page]

OZF.OZF_SD_RES_CUST_INTF does not reference any database object

OZF.OZF_SD_RES_CUST_INTF is referenced by following:

APPS: OZF_SD_RES_CUST_INTF