[Home] [Help] [Dependency Information]
Object Name: | AHL_TEMP_UNIT_EFFECTIVITIES |
---|---|
Object Type: | TABLE |
Owner: | AHL |
Subobject Name: | |
Status: | VALID |
AHL.AHL_TEMP_UNIT_EFFECTIVITIES 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 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AHL_TEMP_UNIT_EFFECTIVITIES_N1 | NORMAL | NONUNIQUE |
CSI_ITEM_INSTANCE_ID
MR_HEADER_ID | |
AHL_TEMP_UNIT_EFFECTIVITIES_N2 | NORMAL | NONUNIQUE |
PARENT_CSI_ITEM_INSTANCE_ID
PARENT_MR_HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIT_EFFECTIVITY_ID | NUMBER | |||
CSI_ITEM_INSTANCE_ID | NUMBER | Yes | ||
MR_HEADER_ID | NUMBER | Yes | ||
FORECAST_SEQUENCE | NUMBER | |||
MR_INTERVAL_ID | NUMBER | |||
MR_EFFECTIVITY_ID | NUMBER | |||
DUE_DATE | DATE | |||
DUE_COUNTER_VALUE | NUMBER | |||
REPETITIVE_MR_FLAG | VARCHAR2 | (1) | ||
TOLERANCE_FLAG | VARCHAR2 | (1) | ||
TOLERANCE_BEFORE | NUMBER | |||
TOLERANCE_AFTER | NUMBER | |||
MESSAGE_CODE | VARCHAR2 | (30) | ||
PARENT_MR_HEADER_ID | NUMBER | |||
PARENT_CSI_ITEM_INSTANCE_ID | NUMBER | |||
ORIG_MR_HEADER_ID | NUMBER | |||
ORIG_CSI_ITEM_INSTANCE_ID | NUMBER | |||
ORIG_FORECAST_SEQUENCE | NUMBER | |||
PRECEDING_MR_HEADER_ID | NUMBER | |||
PRECEDING_CSI_ITEM_INSTANCE_ID | NUMBER | |||
PRECEDING_FORECAST_SEQ | NUMBER | |||
PRECEDING_CHECK_FLAG | VARCHAR2 | (1) | ||
ONE_TIME_CHECK_FLAG | VARCHAR2 | (1) | ||
VISIT_END_DATE | DATE | |||
PROGRAM_MR_HEADER_ID | NUMBER | |||
SERVICE_LINE_ID | NUMBER | |||
EARLIEST_DUE_DATE | DATE | |||
LATEST_DUE_DATE | DATE | |||
COUNTER_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT UNIT_EFFECTIVITY_ID
, CSI_ITEM_INSTANCE_ID
, MR_HEADER_ID
, FORECAST_SEQUENCE
, MR_INTERVAL_ID
, MR_EFFECTIVITY_ID
, DUE_DATE
, DUE_COUNTER_VALUE
, REPETITIVE_MR_FLAG
, TOLERANCE_FLAG
, TOLERANCE_BEFORE
, TOLERANCE_AFTER
, MESSAGE_CODE
, PARENT_MR_HEADER_ID
, PARENT_CSI_ITEM_INSTANCE_ID
, ORIG_MR_HEADER_ID
, ORIG_CSI_ITEM_INSTANCE_ID
, ORIG_FORECAST_SEQUENCE
, PRECEDING_MR_HEADER_ID
, PRECEDING_CSI_ITEM_INSTANCE_ID
, PRECEDING_FORECAST_SEQ
, PRECEDING_CHECK_FLAG
, ONE_TIME_CHECK_FLAG
, VISIT_END_DATE
, PROGRAM_MR_HEADER_ID
, SERVICE_LINE_ID
, EARLIEST_DUE_DATE
, LATEST_DUE_DATE
, COUNTER_ID
FROM AHL.AHL_TEMP_UNIT_EFFECTIVITIES;
AHL.AHL_TEMP_UNIT_EFFECTIVITIES does not reference any database object
AHL.AHL_TEMP_UNIT_EFFECTIVITIES is referenced by following:
|
|
|