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_FS_INV_USG_VALUE_F

Object Details

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

This is the fact table that will contain the Field Service inventory usage transactions for all Field Service Usable subinventories at the organization, subinventory, transaction date and inventory item level. Usage transaction types are determined for every Field Service subnventory, being the default transaction type: 93 or Field Service Usage. It contains the transaction values in functional currency and has the conversion rates to the primary and secondary global currencies.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ISC_FS_INV_USG_VALUE_F_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORGANIZATION_ID SUBINVENTORY_CODE INVENTORY_ITEM_ID TRANSACTION_DATE

Columns

Name	Datatype	Length	Comments
ORGANIZATION_ID	NUMBER		Organization ID as in the OLTP system
SUBINVENTORY_CODE	VARCHAR2	(10)	Subinventory Code as in the OLTP system
TRANSACTION_DATE	DATE		Transaction date
INVENTORY_ITEM_ID	NUMBER		Inventory Item Id
ONHAND_VALUE_B	NUMBER		Inventory Value in functional currency
PRIM_CONVERSION_RATE	NUMBER		Rate to convert from Functional Currency to DBI Primary Global Currency
SEC_CONVERSION_RATE	NUMBER		Conversion rate of DBI Secondary Global Currency
CREATED_BY	NUMBER		Standard who column
CREATION_DATE	DATE		Standard who column
LAST_UPDATE_DATE	DATE		Standard who column
LAST_UPDATED_BY	NUMBER		Standard who column
LAST_UPDATE_LOGIN	NUMBER		Standard who column
PROGRAM_ID	NUMBER		Standard who column
PROGRAM_LOGIN_ID	NUMBER		Standard who column
PROGRAM_APPLICATION_ID	NUMBER		Standard who column
REQUEST_ID	NUMBER		Standard who column

Query Text

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


SELECT ORGANIZATION_ID
,      SUBINVENTORY_CODE
,      TRANSACTION_DATE
,      INVENTORY_ITEM_ID
,      ONHAND_VALUE_B
,      PRIM_CONVERSION_RATE
,      SEC_CONVERSION_RATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM ISC.ISC_FS_INV_USG_VALUE_F;

Dependencies

[top of page]

ISC.ISC_FS_INV_USG_VALUE_F does not reference any database object

ISC.ISC_FS_INV_USG_VALUE_F is referenced by following:

APPS: ISC_FS_015_MV; ISC_FS_INV_USG_VALUE_F