[Home] [Help] [Dependency Information]
Object Name: | OPI_DBI_OPM_COGSLED_CURRENT |
---|---|
Object Type: | TABLE |
Owner: | OPI |
Subobject Name: | |
Status: | VALID |
Work Table for DBI COGS extraction
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
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. |
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
FROM OPI.OPI_DBI_OPM_COGSLED_CURRENT;
OPI.OPI_DBI_OPM_COGSLED_CURRENT does not reference any database object
OPI.OPI_DBI_OPM_COGSLED_CURRENT is referenced by following:
|
|
|