[Home] [Help] [Dependency Information]
Object Name: | ISC_TMP_BOOK_SUM2 |
---|---|
Object Type: | TABLE |
Owner: | ISC |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 30 |
PCT Used: |
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 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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;
ISC.ISC_TMP_BOOK_SUM2 does not reference any database object
ISC.ISC_TMP_BOOK_SUM2 is referenced by following:
|
|
|