[Home] [Help] [Dependency Information]
Object Name: | ISC_FS_INV_USG_VALUE_STG |
---|---|
Object Type: | TABLE |
Owner: | ISC |
Subobject Name: | |
Status: | VALID |
This table is a staging table for obtaining Field Service inventory usage transactions in functional values. This table is needed as an intermediate step to calculate conversion rates and to stop the load into the fact table in case missing rates are found. This table will join to the ISC_FS_INV_USG_CONV_RATES table in order to obtain the primary and secondary global uom conversion rates for each organization, transaction date combination and insert into the fact table ISC_FS_INV_USG_VALUE_F.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | 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 | ||
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. |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, SUBINVENTORY_CODE
, TRANSACTION_DATE
, INVENTORY_ITEM_ID
, ONHAND_VALUE_B
, 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_STG;
ISC.ISC_FS_INV_USG_VALUE_STG does not reference any database object
ISC.ISC_FS_INV_USG_VALUE_STG is referenced by following:
|
|
|