[Home] [Help] [Dependency Information]
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 |
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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_C00990626 | NORMAL | UNIQUE | UNIT_NODE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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;
APPS.AHL_UC_DETAILS_FOR_HGRID does not reference any database object
APPS.AHL_UC_DETAILS_FOR_HGRID is referenced by following:
|
|
|