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: ISC.ISC_TMP_BOOK_SUM2

Object Details

Object Name:	ISC_TMP_BOOK_SUM2
Object Type:	TABLE
Owner:	ISC
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	30
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ISC_TMP_BOOK_SUM2_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	PK1
ISC_TMP_BOOK_SUM2_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	SERVICE_REFERENCE_TYPE_CODE

Columns

Name	Datatype	Length
PK1	NUMBER
VIEW_TYPE	NUMBER
LOG_ROWID	ROWID	(10)
BATCH_ID	NUMBER
CURR_CONV_DATE	DATE
FROM_CURRENCY	VARCHAR2	(40)
TO_CURRENCY1	VARCHAR2	(40)
RATE_TYPE	VARCHAR2	(40)
RATE1	NUMBER
TO_CURRENCY2	VARCHAR2	(40)
RATE2	NUMBER
TO_CURRENCY3	VARCHAR2	(40)
RATE3	NUMBER
INV_OU_ID	NUMBER
MASTER_ORG_ID	NUMBER
INVENTORY_ITEM_ID	NUMBER
ITEM_INV_ORG_ID	NUMBER
TIME_BOOKED_DATE_ID	DATE
TIME_SHIPPED_DATE_ID	DATE
TIME_FULFILLED_DATE_ID	DATE
TIME_SCHEDULE_DATE_ID	DATE
TOP_MODEL_LINE_ID	NUMBER
ORDER_QUANTITY_UOM	VARCHAR2	(30)
INV_UOM_CODE	VARCHAR2	(30)
INV_UOM_RATE	NUMBER
ORDER_NUMBER	NUMBER
HEADER_ID	NUMBER
LINE_NUMBER	VARCHAR2	(240)
SERVICE_REFERENCE_TYPE_CODE	VARCHAR2	(80)
SOLD_TO_ORG_ID	NUMBER
SERVICE_REFERENCE_LINE_ID	NUMBER
TO_CURRENCY4	VARCHAR2	(40)
FREIGHT_CHARGE	NUMBER
FREIGHT_COST	NUMBER

Query Text

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


SELECT PK1
,      VIEW_TYPE
,      LOG_ROWID
,      BATCH_ID
,      CURR_CONV_DATE
,      FROM_CURRENCY
,      TO_CURRENCY1
,      RATE_TYPE
,      RATE1
,      TO_CURRENCY2
,      RATE2
,      TO_CURRENCY3
,      RATE3
,      INV_OU_ID
,      MASTER_ORG_ID
,      INVENTORY_ITEM_ID
,      ITEM_INV_ORG_ID
,      TIME_BOOKED_DATE_ID
,      TIME_SHIPPED_DATE_ID
,      TIME_FULFILLED_DATE_ID
,      TIME_SCHEDULE_DATE_ID
,      TOP_MODEL_LINE_ID
,      ORDER_QUANTITY_UOM
,      INV_UOM_CODE
,      INV_UOM_RATE
,      ORDER_NUMBER
,      HEADER_ID
,      LINE_NUMBER
,      SERVICE_REFERENCE_TYPE_CODE
,      SOLD_TO_ORG_ID
,      SERVICE_REFERENCE_LINE_ID
,      TO_CURRENCY4
,      FREIGHT_CHARGE
,      FREIGHT_COST
FROM ISC.ISC_TMP_BOOK_SUM2;

Dependencies

[top of page]

ISC.ISC_TMP_BOOK_SUM2 does not reference any database object

ISC.ISC_TMP_BOOK_SUM2 is referenced by following:

APPS: ISC_TMP_BOOK_SUM2