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

TABLE: OPI.OPI_DBI_COGS_FSTG

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


Stores all relevant dimension information and quantity/unit cost values for COGS


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item ID.
ORGANIZATION_ID NUMBER
Yes Organization ID.
ORDER_LINE_ID NUMBER

Order Line ID.
TOP_MODEL_LINE_ID NUMBER
Yes Top Model Line ID.
TOP_MODEL_ITEM_ID NUMBER
Yes Top Model Item ID.
TOP_MODEL_ITEM_UOM VARCHAR2 (30)
Top Model Item UOM.
TOP_MODEL_ORG_ID NUMBER
Yes Top Model Organization ID.
CUSTOMER_ID NUMBER
Yes Customer ID.
COGS_VAL_B NUMBER

COGS Value in Functional Currency.
COGS_DATE DATE

COGS Date.
SOURCE NUMBER

Data Source.
TURNS_COGS_FLAG NUMBER

Turns COGS Flag.
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.
INTERNAL_FLAG NUMBER

Query Text

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_DATE
,      SOURCE
,      TURNS_COGS_FLAG
,      COGS_VAL_B_DRAFT
,      INTERNAL_FLAG
FROM OPI.OPI_DBI_COGS_FSTG;

Dependencies

[top of page]

OPI.OPI_DBI_COGS_FSTG does not reference any database object

OPI.OPI_DBI_COGS_FSTG is referenced by following:

SchemaAPPS
SynonymOPI_DBI_COGS_FSTG