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: ONT.OE_CONC_REQUEST_IFACE

Object Details

Object Name:	OE_CONC_REQUEST_IFACE
Object Type:	TABLE
Owner:	ONT
FND Design Data:	ONT.OE_CONC_REQUEST_IFACE
Subobject Name:
Status:	VALID

Interface table for the retrobilling concurrent program

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OE_CONC_REQUEST_IFACE_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	REQUEST_ID HEADER_ID LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
NUMERIC_ATTRIBUTE1	NUMBER			Column for Numeric Attribute1
NUMERIC_ATTRIBUTE2	NUMBER			Column for Numeric Attribute2
NUMERIC_ATTRIBUTE3	NUMBER			Column for Numeric Attribute3
NUMERIC_ATTRIBUTE4	NUMBER			Column for Numeric Attribute4
NUMERIC_ATTRIBUTE5	NUMBER			Column for Numeric Attribute5
CHAR_ATTRIBUTE1	VARCHAR2	(2000)		Column for Charater Attribute1
CHAR_ATTRIBUTE2	VARCHAR2	(2000)		Column for Charater Attribute2
CHAR_ATTRIBUTE3	VARCHAR2	(2000)		Column for Charater Attribute3
CHAR_ATTRIBUTE4	VARCHAR2	(2000)		Column for Charater Attribute4
CHAR_ATTRIBUTE5	VARCHAR2	(2000)		Column for Charater Attribute5
REQUEST_ID	NUMBER		Yes	Unique key. It is a combination of request_id, header_id and line_id
HEADER_ID	NUMBER		Yes	Header ID
LINE_ID	NUMBER		Yes	Line ID

Query Text

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


SELECT NUMERIC_ATTRIBUTE1
,      NUMERIC_ATTRIBUTE2
,      NUMERIC_ATTRIBUTE3
,      NUMERIC_ATTRIBUTE4
,      NUMERIC_ATTRIBUTE5
,      CHAR_ATTRIBUTE1
,      CHAR_ATTRIBUTE2
,      CHAR_ATTRIBUTE3
,      CHAR_ATTRIBUTE4
,      CHAR_ATTRIBUTE5
,      REQUEST_ID
,      HEADER_ID
,      LINE_ID
FROM ONT.OE_CONC_REQUEST_IFACE;

Dependencies

[top of page]

ONT.OE_CONC_REQUEST_IFACE does not reference any database object

ONT.OE_CONC_REQUEST_IFACE is referenced by following:

ONT: OE_CONC_REQUEST_IFACE#