[Home] [Help] [Dependency Information]
Object Name: | OPI_DBI_COGS_F |
---|---|
Object Type: | TABLE |
Owner: | OPI |
Subobject Name: | |
Status: | VALID |
Stores Cost of Goods Sold Values for all Order Lines, Items and Customers.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OPI_DBI_COGS_F_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | CUSTOMER_ID |
OPI_DBI_COGS_F_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | ORDER_LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory Item Identifier | |
ORGANIZATION_ID | NUMBER | Yes | Inventory Organization ID | |
ORDER_LINE_ID | NUMBER | Sales Order Line ID | ||
TOP_MODEL_LINE_ID | NUMBER | Yes | Sales Order Line ID pointing to OE_ORDER_LINES_ALL | |
TOP_MODEL_ITEM_ID | NUMBER | Yes | Top Model Item ID | |
TOP_MODEL_ITEM_UOM | VARCHAR2 | (30) | UOM of Top Model Item | |
TOP_MODEL_ORG_ID | NUMBER | Yes | Organization ID of Top Model Item | |
CUSTOMER_ID | NUMBER | Yes | Customer Identifier | |
COGS_VAL_B | NUMBER | COGS Value in Functional Currency | ||
COGS_VAL_G | NUMBER | COGS Value in Global Currency | ||
COGS_DATE | DATE | Date that COGS recognized | ||
SOURCE | NUMBER | 1 for Descrete Manufacturing and 2 for Process Manufacturing | ||
TURNS_COGS_FLAG | NUMBER | Flag to indicate the COGS belong to Turns | ||
CREATION_DATE | DATE | Standard Who Column | ||
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
CREATED_BY | NUMBER | Standard Who Column | ||
LAST_UPDATED_BY | NUMBER | Standard Who Column | ||
LAST_UPDATED_LOGIN | NUMBER | Standard Who Column | ||
REQUEST_ID | NUMBER | (15) | Standard Who Column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who Column | |
PROGRAM_ID | NUMBER | (15) | Standard Who Column | |
PROGRAM_UPDATE_DATE | DATE | OBOSOLETE. Standard Who Column | ||
COGS_VAL_SG | NUMBER | COGS Value in secondary global currency | ||
COGS_VAL_B_DRAFT | NUMBER | COGS Value in Functional Currency. For discrete organizations, it is 0. For process organizations, it is the value posted to draft mode in the subledger. | ||
PROGRAM_LOGIN_ID | NUMBER | Standard Who Column | ||
INTERNAL_FLAG | NUMBER | INTERNAL_FLAG |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, ORGANIZATION_ID
, ORDER_LINE_ID
, TOP_MODEL_LINE_ID
, TOP_MODEL_ITEM_ID
, TOP_MODEL_ITEM_UOM
, TOP_MODEL_ORG_ID
, CUSTOMER_ID
, COGS_VAL_B
, COGS_VAL_G
, COGS_DATE
, SOURCE
, TURNS_COGS_FLAG
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATED_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, COGS_VAL_SG
, COGS_VAL_B_DRAFT
, PROGRAM_LOGIN_ID
, INTERNAL_FLAG
FROM OPI.OPI_DBI_COGS_F;
OPI.OPI_DBI_COGS_F does not reference any database object
OPI.OPI_DBI_COGS_F is referenced by following:
|
|
|