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: BIL.BIL_BI_RPT_TMP1

Object Details

Object Name:	BIL_BI_RPT_TMP1
Object Type:	TABLE
Owner:	BIL
Subobject Name:
Status:	VALID

Temporary Table Details

BIL.BIL_BI_RPT_TMP1 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

Columns

Name	Datatype	Length
VIEWBY	VARCHAR2	(150)
SORTORDER	VARCHAR2	(1)
VIEWBYID	VARCHAR2	(150)
BIL_URL1	VARCHAR2	(1000)
BIL_URL2	VARCHAR2	(1000)
BIL_MEASURE2	NUMBER
BIL_MEASURE3	NUMBER
BIL_MEASURE4	NUMBER
BIL_MEASURE5	NUMBER
BIL_MEASURE6	NUMBER
BIL_MEASURE7	NUMBER
BIL_MEASURE8	NUMBER
BIL_MEASURE9	NUMBER
BIL_MEASURE10	NUMBER
BIL_MEASURE11	NUMBER
BIL_MEASURE12	NUMBER
BIL_MEASURE13	NUMBER
BIL_MEASURE14	NUMBER
BIL_MEASURE15	NUMBER
BIL_MEASURE16	NUMBER
BIL_MEASURE17	NUMBER
BIL_MEASURE18	NUMBER
BIL_MEASURE19	NUMBER
BIL_MEASURE20	NUMBER
BIL_MEASURE21	NUMBER
BIL_MEASURE22	NUMBER
BIL_MEASURE23	NUMBER
BIL_MEASURE24	NUMBER
BIL_MEASURE25	NUMBER
BIL_MEASURE26	NUMBER
BIL_MEASURE27	NUMBER
BIL_MEASURE28	NUMBER
SECURITY_GROUP_ID	NUMBER
DATE1	DATE
DATE2	DATE

Query Text

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


SELECT VIEWBY
,      SORTORDER
,      VIEWBYID
,      BIL_URL1
,      BIL_URL2
,      BIL_MEASURE2
,      BIL_MEASURE3
,      BIL_MEASURE4
,      BIL_MEASURE5
,      BIL_MEASURE6
,      BIL_MEASURE7
,      BIL_MEASURE8
,      BIL_MEASURE9
,      BIL_MEASURE10
,      BIL_MEASURE11
,      BIL_MEASURE12
,      BIL_MEASURE13
,      BIL_MEASURE14
,      BIL_MEASURE15
,      BIL_MEASURE16
,      BIL_MEASURE17
,      BIL_MEASURE18
,      BIL_MEASURE19
,      BIL_MEASURE20
,      BIL_MEASURE21
,      BIL_MEASURE22
,      BIL_MEASURE23
,      BIL_MEASURE24
,      BIL_MEASURE25
,      BIL_MEASURE26
,      BIL_MEASURE27
,      BIL_MEASURE28
,      SECURITY_GROUP_ID
,      DATE1
,      DATE2
FROM BIL.BIL_BI_RPT_TMP1;

Dependencies

[top of page]

BIL.BIL_BI_RPT_TMP1 does not reference any database object

BIL.BIL_BI_RPT_TMP1 is referenced by following:

APPS: BIL_BI_RPT_TMP1