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: AHL.AHL_VISIT_IR_UC_DETAILS

Object Details

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

Temporary Table Details

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.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Primary Key: SYS_C001035567

VISIT_IR_UC_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_C001035567	NORMAL	UNIQUE		VISIT_IR_UC_ID

Columns

Name	Datatype	Length	Mandatory
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)

Query Text

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;

Dependencies

[top of page]

AHL.AHL_VISIT_IR_UC_DETAILS does not reference any database object

AHL.AHL_VISIT_IR_UC_DETAILS is referenced by following:

APPS: AHL_VISIT_IR_UC_DETAILS