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: MSC.MSC_HZ_UI_LINES

Object Details

Object Name:	MSC_HZ_UI_LINES
Object Type:	TABLE
Owner:	MSC
Subobject Name:
Status:	VALID

Temporary Table Details

MSC.MSC_HZ_UI_LINES 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

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_HZ_UI_LINES_N1	NORMAL	NONUNIQUE		QUERY_ID LINE_ID

Columns

Name	Datatype	Length	Mandatory
QUERY_ID	NUMBER		Yes
LINE_ID	NUMBER		Yes
RELATION_GROUP	VARCHAR2	(2000)	Yes
ORDER_TYPE_RANK	NUMBER		Yes
ORDER_TYPE	NUMBER		Yes
ORDER_TYPE_DESC	VARCHAR2	(80)	Yes
UOM	VARCHAR2	(3)	Yes
FROM_COMPANY_NAME	VARCHAR2	(255)
FROM_ORG_CODE	VARCHAR2	(40)
INVENTORY_ITEM_ID	NUMBER
ITEM_NAME	VARCHAR2	(250)
ITEM_DESCRIPTION	VARCHAR2	(240)
SUPPLIER_ID	VARCHAR2	(2000)
CUSTOMER_ID	VARCHAR2	(2000)
SUPPLIER_SITE_ID	VARCHAR2	(2000)
CUSTOMER_SITE_ID	VARCHAR2	(2000)
SUPPLIER_NAME	VARCHAR2	(255)
CUSTOMER_NAME	VARCHAR2	(255)
SUPPLIER_ORG_CODE	VARCHAR2	(40)
CUSTOMER_ORG_CODE	VARCHAR2	(40)
UNBUCKETED_QTY	NUMBER
QTY_BUCKET1	NUMBER
QTY_BUCKET2	NUMBER
QTY_BUCKET3	NUMBER
QTY_BUCKET4	NUMBER
QTY_BUCKET5	NUMBER
QTY_BUCKET6	NUMBER
QTY_BUCKET7	NUMBER
QTY_BUCKET8	NUMBER
QTY_BUCKET9	NUMBER
QTY_BUCKET10	NUMBER
QTY_BUCKET11	NUMBER
QTY_BUCKET12	NUMBER
QTY_BUCKET13	NUMBER
QTY_BUCKET14	NUMBER
QTY_BUCKET15	NUMBER
QTY_BUCKET16	NUMBER
QTY_BUCKET17	NUMBER
QTY_BUCKET18	NUMBER
QTY_BUCKET19	NUMBER
QTY_BUCKET20	NUMBER
QTY_BUCKET21	NUMBER
QTY_BUCKET22	NUMBER
QTY_BUCKET23	NUMBER
QTY_BUCKET24	NUMBER
QTY_BUCKET25	NUMBER
QTY_BUCKET26	NUMBER
QTY_BUCKET27	NUMBER
QTY_BUCKET28	NUMBER
QTY_BUCKET29	NUMBER
QTY_BUCKET30	NUMBER
QTY_BUCKET31	NUMBER
QTY_BUCKET32	NUMBER
QTY_BUCKET33	NUMBER
QTY_BUCKET34	NUMBER
QTY_BUCKET35	NUMBER
QTY_BUCKET36	NUMBER
OLD_QTY1	NUMBER
OLD_QTY2	NUMBER
OLD_QTY3	NUMBER
OLD_QTY4	NUMBER
OLD_QTY5	NUMBER
OLD_QTY6	NUMBER
OLD_QTY7	NUMBER
OLD_QTY8	NUMBER
OLD_QTY9	NUMBER
OLD_QTY10	NUMBER
OLD_QTY11	NUMBER
OLD_QTY12	NUMBER
OLD_QTY13	NUMBER
OLD_QTY14	NUMBER
OLD_QTY15	NUMBER
OLD_QTY16	NUMBER
OLD_QTY17	NUMBER
OLD_QTY18	NUMBER
OLD_QTY19	NUMBER
OLD_QTY20	NUMBER
OLD_QTY21	NUMBER
OLD_QTY22	NUMBER
OLD_QTY23	NUMBER
OLD_QTY24	NUMBER
OLD_QTY25	NUMBER
OLD_QTY26	NUMBER
OLD_QTY27	NUMBER
OLD_QTY28	NUMBER
OLD_QTY29	NUMBER
OLD_QTY30	NUMBER
OLD_QTY31	NUMBER
OLD_QTY32	NUMBER
OLD_QTY33	NUMBER
OLD_QTY34	NUMBER
OLD_QTY35	NUMBER
OLD_QTY36	NUMBER
EDITABLE_FLAG	VARCHAR2	(1)
OWNER_ITEM	VARCHAR2	(250)
CUST_ITEM	VARCHAR2	(250)
SUP_ITEM	VARCHAR2	(250)
OWNER_ITEM_DESC	VARCHAR2	(240)
CUST_ITEM_DESC	VARCHAR2	(240)
SUP_ITEM_DESC	VARCHAR2	(240)
TP_UOM	VARCHAR2	(3)
UOM_CODE	VARCHAR2	(3)
BUCKET_TYPE	NUMBER
PUBLISHER_ID	NUMBER
PUBLISHER_SITE_ID	NUMBER
NEXT_ITEM	NUMBER
ORDER_RELATION_GROUP	VARCHAR2	(2000)	Yes
PAST_DUE_QTY	NUMBER
SHIPPING_CONTROL	VARCHAR2	(30)

