[Home] [Help] [Dependency Information]
Object Name: | CST_MGD_IAL_TEMP |
---|---|
Object Type: | TABLE |
Owner: | BOM |
Subobject Name: | |
Status: | VALID |
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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | 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 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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;
BOM.CST_MGD_IAL_TEMP does not reference any database object
BOM.CST_MGD_IAL_TEMP is referenced by following:
|
|
|