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: AZ.AZ_APIFWK_TEMP

Object Details

Object Name:	AZ_APIFWK_TEMP
Object Type:	TABLE
Owner:	AZ
Subobject Name:
Status:	VALID

Temporary Table Details

AZ.AZ_APIFWK_TEMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Primary Key: SYS_C00169274

ROW_SEQ_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_C00169274	NORMAL	UNIQUE		ROW_SEQ_ID

Columns

Name	Datatype	Length	Mandatory
VO_ID	NUMBER		Yes
ROW_SEQ_ID	NUMBER		Yes
PARENT_ID	NUMBER
VALUE1	VARCHAR2	(250)
VALUE2	VARCHAR2	(250)
VALUE3	VARCHAR2	(250)
VALUE4	VARCHAR2	(250)
VALUE5	VARCHAR2	(250)
VALUE6	VARCHAR2	(250)
VALUE7	VARCHAR2	(250)
VALUE8	VARCHAR2	(250)
VALUE9	VARCHAR2	(250)
VALUE10	VARCHAR2	(250)
VALUE11	VARCHAR2	(250)
VALUE12	VARCHAR2	(250)
VALUE13	VARCHAR2	(250)
VALUE14	VARCHAR2	(250)
VALUE15	VARCHAR2	(250)
VALUE16	VARCHAR2	(250)
VALUE17	VARCHAR2	(250)
VALUE18	VARCHAR2	(250)
VALUE19	VARCHAR2	(250)
VALUE20	VARCHAR2	(250)
VALUE21	VARCHAR2	(250)
VALUE22	VARCHAR2	(250)
VALUE23	VARCHAR2	(250)
VALUE24	VARCHAR2	(250)
VALUE25	VARCHAR2	(250)
VALUE26	VARCHAR2	(250)
VALUE27	VARCHAR2	(250)
VALUE28	VARCHAR2	(250)
VALUE29	VARCHAR2	(250)
VALUE30	VARCHAR2	(250)
VALUE31	VARCHAR2	(250)
VALUE32	VARCHAR2	(250)
VALUE33	VARCHAR2	(250)
VALUE34	VARCHAR2	(250)
VALUE35	VARCHAR2	(250)
VALUE36	VARCHAR2	(250)
VALUE37	VARCHAR2	(250)
VALUE38	VARCHAR2	(250)
VALUE39	VARCHAR2	(250)
VALUE40	VARCHAR2	(250)
KEY1	NUMBER
KEY2	NUMBER
KEY3	NUMBER
KEY4	NUMBER
KEY5	NUMBER
KEY6	NUMBER
KEY7	NUMBER
KEY8	NUMBER
KEY9	NUMBER
KEY10	NUMBER
KEY11	NUMBER
KEY12	NUMBER
KEY13	NUMBER
KEY14	NUMBER
KEY15	NUMBER
KEY16	NUMBER
KEY17	NUMBER
KEY18	NUMBER
KEY19	NUMBER
KEY20	NUMBER
KEY21	NUMBER
KEY22	NUMBER
KEY23	NUMBER
KEY24	NUMBER
KEY25	NUMBER
KEY26	NUMBER
KEY27	NUMBER
KEY28	NUMBER
KEY29	NUMBER
KEY30	NUMBER
STATUS_FLAG	CHAR	(1)
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER

Query Text

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


SELECT VO_ID
,      ROW_SEQ_ID
,      PARENT_ID
,      VALUE1
,      VALUE2
,      VALUE3
,      VALUE4
,      VALUE5
,      VALUE6
,      VALUE7
,      VALUE8
,      VALUE9
,      VALUE10
,      VALUE11
,      VALUE12
,      VALUE13
,      VALUE14
,      VALUE15
,      VALUE16
,      VALUE17
,      VALUE18
,      VALUE19
,      VALUE20
,      VALUE21
,      VALUE22
,      VALUE23
,      VALUE24
,      VALUE25
,      VALUE26
,      VALUE27
,      VALUE28
,      VALUE29
,      VALUE30
,      VALUE31
,      VALUE32
,      VALUE33
,      VALUE34
,      VALUE35
,      VALUE36
,      VALUE37
,      VALUE38
,      VALUE39
,      VALUE40
,      KEY1
,      KEY2
,      KEY3
,      KEY4
,      KEY5
,      KEY6
,      KEY7
,      KEY8
,      KEY9
,      KEY10
,      KEY11
,      KEY12
,      KEY13
,      KEY14
,      KEY15
,      KEY16
,      KEY17
,      KEY18
,      KEY19
,      KEY20
,      KEY21
,      KEY22
,      KEY23
,      KEY24
,      KEY25
,      KEY26
,      KEY27
,      KEY28
,      KEY29
,      KEY30
,      STATUS_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM AZ.AZ_APIFWK_TEMP;

Dependencies

[top of page]

AZ.AZ_APIFWK_TEMP does not reference any database object

AZ.AZ_APIFWK_TEMP is referenced by following:

APPS: AZ_APIFWK_TEMP