[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OPI_EDW_COGS_F |
|---|---|
| Object Type: | TABLE |
| Owner: | OPI |
| FND Design Data: |  OPI.OPI_EDW_COGS_F
|
| Subobject Name: | |
| Status: | VALID |
The COGS Shipment Fact provides cost of goods sold information based on inventory activities like shipment transactions and Return Material Authorization (RMA) transactions. The effects of intercompany invoicing is also considered. For this scope of data, relevant shipment information is also provided. Data is retrieved from tables in OE, SHP, INV, CST. Shipment, RMA, intercompany related COGS dollar value and the associated item quantity are provided. In the case of shipment transactions, measures like lead time and number of order lines are computed based on various transaction date criteria (e.g. promised date, requested date, etc.) Other attribute information, like order number, waybill number, revision and lot number, is also available. Data in this Fact is kept at shipment line details level. COGS value is obtained from material account distributions and is split based on shipped quantity at the shipment line details level. COGS value in MTL_TRANSACTION_ACCOUNTS can be kept at cost element level. The item quantity of the corresponding COGS account is returned only for material cost element or in some cases when there is no cost element level details. In other words, COGS distribution lines which have cost elements material overhead, resources, overhead and OSP will return zero COGS related item quantity. Total COGS value is calculated by aggregating COGS values of sales orders, RMA transactions and intercompany account payable invoices.
| Tablespace: |  APPS_TS_SUMMARY |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OPI_EDW_COGS_F_PK | NORMAL | UNIQUE |
APPS_TS_SUMMARY
|
 COGS_PK_KEY
|
| OPI_EDW_COGS_F_U1 | NORMAL | UNIQUE |
APPS_TS_SUMMARY
|
COGS_PK
COGS_PK_KEY
|
| OPI_EDW_COGS_F_N1 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
ORDER_LINE_ID
|
| OPI_EDW_COGS_F_N10 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
CUSTOMER_FK_KEY
|
| OPI_EDW_COGS_F_N11 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
DATE_BOOKED_FK_KEY
|
| OPI_EDW_COGS_F_N12 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
DATE_PROMISED_FK_KEY
|
| OPI_EDW_COGS_F_N13 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
DATE_REQUESTED_FK_KEY
|
| OPI_EDW_COGS_F_N14 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
DATE_SCHEDULED_FK_KEY
|
| OPI_EDW_COGS_F_N15 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
DATE_SHIPPED_FK_KEY
|
| OPI_EDW_COGS_F_N16 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
GL_SET_OF_BOOKS_FK_KEY
|
| OPI_EDW_COGS_F_N17 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
INSTANCE_FK_KEY
|
| OPI_EDW_COGS_F_N18 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
INV_ORG_FK_KEY
|
| OPI_EDW_COGS_F_N19 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
ITEM_ORG_FK_KEY
|
| OPI_EDW_COGS_F_N2 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
BASE_UOM_FK_KEY
|
| OPI_EDW_COGS_F_N20 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
LOCATOR_FK_KEY
|
| OPI_EDW_COGS_F_N21 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
MARKET_SEGMENT_FK_KEY
|
| OPI_EDW_COGS_F_N22 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
MEDCHN_ACTL_FK_KEY
|
| OPI_EDW_COGS_F_N23 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
MEDCHN_INIT_FK_KEY
|
| OPI_EDW_COGS_F_N24 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
MONTH_BOOKED_FK_KEY
|
| OPI_EDW_COGS_F_N25 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
OFFER_HDR_FK_KEY
|
| OPI_EDW_COGS_F_N26 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
OFFER_LINE_FK_KEY
|
| OPI_EDW_COGS_F_N27 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
OPERATING_UNIT_FK_KEY
|
| OPI_EDW_COGS_F_N28 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
ORDER_CATEGORY_FK_KEY
|
| OPI_EDW_COGS_F_N3 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
BILL_TO_LOC_FK_KEY
|
| OPI_EDW_COGS_F_N30 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
ORDER_SOURCE_FK_KEY
|
| OPI_EDW_COGS_F_N31 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
ORDER_TYPE_FK_KEY
|
| OPI_EDW_COGS_F_N32 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
PRIM_SALES_REP_FK_KEY
|
| OPI_EDW_COGS_F_N33 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
PROJECT_FK_KEY
|
| OPI_EDW_COGS_F_N34 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
SALES_CHANNEL_FK_KEY
|
| OPI_EDW_COGS_F_N35 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
SHIP_INV_LOCATOR_FK_KEY
|
| OPI_EDW_COGS_F_N36 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
SHIP_TO_LOC_FK_KEY
|
| OPI_EDW_COGS_F_N37 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
SHIP_TO_SITE_FK_KEY
|
| OPI_EDW_COGS_F_N39 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
TARGET_SEGMENT_ACTL_FK_KEY
|
| OPI_EDW_COGS_F_N4 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
BILL_TO_SITE_FK_KEY
|
| OPI_EDW_COGS_F_N40 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
TARGET_SEGMENT_INIT_FK_KEY
|
| OPI_EDW_COGS_F_N41 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
TASK_FK_KEY
|
| OPI_EDW_COGS_F_N42 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
TOP_MODEL_ITEM_FK_KEY
|
| OPI_EDW_COGS_F_N43 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
TRX_CURRENCY_FK_KEY
|
| OPI_EDW_COGS_F_N5 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
CAMPAIGN_ACTL_FK_KEY
|
| OPI_EDW_COGS_F_N6 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
CAMPAIGN_INIT_FK_KEY
|
| OPI_EDW_COGS_F_N7 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
CAMPAIGN_STATUS_ACTL_FK_KEY
|
| OPI_EDW_COGS_F_N8 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
CAMPAIGN_STATUS_INIT_FK_KEY
|
| OPI_EDW_COGS_F_N9 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
COGS_DATE_FK_KEY
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| DATE_SCHEDULED_FK_KEY | NUMBER | System generated foreign key to the time dimension (Date Scheduled) | ||
| DATE_REQUESTED_FK_KEY | NUMBER | System generated foreign key to the time dimension (Date Requested) | ||
| DATE_PROMISED_FK_KEY | NUMBER | System generated foreign key to the time dimension (Date Promised) | ||
| DATE_BOOKED_FK_KEY | NUMBER | System generated foreign key to the time dimension (Date Booked) | ||
| MONTH_BOOKED_FK_KEY | NUMBER | System generated foreign key to the time dimension (Month Booked) | ||
| TASK_FK_KEY | NUMBER | System generated foreign key to the project dimension (Task) | ||
| PROJECT_FK_KEY | NUMBER | System generated foreign key to the project dimension (Project) | ||
| OPERATING_UNIT_FK_KEY | NUMBER | System generated foreign key to the internal organization dimension (Operating Unit) | ||
| INV_ORG_FK_KEY | NUMBER | System generated foreign key to the internal organization dimension (Inventory Organization) | ||
| RMA_QTY_B | NUMBER | RMA Quantity in Base UOM | ||
| REQ_LATE_VAL_G | NUMBER | COGS value with shipped date later than requested date | ||
| REQ_LATE_COUNT | NUMBER | Number of order lines with shipped date later than requested date | ||
| REQ_EARLY_VAL_G | NUMBER | COGS value with shipped date no later than requested date | ||
| REQ_EARLY_COUNT | NUMBER | Number of order lines with shipped date no later than requested date | ||
| REQUEST_LEAD_TIME | NUMBER | Days between Date Shipped and Date Requested | ||
| PROM_LATE_VAL_G | NUMBER | COGS value with shipped date later than promised date | ||
| PROM_LATE_COUNT | NUMBER | Number of order lines with shipped date later than promised date | ||
| PROM_EARLY_VAL_G | NUMBER | COGS value with shipped date no later than promised date | ||
| PROM_EARLY_COUNT | NUMBER | Number of order lines with shipped date no later than promised date | ||
| PROMISE_LEAD_TIME | NUMBER | Days between Date Shipped and Date Promised | ||
| ORDER_NUMBER | NUMBER | User Visible Order Identifier | ||
| ORDER_LEAD_TIME | NUMBER | Days between Date Shipped and Date Booked | ||
| ICAP_QTY_B | NUMBER | Intercompany Account Payable Invoiced Quantity in Base UOM | ||
| COST_ELEMENT | NUMBER | Cost element identifier | ||
| COGS_T | NUMBER | Cost of Good Sold in Transaction currency | ||
| COGS_PK_KEY | NUMBER | Yes | System generated unique identifier | |
| COGS_G | NUMBER | Cost of Good Sold in warehouse currency | ||
| COGS_B | NUMBER | Cost of Good Sold in set of books currency | ||
| ACCOUNT | NUMBER | Account Identifier | ||
| BASE_UOM_FK_KEY | NUMBER | System generated foreign key to the UOM dimension (Base UOM) | ||
| LOCATOR_FK_KEY | NUMBER | System generated foreign key to the invetory location dimension (Locator) | ||
| ORDER_SOURCE_FK_KEY | NUMBER | System generated foreign key to the lookup dimension (Order Source) | ||
| ORDER_TYPE_FK_KEY | NUMBER | System generated foreign key to the lookup dimension (Order Type) | ||
| ORDER_CATEGORY_FK_KEY | NUMBER | System generated foreign key to the lookup dimension (Order Category) | ||
| TOP_MODEL_ITEM_FK_KEY | NUMBER | System generated foreign key to the item dimension (Top Model Item) | ||
| ITEM_ORG_FK_KEY | NUMBER | System generated foreign key to the item dimension (Item of an organization) | ||
| INSTANCE_FK_KEY | NUMBER | System generated foreign key to the instance dimension (source instance) | ||
| PRIM_SALES_REP_FK_KEY | NUMBER | System generated foreign key to the HR Person dimension (Primary Sales Rep) | ||
| GL_SET_OF_BOOKS_FK_KEY | NUMBER | System generated foreign key to the Set of Books dimension (GL Set of Books) | ||
| SHIP_TO_LOC_FK_KEY | NUMBER | System generated foreign key to the geography dimension (Ship To Location) | ||
| BILL_TO_LOC_FK_KEY | NUMBER | System generated foreign key to the geography dimension (Bill To Location) | ||
| BASE_CURRENCY_FK_KEY | NUMBER | System generated foreign key to the currency dimension (Base Currency) | ||
| TRX_CURRENCY_FK_KEY | NUMBER | System generated foreign key to the currency dimension (Transaction Currency) | ||
| TARGET_SEGMENT_INIT_FK_KEY | NUMBER | System generated foreign key to the target segment dimension (Target Segment Attributed) | ||
| TARGET_SEGMENT_ACTL_FK_KEY | NUMBER | System generated foreign key to the target segment dimension (Target Segment Actual) | ||
| SALES_CHANNEL_FK_KEY | NUMBER | System generated foreign key to the sales channel dimension (Sales Channel) | ||
| USER_MEASURE5 | NUMBER | User defined measure | ||
| USER_MEASURE4 | NUMBER | User defined measure | ||
| USER_MEASURE3 | NUMBER | User defined measure | ||
| USER_MEASURE2 | NUMBER | User defined measure | ||
| USER_MEASURE1 | NUMBER | User defined measure | ||
| USER_FK5_KEY | NUMBER | User defined dimension foreign key | ||
| USER_FK4_KEY | NUMBER | User defined dimension foreign key | ||
| USER_FK3_KEY | NUMBER | User defined dimension foreign key | ||
| USER_FK2_KEY | NUMBER | User defined dimension foreign key | ||
| USER_FK1_KEY | NUMBER | User defined dimension foreign key | ||
| SHIP_TO_SITE_FK_KEY | NUMBER | System generated foreign key to the trading partner dimension (Ship To Site) | ||
| CUSTOMER_FK_KEY | NUMBER | System generated foreign key to the trading partner dimension (Customer) | ||
| BILL_TO_SITE_FK_KEY | NUMBER | System generated foreign key to the trading partner dimension (Bill To Site) | ||
| DATE_SHIPPED_FK_KEY | NUMBER | System generated foreign key to the time dimension (Date Shipped) | ||
| OFFER_HDR_FK_KEY | NUMBER | System generated foreign key to the Offer dimension (Header Level Offer) | ||
| OFFER_LINE_FK_KEY | NUMBER | System generated foreign key to the Offer dimension (Line Level Offer) | ||
| MARKET_SEGMENT_FK_KEY | NUMBER | System generated foreign key to the market segment dimension (Market Segment Offer) | ||
| MEDCHN_INIT_FK_KEY | NUMBER | System generated foreign key to the Media Channel dimension (Media Channel Attributed) | ||
| MEDCHN_ACTL_FK_KEY | NUMBER | System generated foreign key to the Media Channel dimension (Media Channel Actual) | ||
| CAMPAIGN_ACTL_FK_KEY | NUMBER | System generated foreign key to the Campaign dimension (Campaign Actual) | ||
| CAMPAIGN_INIT_FK_KEY | NUMBER | System generated foreign key to the Campaign dimension (Campaign Attributed) | ||
| SHIPPED_QTY_B | NUMBER | Shipped Quantity in Base UOM | ||
| RMA_VALUE_T | NUMBER | RMA value in Transaction currency | ||
| RMA_VALUE_G | NUMBER | RMA value in warehouse currency | ||
| REVISION | VARCHAR2 | (40) | Item revision number | |
| LOT | VARCHAR2 | (40) | Item lot number | |
| COGS_PK | VARCHAR2 | (120) | Unique identifer | |
| WAYBILL_NUMBER | VARCHAR2 | (40) | Waybill number | |
| USER_ATTRIBUTE9 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE8 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE7 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE6 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE15 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE14 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE13 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE12 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE11 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE10 | VARCHAR2 | (240) | User defined attribute | |
| USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
| SERIAL_NUMBER | VARCHAR2 | (40) | Serial number | |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
| CREATION_DATE | DATE | Yes | Standard who column | |
| CAMPAIGN_STATUS_ACTL_FK_KEY | NUMBER | System generated foreign key to Campaign Status dimension (actual status) | ||
| CAMPAIGN_STATUS_INIT_FK_KEY | NUMBER | System generated foreign key to the Campaign Status dimension (initial status) | ||
| COGS_DATE | DATE | COGS recognition date | ||
| COGS_DATE_FK_KEY | NUMBER | System generated foreign key to the Time dimension | ||
| ORDER_LINE_ID | VARCHAR2 | (80) | Foreign key to the EDW_NA dimension | |
| SHIP_INV_LOCATOR_FK_KEY | NUMBER | System generated foreign key to the Inventory Location dimension | ||
| ORDER_DATE | DATE | ordered date | ||
| DELIVERY_ID | NUMBER | Delivery Id | ||
| PRIM_SALESRESOURCE_FK_KEY | NUMBER | System generated foreign key to the sales resource dimension (Primary Sales rep) |
Cut, paste (and edit) the following text to query this object:
SELECT DATE_SCHEDULED_FK_KEY
, DATE_REQUESTED_FK_KEY
, DATE_PROMISED_FK_KEY
, DATE_BOOKED_FK_KEY
, MONTH_BOOKED_FK_KEY
, TASK_FK_KEY
, PROJECT_FK_KEY
, OPERATING_UNIT_FK_KEY
, INV_ORG_FK_KEY
, RMA_QTY_B
, REQ_LATE_VAL_G
, REQ_LATE_COUNT
, REQ_EARLY_VAL_G
, REQ_EARLY_COUNT
, REQUEST_LEAD_TIME
, PROM_LATE_VAL_G
, PROM_LATE_COUNT
, PROM_EARLY_VAL_G
, PROM_EARLY_COUNT
, PROMISE_LEAD_TIME
, ORDER_NUMBER
, ORDER_LEAD_TIME
, ICAP_QTY_B
, COST_ELEMENT
, COGS_T
, COGS_PK_KEY
, COGS_G
, COGS_B
, ACCOUNT
, BASE_UOM_FK_KEY
, LOCATOR_FK_KEY
, ORDER_SOURCE_FK_KEY
, ORDER_TYPE_FK_KEY
, ORDER_CATEGORY_FK_KEY
, TOP_MODEL_ITEM_FK_KEY
, ITEM_ORG_FK_KEY
, INSTANCE_FK_KEY
, PRIM_SALES_REP_FK_KEY
, GL_SET_OF_BOOKS_FK_KEY
, SHIP_TO_LOC_FK_KEY
, BILL_TO_LOC_FK_KEY
, BASE_CURRENCY_FK_KEY
, TRX_CURRENCY_FK_KEY
, TARGET_SEGMENT_INIT_FK_KEY
, TARGET_SEGMENT_ACTL_FK_KEY
, SALES_CHANNEL_FK_KEY
, USER_MEASURE5
, USER_MEASURE4
, USER_MEASURE3
, USER_MEASURE2
, USER_MEASURE1
, USER_FK5_KEY
, USER_FK4_KEY
, USER_FK3_KEY
, USER_FK2_KEY
, USER_FK1_KEY
, SHIP_TO_SITE_FK_KEY
, CUSTOMER_FK_KEY
, BILL_TO_SITE_FK_KEY
, DATE_SHIPPED_FK_KEY
, OFFER_HDR_FK_KEY
, OFFER_LINE_FK_KEY
, MARKET_SEGMENT_FK_KEY
, MEDCHN_INIT_FK_KEY
, MEDCHN_ACTL_FK_KEY
, CAMPAIGN_ACTL_FK_KEY
, CAMPAIGN_INIT_FK_KEY
, SHIPPED_QTY_B
, RMA_VALUE_T
, RMA_VALUE_G
, REVISION
, LOT
, COGS_PK
, WAYBILL_NUMBER
, USER_ATTRIBUTE9
, USER_ATTRIBUTE8
, USER_ATTRIBUTE7
, USER_ATTRIBUTE6
, USER_ATTRIBUTE5
, USER_ATTRIBUTE4
, USER_ATTRIBUTE3
, USER_ATTRIBUTE2
, USER_ATTRIBUTE15
, USER_ATTRIBUTE14
, USER_ATTRIBUTE13
, USER_ATTRIBUTE12
, USER_ATTRIBUTE11
, USER_ATTRIBUTE10
, USER_ATTRIBUTE1
, SERIAL_NUMBER
, LAST_UPDATE_DATE
, CREATION_DATE
, CAMPAIGN_STATUS_ACTL_FK_KEY
, CAMPAIGN_STATUS_INIT_FK_KEY
, COGS_DATE
, COGS_DATE_FK_KEY
, ORDER_LINE_ID
, SHIP_INV_LOCATOR_FK_KEY
, ORDER_DATE
, DELIVERY_ID
, PRIM_SALESRESOURCE_FK_KEY
FROM OPI.OPI_EDW_COGS_F;
OPI.OPI_EDW_COGS_F does not reference any database object
OPI.OPI_EDW_COGS_F is referenced by following:
APPS
OPI_EDW_COGS_F
|
|
|
|