DBA Data[Home] [Help] [Dependency Information]

TABLE: OPI.OPI_DBI_COGS_STG

Object Details
Object Name: OPI_DBI_COGS_STG
Object Type: TABLE
Owner: OPI
Subobject Name:
Status: VALID


This is a table to store data for product gross margin.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OPI_DBI_COGS_STG_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnORDER_LINE_ID
Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER

Inventory Item Id .
ORGANIZATION_ID NUMBER

Inventory Organization Id .
ORDER_LINE_ID NUMBER

Order Line Id.
MARGIN_OU_ID NUMBER

Margin Operating Unit Id.
COGS_VAL_B NUMBER

COGS value in base currency.
COGS_DATE DATE

COGS Date .
COGS_CURRENCY_CODE VARCHAR2 (30)
Currency Code for COGS.
COGS_CONVERSION_RATE NUMBER

Conversion rate for COGS from base currency to global currency .
SHIP_OU_ID NUMBER

Shipping Operating Unit Id.
SELL_OU_ID NUMBER

Selling Operating Unit Id.
TURNS_COGS_FLAG VARCHAR2 (10)
Indicate if the COGS data is relevant for Inventory Turns computation. Default to Y.
SOURCE VARCHAR2 (30)
Source.
CREATION_DATE DATE

Creation Date.
LAST_UPDATE_DATE DATE

Last Update Date.
CREATED_BY NUMBER

Standard who column.
LAST_UPDATED_BY NUMBER

Standard who column.
LAST_UPDATE_LOGIN NUMBER

Standard who column.
Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      ORDER_LINE_ID
,      MARGIN_OU_ID
,      COGS_VAL_B
,      COGS_DATE
,      COGS_CURRENCY_CODE
,      COGS_CONVERSION_RATE
,      SHIP_OU_ID
,      SELL_OU_ID
,      TURNS_COGS_FLAG
,      SOURCE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM OPI.OPI_DBI_COGS_STG;

Dependencies

[top of page]

OPI.OPI_DBI_COGS_STG does not reference any database object

OPI.OPI_DBI_COGS_STG is referenced by following:

SchemaAPPS
SynonymOPI_DBI_COGS_STG