[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

1. UNIT_NODE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_C00990626	NORMAL	UNIQUE		UNIT_NODE_ID

Columns

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