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: OKI.OKI_BIN_DETAILS

Object Details

Object Name:	OKI_BIN_DETAILS
Object Type:	TABLE
Owner:	OKI
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKI_BIN_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	BIN_ROW_ID
OKI_BIN_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	SUMMARY_BUILD_DATE BIN_ID IN_PARAMETER1 IN_PARAMETER2 IN_PARAMETER3 IN_PARAMETER4

Columns

Name	Datatype	Length	Mandatory
SUMMARY_BUILD_DATE	DATE		Yes
BIN_ID	VARCHAR2	(30)	Yes
IN_PARAMETER1	VARCHAR2	(120)	Yes
IN_PARAMETER2	VARCHAR2	(120)	Yes
IN_PARAMETER3	VARCHAR2	(120)	Yes
IN_PARAMETER4	VARCHAR2	(120)	Yes
BIN_ROW_ID	NUMBER		Yes
DISP_SEQ	NUMBER		Yes
PARAMETER0	VARCHAR2	(120)
PARAMETER1	VARCHAR2	(120)
PARAMETER2	VARCHAR2	(120)
PARAMETER3	VARCHAR2	(120)
PARAMETER4	VARCHAR2	(120)
PARDESC1	VARCHAR2	(120)
PARDESC2	VARCHAR2	(120)
PARDESC3	VARCHAR2	(120)
PARDESC4	VARCHAR2	(120)
COLUMN1	VARCHAR2	(120)
COLUMN2	VARCHAR2	(120)
COLUMN3	VARCHAR2	(120)
COLUMN4	VARCHAR2	(120)
COLUMN5	VARCHAR2	(120)
COLUMN6	VARCHAR2	(120)
COLUMN7	VARCHAR2	(120)
COLUMN8	VARCHAR2	(120)
COLUMN9	VARCHAR2	(120)
COLUMN10	VARCHAR2	(120)
COLUMN11	VARCHAR2	(120)
COLUMN12	VARCHAR2	(120)
COLUMN13	VARCHAR2	(120)
COLUMN14	VARCHAR2	(120)
COLUMN15	VARCHAR2	(120)
REQUEST_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
SECURITY_GROUP_ID	NUMBER

Query Text

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


SELECT SUMMARY_BUILD_DATE
,      BIN_ID
,      IN_PARAMETER1
,      IN_PARAMETER2
,      IN_PARAMETER3
,      IN_PARAMETER4
,      BIN_ROW_ID
,      DISP_SEQ
,      PARAMETER0
,      PARAMETER1
,      PARAMETER2
,      PARAMETER3
,      PARAMETER4
,      PARDESC1
,      PARDESC2
,      PARDESC3
,      PARDESC4
,      COLUMN1
,      COLUMN2
,      COLUMN3
,      COLUMN4
,      COLUMN5
,      COLUMN6
,      COLUMN7
,      COLUMN8
,      COLUMN9
,      COLUMN10
,      COLUMN11
,      COLUMN12
,      COLUMN13
,      COLUMN14
,      COLUMN15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SECURITY_GROUP_ID
FROM OKI.OKI_BIN_DETAILS;

Dependencies

[top of page]

OKI.OKI_BIN_DETAILS does not reference any database object

OKI.OKI_BIN_DETAILS is referenced by following:

APPS: OKI_BIN_DETAILS