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: APPS.AHL_UC_DETAILS_FOR_HGRID

Object Details

Object Name:	AHL_UC_DETAILS_FOR_HGRID
Object Type:	TABLE
Owner:	APPS
FND Design Data:	AHL.AHL_UC_DETAILS_FOR_HGRID
Subobject Name:
Status:	VALID

Temporary Table Details

APPS.AHL_UC_DETAILS_FOR_HGRID 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_C00990626

UNIT_NODE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_C00990626	NORMAL	UNIQUE		UNIT_NODE_ID

Columns

Name	Datatype	Length	Mandatory
UNIT_NODE_ID	NUMBER		Yes
ROOT_INSTANCE_ID	NUMBER
PATH_POSITION_ID	NUMBER
RELATIONSHIP_ID	NUMBER
PARENT_REL_ID	NUMBER
PARENT_INSTANCE_ID	NUMBER
PARENT_INSTANCE_NUMBER	VARCHAR2	(240)
CSI_II_RELATIONSHIP_ID	NUMBER
CSI_II_OBJECT_VERSION_NUM	NUMBER
PART_CHANGE_ID	NUMBER
CURR_ITEM_ID	NUMBER
CURR_INSTANCE_ID	NUMBER
CURR_ITEM_NUMBER	VARCHAR2	(240)
CURR_INSTANCE_OBJ_VER_NUM	NUMBER
CURR_INSTANCE_NUMBER	VARCHAR2	(30)
CURR_SERIAL_NUMBER	VARCHAR2	(80)
CURR_LOT_NUMBER	VARCHAR2	(80)
CURR_QUANTITY	NUMBER
UNIT_OF_MEASURE	VARCHAR2	(30)
ATA	VARCHAR2	(80)
POSITION	VARCHAR2	(240)
POSITION_IMAGE	VARCHAR2	(30)
IS_POSITION_SRL_CONTROLLED	VARCHAR2	(1)
IS_CONTROLLED_POSITION	VARCHAR2	(1)
NODE_TYPE	VARCHAR2	(1)
QTY_PER_POSITION	NUMBER
OPERATION_SEQUENCE_NUM	NUMBER
INST_INSTANCE_ID	NUMBER
INST_ITEM_NUMBER	VARCHAR2	(240)
INST_INSTANCE_NUMBER	VARCHAR2	(30)
INST_SERIAL_NUMBER	VARCHAR2	(80)
INST_INSTANCE_OBJ_VER_NUM	NUMBER
INSTANCE_QUANTITY	NUMBER
INSTALL_QUANTITY	NUMBER
INSTALL_DATE	DATE
REMOVAL_DATE	DATE
REASON_ID	NUMBER
REASON_NAME	VARCHAR2	(30)
REMOVAL_CODE_ID	VARCHAR2	(30)
REMOVAL_MEANING	VARCHAR2	(80)
NOT_LEAF_NODE_FLAG	VARCHAR2	(1)
NODE_LEVEL	NUMBER
HGRID_NODE_PATH	VARCHAR2	(240)
SELECT_DISABLE_FLAG	VARCHAR2	(1)
SEARCH_FLAG	VARCHAR2	(1)
DISPOSITION_ID	NUMBER
DISPOSITION_OBJ_VER_NUM	NUMBER
DISPOSITION_STATUS	VARCHAR2	(80)
DISPOSITION_QTY	NUMBER
COMMENTS	VARCHAR2	(2000)
IMMEDIATE_DISPOSITION_CODE	VARCHAR2	(30)
IMMEDIATE_DISPOSITION	VARCHAR2	(150)
SECONDARY_DISPOSITION_CODE	VARCHAR2	(30)
SECONDARY_DISPOSITION	VARCHAR2	(150)
SR_INCIDENT_ID	NUMBER
COLLECTION_ID	NUMBER
CONDITION_ID	NUMBER
CONDITION_MEANING	VARCHAR2	(150)
PROBLEM_CODE	VARCHAR2	(50)
PROBLEM_MEANING	VARCHAR2	(80)
SEVERITY_ID	NUMBER
SEVERITY_NAME	VARCHAR2	(30)
RESOLUTION_CODE	VARCHAR2	(80)
RESOLUTION_CODE_ID	VARCHAR2	(30)
ESTIMATED_DURATION	NUMBER
SERVICE_TYPE	VARCHAR2	(80)
SERVICE_TYPE_ID	VARCHAR2	(30)
SUMMARY	VARCHAR2	(240)
DISPOSITION_COUNT	NUMBER
QTY_UI_ELEMENT_TYP	VARCHAR2	(10)
MRB_QUALITY_TYP	VARCHAR2	(30)
BULK_PROCESS_FLAG	VARCHAR2	(1)

