[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | BIL_BIN_TEMP3 |
|---|---|
| Object Type: | TABLE |
| Owner: | BIL |
| Subobject Name: | |
| Status: | VALID |
BIL.BIL_BIN_TEMP3 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$TRANSACTION. Data is removed at the end of this period.
| Tablespace: |  |
|---|---|
| PCT Free: | 10 |
| PCT Used: | 40 |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REPORT_CODE | VARCHAR2 | (50) | Yes | |
| ROWNO | NUMBER | |||
| COL1 | VARCHAR2 | (128) | ||
| COL2 | VARCHAR2 | (128) | ||
| COL3 | VARCHAR2 | (128) | ||
| COL4 | VARCHAR2 | (128) | ||
| COL5 | VARCHAR2 | (128) | ||
| COL6 | VARCHAR2 | (128) | ||
| COL7 | VARCHAR2 | (128) | ||
| COL8 | VARCHAR2 | (128) | ||
| COL9 | VARCHAR2 | (128) | ||
| COL10 | VARCHAR2 | (128) | ||
| COL11 | VARCHAR2 | (128) | ||
| COL12 | VARCHAR2 | (128) | ||
| COL13 | VARCHAR2 | (128) | ||
| COL14 | VARCHAR2 | (128) | ||
| COL15 | VARCHAR2 | (128) | ||
| COL16 | VARCHAR2 | (128) | ||
| COL17 | VARCHAR2 | (128) | ||
| COL18 | VARCHAR2 | (128) | ||
| COL19 | VARCHAR2 | (128) | ||
| COL20 | VARCHAR2 | (128) | ||
| COL21 | VARCHAR2 | (128) | ||
| COL22 | VARCHAR2 | (128) | ||
| COL23 | VARCHAR2 | (128) | ||
| COL24 | VARCHAR2 | (128) | ||
| COL25 | VARCHAR2 | (128) | ||
| COL26 | VARCHAR2 | (128) | ||
| COL27 | VARCHAR2 | (128) | ||
| COL28 | VARCHAR2 | (128) | ||
| COL29 | VARCHAR2 | (128) | ||
| COL30 | VARCHAR2 | (128) | ||
| COL31 | VARCHAR2 | (128) | ||
| COL32 | VARCHAR2 | (128) | ||
| COL33 | VARCHAR2 | (128) | ||
| COL34 | VARCHAR2 | (128) | ||
| COL35 | VARCHAR2 | (128) | ||
| COL36 | VARCHAR2 | (128) | ||
| COL37 | VARCHAR2 | (128) | ||
| COL38 | VARCHAR2 | (128) | ||
| COL39 | VARCHAR2 | (128) | ||
| COL40 | VARCHAR2 | (128) | ||
| FOOTER_IND1 | VARCHAR2 | (30) | ||
| FOOTER_IND2 | VARCHAR2 | (30) | ||
| SECURITY_GROUP_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT REPORT_CODE
, ROWNO
, COL1
, COL2
, COL3
, COL4
, COL5
, COL6
, COL7
, COL8
, COL9
, COL10
, COL11
, COL12
, COL13
, COL14
, COL15
, COL16
, COL17
, COL18
, COL19
, COL20
, COL21
, COL22
, COL23
, COL24
, COL25
, COL26
, COL27
, COL28
, COL29
, COL30
, COL31
, COL32
, COL33
, COL34
, COL35
, COL36
, COL37
, COL38
, COL39
, COL40
, FOOTER_IND1
, FOOTER_IND2
, SECURITY_GROUP_ID
FROM BIL.BIL_BIN_TEMP3;
BIL.BIL_BIN_TEMP3 does not reference any database object
BIL.BIL_BIN_TEMP3 is referenced by following:
APPS
BIL_BIN_TEMP3
|
|
|
|