[Home] [Help] [Dependency Information]
Object Name: | OPI_DBI_INV_ITEM_COSTS_TMP |
---|---|
Object Type: | TABLE |
Owner: | OPI |
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: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Yes | Organization ID as in the OLTP system. | |
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory Item ID as in the OLTP system. | |
ITEM_COST | NUMBER | Inventory Item Unit Cost. | ||
COST_METHOD | NUMBER | Yes | Cost Method used in the organization: 1 is Standard, 2 is Average. | |
CREATION_DATE | DATE | Yes | Creation Date. | |
LAST_UPDATE_DATE | DATE | Yes | Last Update Date. | |
CREATED_BY | NUMBER | Yes | Standard WHO column. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO column. | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO column. | ||
COST_GROUP_ID | NUMBER | Cost Group ID as reported in the OLTP system. |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, INVENTORY_ITEM_ID
, ITEM_COST
, COST_METHOD
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, COST_GROUP_ID
FROM OPI.OPI_DBI_INV_ITEM_COSTS_TMP;
OPI.OPI_DBI_INV_ITEM_COSTS_TMP does not reference any database object
OPI.OPI_DBI_INV_ITEM_COSTS_TMP is referenced by following:
|
|
|