DBA Data[Home] [Help] [Dependency Information]


TABLE: BIL.BIL_TX_PROD_TMP

Object Details
Object Name: BIL_TX_PROD_TMP
Object Type: TABLE
Owner: BIL
FND Design Data: TableBIL.BIL_TX_PROD_TMP
Subobject Name:
Status: VALID

Temporary Table Details

BIL.BIL_TX_PROD_TMP 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: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
ATTR1 NUMBER

ATTR2 NUMBER

ATTR3 VARCHAR2 (10)
ATTR4 VARCHAR2 (80)
ATTR5 DATE

Query Text

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


SELECT ATTR1
,      ATTR2
,      ATTR3
,      ATTR4
,      ATTR5
FROM BIL.BIL_TX_PROD_TMP;

Dependencies

[top of page]

BIL.BIL_TX_PROD_TMP does not reference any database object

BIL.BIL_TX_PROD_TMP is referenced by following:

SchemaAPPS
SynonymBIL_TX_PROD_TMP