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: BOM.CST_MGD_ITB_TEMP

Object Details

Object Name:	CST_MGD_ITB_TEMP
Object Type:	TABLE
Owner:	BOM
Subobject Name:
Status:	VALID

Temporary Table Details

BOM.CST_MGD_ITB_TEMP 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.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_MGD_ITB_TEMP_N1	NORMAL	NONUNIQUE		ITEM_NUMBER

Columns

Name	Datatype	Length	Mandatory
ITEM_NUMBER	VARCHAR2	(1025)	Yes
DESCRIPTION	VARCHAR2	(240)
PRIMARY_UOM_CODE	VARCHAR2	(240)
CATEGORY_ID	NUMBER
CATEGORY_DESCRIPTION	VARCHAR2	(1025)
RCV_QUANTITY_PO	NUMBER
RCV_AMOUNT_PO	NUMBER
RCV_QUANTITY_NON_PO	NUMBER
RCV_AMOUNT_NON_PO	NUMBER
ISSUE_QUANTITY_SO	NUMBER
ISSUE_AMOUNT_SO	NUMBER
ISSUE_QUANTITY_NON_SO	NUMBER
ISSUE_AMOUNT_NON_SO	NUMBER
AMOUNT_AR	NUMBER
BEG_BAL_QTY	NUMBER
BEG_BAL_AMT	NUMBER
BEG_BAL_QTY_RCV	NUMBER
BEG_BAL_QTY_ISSUED	NUMBER
BEG_BAL_QTY_NET	NUMBER
BEG_BAL_AMT_RCV	NUMBER
BEG_BAL_AMT_ISSUED	NUMBER
BEG_BAL_AMT_NET	NUMBER
BEG_BAL_NON_MOVE_AMT_RCV	NUMBER
BEG_BAL_NON_MOVE_AMT_ISSUE	NUMBER
TRN_EXISTS_FLAG	VARCHAR2	(1)

Query Text

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


SELECT ITEM_NUMBER
,      DESCRIPTION
,      PRIMARY_UOM_CODE
,      CATEGORY_ID
,      CATEGORY_DESCRIPTION
,      RCV_QUANTITY_PO
,      RCV_AMOUNT_PO
,      RCV_QUANTITY_NON_PO
,      RCV_AMOUNT_NON_PO
,      ISSUE_QUANTITY_SO
,      ISSUE_AMOUNT_SO
,      ISSUE_QUANTITY_NON_SO
,      ISSUE_AMOUNT_NON_SO
,      AMOUNT_AR
,      BEG_BAL_QTY
,      BEG_BAL_AMT
,      BEG_BAL_QTY_RCV
,      BEG_BAL_QTY_ISSUED
,      BEG_BAL_QTY_NET
,      BEG_BAL_AMT_RCV
,      BEG_BAL_AMT_ISSUED
,      BEG_BAL_AMT_NET
,      BEG_BAL_NON_MOVE_AMT_RCV
,      BEG_BAL_NON_MOVE_AMT_ISSUE
,      TRN_EXISTS_FLAG
FROM BOM.CST_MGD_ITB_TEMP;

Dependencies

[top of page]

BOM.CST_MGD_ITB_TEMP does not reference any database object

BOM.CST_MGD_ITB_TEMP is referenced by following:

APPS: CST_MGD_ITB_TEMP