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: OKS.OKS_INSTANCE_TEMP

Object Details

Object Name:	OKS_INSTANCE_TEMP
Object Type:	TABLE
Owner:	OKS
Subobject Name:
Status:	VALID

Temporary Table Details

OKS.OKS_INSTANCE_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$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Column
OKS_INSTANCE_TEMP_N1	NORMAL	NONUNIQUE	OLD_CUSTOMER_PRODUCT_ID
OKS_INSTANCE_TEMP_N2	NORMAL	NONUNIQUE	TRF
OKS_INSTANCE_TEMP_N3	NORMAL	NONUNIQUE	TRM
OKS_INSTANCE_TEMP_N4	NORMAL	NONUNIQUE	RPL
OKS_INSTANCE_TEMP_N5	NORMAL	NONUNIQUE	RET
OKS_INSTANCE_TEMP_N6	NORMAL	NONUNIQUE	SPL
OKS_INSTANCE_TEMP_N7	NORMAL	NONUNIQUE	IDC
OKS_INSTANCE_TEMP_N8	NORMAL	NONUNIQUE	UPD
OKS_INSTANCE_TEMP_N9	NORMAL	NONUNIQUE	NEW

Columns

Name	Datatype	Length
OLD_CUSTOMER_PRODUCT_ID	NUMBER
OLD_QUANTITY	NUMBER
OLD_UNIT_OF_MEASURE	VARCHAR2	(3)
OLD_INVENTORY_ITEM_ID	NUMBER
OLD_CUSTOMER_ACCT_ID	NUMBER
NEW_CUSTOMER_PRODUCT_ID	NUMBER
NEW_QUANTITY	NUMBER
NEW_CUSTOMER_ACCT_ID	NUMBER
NEW_INVENTORY_ITEM_ID	NUMBER
NEW_UNIT_OF_MEASURE	VARCHAR2	(3)
ORG_ID	NUMBER
ORDER_LINE_ID	NUMBER
SHIPPED_DATE	DATE
INSTALLATION_DATE	DATE
BILL_TO_SITE_USE_ID	NUMBER
SHIP_TO_SITE_USE_ID	NUMBER
ORGANIZATION_ID	NUMBER
SYSTEM_ID	NUMBER
BOM_EXPLOSION_FLAG	VARCHAR2	(1)
RETURN_REASON_CODE	VARCHAR2	(240)
RAISE_CREDIT	VARCHAR2	(50)
TRANSACTION_DATE	DATE
TRANSFER_DATE	DATE
TERMINATION_DATE	DATE
TRM	VARCHAR2	(1)
TRF	VARCHAR2	(1)
RET	VARCHAR2	(1)
RPL	VARCHAR2	(1)
IDC	VARCHAR2	(1)
UPD	VARCHAR2	(1)
SPL	VARCHAR2	(1)
NEW	VARCHAR2	(1)
RIN	VARCHAR2	(1)

Query Text

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


SELECT OLD_CUSTOMER_PRODUCT_ID
,      OLD_QUANTITY
,      OLD_UNIT_OF_MEASURE
,      OLD_INVENTORY_ITEM_ID
,      OLD_CUSTOMER_ACCT_ID
,      NEW_CUSTOMER_PRODUCT_ID
,      NEW_QUANTITY
,      NEW_CUSTOMER_ACCT_ID
,      NEW_INVENTORY_ITEM_ID
,      NEW_UNIT_OF_MEASURE
,      ORG_ID
,      ORDER_LINE_ID
,      SHIPPED_DATE
,      INSTALLATION_DATE
,      BILL_TO_SITE_USE_ID
,      SHIP_TO_SITE_USE_ID
,      ORGANIZATION_ID
,      SYSTEM_ID
,      BOM_EXPLOSION_FLAG
,      RETURN_REASON_CODE
,      RAISE_CREDIT
,      TRANSACTION_DATE
,      TRANSFER_DATE
,      TERMINATION_DATE
,      TRM
,      TRF
,      RET
,      RPL
,      IDC
,      UPD
,      SPL
,      NEW
,      RIN
FROM OKS.OKS_INSTANCE_TEMP;

Dependencies

[top of page]

OKS.OKS_INSTANCE_TEMP does not reference any database object

OKS.OKS_INSTANCE_TEMP is referenced by following:

APPS: OKS_INSTANCE_TEMP