Query Text

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


SELECT UNIT_NODE_ID
,      ROOT_INSTANCE_ID
,      PATH_POSITION_ID
,      RELATIONSHIP_ID
,      PARENT_REL_ID
,      PARENT_INSTANCE_ID
,      PARENT_INSTANCE_NUMBER
,      CSI_II_RELATIONSHIP_ID
,      CSI_II_OBJECT_VERSION_NUM
,      PART_CHANGE_ID
,      CURR_ITEM_ID
,      CURR_INSTANCE_ID
,      CURR_ITEM_NUMBER
,      CURR_INSTANCE_OBJ_VER_NUM
,      CURR_INSTANCE_NUMBER
,      CURR_SERIAL_NUMBER
,      CURR_LOT_NUMBER
,      CURR_QUANTITY
,      UNIT_OF_MEASURE
,      ATA
,      POSITION
,      POSITION_IMAGE
,      IS_POSITION_SRL_CONTROLLED
,      IS_CONTROLLED_POSITION
,      NODE_TYPE
,      QTY_PER_POSITION
,      OPERATION_SEQUENCE_NUM
,      INST_INSTANCE_ID
,      INST_ITEM_NUMBER
,      INST_INSTANCE_NUMBER
,      INST_SERIAL_NUMBER
,      INST_INSTANCE_OBJ_VER_NUM
,      INSTANCE_QUANTITY
,      INSTALL_QUANTITY
,      INSTALL_DATE
,      REMOVAL_DATE
,      REASON_ID
,      REASON_NAME
,      REMOVAL_CODE_ID
,      REMOVAL_MEANING
,      NOT_LEAF_NODE_FLAG
,      NODE_LEVEL
,      HGRID_NODE_PATH
,      SELECT_DISABLE_FLAG
,      SEARCH_FLAG
,      DISPOSITION_ID
,      DISPOSITION_OBJ_VER_NUM
,      DISPOSITION_STATUS
,      DISPOSITION_QTY
,      COMMENTS
,      IMMEDIATE_DISPOSITION_CODE
,      IMMEDIATE_DISPOSITION
,      SECONDARY_DISPOSITION_CODE
,      SECONDARY_DISPOSITION
,      SR_INCIDENT_ID
,      COLLECTION_ID
,      CONDITION_ID
,      CONDITION_MEANING
,      PROBLEM_CODE
,      PROBLEM_MEANING
,      SEVERITY_ID
,      SEVERITY_NAME
,      RESOLUTION_CODE
,      RESOLUTION_CODE_ID
,      ESTIMATED_DURATION
,      SERVICE_TYPE
,      SERVICE_TYPE_ID
,      SUMMARY
,      DISPOSITION_COUNT
,      QTY_UI_ELEMENT_TYP
,      MRB_QUALITY_TYP
,      BULK_PROCESS_FLAG
FROM APPS.AHL_UC_DETAILS_FOR_HGRID;

Dependencies

[top of page]

APPS.AHL_UC_DETAILS_FOR_HGRID does not reference any database object

APPS.AHL_UC_DETAILS_FOR_HGRID is referenced by following:

APPS: AHL_PRD_BLK_PARTS_CHANGE_PVT - show dependent code