[Home] [Help] [Dependency Information]
Object Name: | AHL_VISIT_IR_UC_DETAILS |
---|---|
Object Type: | TABLE |
Owner: | AHL |
FND Design Data: | AHL.AHL_VISIT_IR_UC_DETAILS |
Subobject Name: | |
Status: | VALID |
AHL.AHL_VISIT_IR_UC_DETAILS 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 |
---|---|---|---|---|
SYS_C001035567 | NORMAL | UNIQUE | VISIT_IR_UC_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VISIT_IR_UC_ID | NUMBER | Yes | ||
ROOT_INSTANCE_ID | NUMBER | |||
UNIT_HEADER_ID | NUMBER | |||
UNIT_NAME | VARCHAR2 | (80) | ||
PATH_POSITION_ID | NUMBER | |||
RELATIONSHIP_ID | NUMBER | |||
PARENT_REL_ID | NUMBER | |||
CURR_ITEM_ID | NUMBER | |||
CURR_INSTANCE_ID | NUMBER | |||
PARENT_INSTANCE_ID | NUMBER | |||
CURR_ITEM_NUMBER | VARCHAR2 | (240) | ||
CURR_INSTANCE_NUMBER | NUMBER | |||
CURR_SERIAL_NUMBER | VARCHAR2 | (30) | ||
POSITION | VARCHAR2 | (240) | ||
POSITION_IMAGE | VARCHAR2 | (30) | ||
ITEM_GROUP_ID | NUMBER | |||
ITEM_GROUP_NAME | VARCHAR2 | (80) | ||
RESERVED_SERIAL_NUM | VARCHAR2 | (30) | ||
AVAILABLE_PARTS | VARCHAR2 | (1) | ||
UNIT_NHA | VARCHAR2 | (80) | ||
IS_UNIT | VARCHAR2 | (1) | ||
IS_WARRANTY_AVAILABLE | VARCHAR2 | (1) | ||
MR_COUNT | NUMBER | |||
TASK_COUNT | NUMBER | |||
IS_VISIT_AVAILABLE | VARCHAR2 | (1) | ||
MC_HEADER_ID | NUMBER | |||
IS_SB_RULE_AVAILABLE | VARCHAR2 | (1) | ||
ROUTE_DISPOSITIONS_FLAG | VARCHAR2 | (1) | ||
RD_REWORK_PERCENT | NUMBER | |||
RD_REPLACE_PERCENT | NUMBER | |||
POSITION_MATERIAL_FLAG | VARCHAR2 | (1) | ||
BG_POSITION | NUMBER | |||
BG_INSTANCE | NUMBER | |||
INST_ROUTING_ID | NUMBER | |||
INST_ROUTING_OVN | NUMBER | |||
VISIT_ID | NUMBER | |||
INST_ROUTING_CODE | VARCHAR2 | (30) | ||
INST_ROUTING_MEANING | VARCHAR2 | (80) | ||
INST_ROUTING_FLAG | VARCHAR2 | (1) | ||
QTY_PER_POSITION | NUMBER | |||
INSTALLED_QTY | NUMBER | |||
LEAF_NODE_FLAG | VARCHAR2 | (1) | ||
NODE_LEVEL | NUMBER | |||
HGRID_NODE_PATH | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT VISIT_IR_UC_ID
, ROOT_INSTANCE_ID
, UNIT_HEADER_ID
, UNIT_NAME
, PATH_POSITION_ID
, RELATIONSHIP_ID
, PARENT_REL_ID
, CURR_ITEM_ID
, CURR_INSTANCE_ID
, PARENT_INSTANCE_ID
, CURR_ITEM_NUMBER
, CURR_INSTANCE_NUMBER
, CURR_SERIAL_NUMBER
, POSITION
, POSITION_IMAGE
, ITEM_GROUP_ID
, ITEM_GROUP_NAME
, RESERVED_SERIAL_NUM
, AVAILABLE_PARTS
, UNIT_NHA
, IS_UNIT
, IS_WARRANTY_AVAILABLE
, MR_COUNT
, TASK_COUNT
, IS_VISIT_AVAILABLE
, MC_HEADER_ID
, IS_SB_RULE_AVAILABLE
, ROUTE_DISPOSITIONS_FLAG
, RD_REWORK_PERCENT
, RD_REPLACE_PERCENT
, POSITION_MATERIAL_FLAG
, BG_POSITION
, BG_INSTANCE
, INST_ROUTING_ID
, INST_ROUTING_OVN
, VISIT_ID
, INST_ROUTING_CODE
, INST_ROUTING_MEANING
, INST_ROUTING_FLAG
, QTY_PER_POSITION
, INSTALLED_QTY
, LEAF_NODE_FLAG
, NODE_LEVEL
, HGRID_NODE_PATH
FROM AHL.AHL_VISIT_IR_UC_DETAILS;
AHL.AHL_VISIT_IR_UC_DETAILS does not reference any database object
AHL.AHL_VISIT_IR_UC_DETAILS is referenced by following:
|
|
|