Query Text

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


SELECT QUERY_ID
,      LINE_ID
,      RELATION_GROUP
,      ORDER_TYPE_RANK
,      ORDER_TYPE
,      ORDER_TYPE_DESC
,      UOM
,      FROM_COMPANY_NAME
,      FROM_ORG_CODE
,      INVENTORY_ITEM_ID
,      ITEM_NAME
,      ITEM_DESCRIPTION
,      SUPPLIER_ID
,      CUSTOMER_ID
,      SUPPLIER_SITE_ID
,      CUSTOMER_SITE_ID
,      SUPPLIER_NAME
,      CUSTOMER_NAME
,      SUPPLIER_ORG_CODE
,      CUSTOMER_ORG_CODE
,      UNBUCKETED_QTY
,      QTY_BUCKET1
,      QTY_BUCKET2
,      QTY_BUCKET3
,      QTY_BUCKET4
,      QTY_BUCKET5
,      QTY_BUCKET6
,      QTY_BUCKET7
,      QTY_BUCKET8
,      QTY_BUCKET9
,      QTY_BUCKET10
,      QTY_BUCKET11
,      QTY_BUCKET12
,      QTY_BUCKET13
,      QTY_BUCKET14
,      QTY_BUCKET15
,      QTY_BUCKET16
,      QTY_BUCKET17
,      QTY_BUCKET18
,      QTY_BUCKET19
,      QTY_BUCKET20
,      QTY_BUCKET21
,      QTY_BUCKET22
,      QTY_BUCKET23
,      QTY_BUCKET24
,      QTY_BUCKET25
,      QTY_BUCKET26
,      QTY_BUCKET27
,      QTY_BUCKET28
,      QTY_BUCKET29
,      QTY_BUCKET30
,      QTY_BUCKET31
,      QTY_BUCKET32
,      QTY_BUCKET33
,      QTY_BUCKET34
,      QTY_BUCKET35
,      QTY_BUCKET36
,      OLD_QTY1
,      OLD_QTY2
,      OLD_QTY3
,      OLD_QTY4
,      OLD_QTY5
,      OLD_QTY6
,      OLD_QTY7
,      OLD_QTY8
,      OLD_QTY9
,      OLD_QTY10
,      OLD_QTY11
,      OLD_QTY12
,      OLD_QTY13
,      OLD_QTY14
,      OLD_QTY15
,      OLD_QTY16
,      OLD_QTY17
,      OLD_QTY18
,      OLD_QTY19
,      OLD_QTY20
,      OLD_QTY21
,      OLD_QTY22
,      OLD_QTY23
,      OLD_QTY24
,      OLD_QTY25
,      OLD_QTY26
,      OLD_QTY27
,      OLD_QTY28
,      OLD_QTY29
,      OLD_QTY30
,      OLD_QTY31
,      OLD_QTY32
,      OLD_QTY33
,      OLD_QTY34
,      OLD_QTY35
,      OLD_QTY36
,      EDITABLE_FLAG
,      OWNER_ITEM
,      CUST_ITEM
,      SUP_ITEM
,      OWNER_ITEM_DESC
,      CUST_ITEM_DESC
,      SUP_ITEM_DESC
,      TP_UOM
,      UOM_CODE
,      BUCKET_TYPE
,      PUBLISHER_ID
,      PUBLISHER_SITE_ID
,      NEXT_ITEM
,      ORDER_RELATION_GROUP
,      PAST_DUE_QTY
,      SHIPPING_CONTROL
FROM MSC.MSC_HZ_UI_LINES;

Dependencies

[top of page]

MSC.MSC_HZ_UI_LINES does not reference any database object

MSC.MSC_HZ_UI_LINES is referenced by following:

APPS: MSC_HZ_UI_LINES