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_IAL_TEMP

Object Details

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

Temporary Table Details

BOM.CST_MGD_IAL_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	Column
CST_MGD_IAL_TEMP_N1	NORMAL	NONUNIQUE	ITEM_NUMBER
CST_MGD_IAL_TEMP_N2	NORMAL	NONUNIQUE	TRANSACTION_DATE
CST_MGD_IAL_TEMP_N3	NORMAL	NONUNIQUE	MMT_TRANSACTION_ID
CST_MGD_IAL_TEMP_N4	NORMAL	NONUNIQUE	RCV_TRANSACTION_ID
CST_MGD_IAL_TEMP_N5	NORMAL	NONUNIQUE	INVENTORY_ITEM_ID

Columns

Name	Datatype	Length	Mandatory
ITEM_NUMBER	VARCHAR2	(1025)	Yes
REC_TYPE	VARCHAR2	(40)	Yes
TRANSACTION_DATE	DATE
MMT_TRANSACTION_ID	NUMBER
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
QUANTITY_AR	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
PAC_PERIOD_ID	NUMBER
PERIOD_NAME	VARCHAR2	(15)
PAC_PERIOD_ID_MMT	NUMBER
DESCRIPTION	VARCHAR2	(240)
PRIMARY_UOM_CODE	VARCHAR2	(240)
TRANSACTION_TYPE_NAME	VARCHAR2	(40)
DOCUMENT_NUMBER	VARCHAR2	(240)
DOCUMENT_TYPE	VARCHAR2	(240)
CUSTOMER_VENDOR	VARCHAR2	(360)
CATEGORY_DESCRIPTION	VARCHAR2	(1025)
INVENTORY_ITEM_ID	NUMBER		Yes
CATEGORY_ID	NUMBER
ORGANIZATION_ID	NUMBER
HEADER_ID	NUMBER
LINE_ID	NUMBER
CUSTOMER_TRX_ID	NUMBER
CUSTOMER_TRX_LINE_ID	NUMBER
INVOICE_ID	NUMBER
INVOICE_DISTRIBUTION_ID	NUMBER
PO_DISTRIBUTION_ID	NUMBER
TRANSACTION_TYPE_ID	NUMBER
TRANSACTION_ACTION_ID	NUMBER
TRANSACTION_SOURCE_TYPE_ID	NUMBER
RCV_TRANSACTION_ID	NUMBER
TRX_SOURCE_LINE_ID	NUMBER
RECORD_SEQUENCE	NUMBER

Query Text

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


SELECT ITEM_NUMBER
,      REC_TYPE
,      TRANSACTION_DATE
,      MMT_TRANSACTION_ID
,      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
,      QUANTITY_AR
,      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
,      PAC_PERIOD_ID
,      PERIOD_NAME
,      PAC_PERIOD_ID_MMT
,      DESCRIPTION
,      PRIMARY_UOM_CODE
,      TRANSACTION_TYPE_NAME
,      DOCUMENT_NUMBER
,      DOCUMENT_TYPE
,      CUSTOMER_VENDOR
,      CATEGORY_DESCRIPTION
,      INVENTORY_ITEM_ID
,      CATEGORY_ID
,      ORGANIZATION_ID
,      HEADER_ID
,      LINE_ID
,      CUSTOMER_TRX_ID
,      CUSTOMER_TRX_LINE_ID
,      INVOICE_ID
,      INVOICE_DISTRIBUTION_ID
,      PO_DISTRIBUTION_ID
,      TRANSACTION_TYPE_ID
,      TRANSACTION_ACTION_ID
,      TRANSACTION_SOURCE_TYPE_ID
,      RCV_TRANSACTION_ID
,      TRX_SOURCE_LINE_ID
,      RECORD_SEQUENCE
FROM BOM.CST_MGD_IAL_TEMP;

Dependencies

[top of page]

BOM.CST_MGD_IAL_TEMP does not reference any database object

BOM.CST_MGD_IAL_TEMP is referenced by following:

APPS: CST_MGD_IAL_TEMP