[Home] [Help] [Dependency Information]
Object Name: | AHL_PRD_MB_UC_DETAILS |
---|---|
Object Type: | TABLE |
Owner: | AHL |
FND Design Data: | AHL.AHL_PRD_MB_UC_DETAILS |
Subobject Name: | |
Status: | VALID |
AHL.AHL_PRD_MB_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$SESSION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIT_HEADER_ID | NUMBER | |||
UNIT_NAME | VARCHAR2 | (80) | ||
RELATIONSHIP_ID | NUMBER | |||
PARENT_REL_ID | NUMBER | |||
IS_POSITION_SER_CTRLD | VARCHAR2 | (1) | ||
CURR_ITEM_ID | NUMBER | |||
CURR_INSTANCE_ID | NUMBER | |||
PARENT_INSTANCE_ID | NUMBER | |||
ALLOWED_QTY | NUMBER | |||
CURR_ITEM_NUMBER | VARCHAR2 | (240) | ||
CURR_SERIAL_NUMBER | VARCHAR2 | (30) | ||
CURR_INSTLD_QTY | NUMBER | |||
REQ_QTY | NUMBER | |||
ISSUED_QTY | NUMBER | |||
AVAILABLE_QTY | NUMBER | |||
NOT_AVAILABLE_QTY | NUMBER | |||
COMPL_WO_COUNT | NUMBER | |||
TOTAL_WO_COUNT | NUMBER | |||
CUMM_REQ_QTY | NUMBER | |||
CUMM_ISSUED_QTY | NUMBER | |||
CUMM_AVAILABLE_QTY | NUMBER | |||
CUMM_NOT_AVAILABLE_QTY | NUMBER | |||
CUMM_COMPL_WO_COUNT | NUMBER | |||
CUMM_TOTAL_WO_COUNT | NUMBER | |||
ROOT_INSTANCE_ID | NUMBER | |||
POSITION | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT UNIT_HEADER_ID
, UNIT_NAME
, RELATIONSHIP_ID
, PARENT_REL_ID
, IS_POSITION_SER_CTRLD
, CURR_ITEM_ID
, CURR_INSTANCE_ID
, PARENT_INSTANCE_ID
, ALLOWED_QTY
, CURR_ITEM_NUMBER
, CURR_SERIAL_NUMBER
, CURR_INSTLD_QTY
, REQ_QTY
, ISSUED_QTY
, AVAILABLE_QTY
, NOT_AVAILABLE_QTY
, COMPL_WO_COUNT
, TOTAL_WO_COUNT
, CUMM_REQ_QTY
, CUMM_ISSUED_QTY
, CUMM_AVAILABLE_QTY
, CUMM_NOT_AVAILABLE_QTY
, CUMM_COMPL_WO_COUNT
, CUMM_TOTAL_WO_COUNT
, ROOT_INSTANCE_ID
, POSITION
FROM AHL.AHL_PRD_MB_UC_DETAILS;
AHL.AHL_PRD_MB_UC_DETAILS does not reference any database object
AHL.AHL_PRD_MB_UC_DETAILS is referenced by following:
|
|
|