eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: BOM.CST_REVENUE_COGS_MATCH_LINES

Object Details

Object Name:	CST_REVENUE_COGS_MATCH_LINES
Object Type:	TABLE
Owner:	BOM
FND Design Data:	BOM.CST_REVENUE_COGS_MATCH_LINES
Subobject Name:
Status:	VALID

The primary purpose of this table is to store the relationship between COGS and revenue lines. For standard items this is usually the same line, but for configurations the COGS line is usually a shippable item (such as an included item) and the Revenue line is usually an invoicable item (such as a top model) and the two OM line IDs are many times different. So where the pac_cost_type_ID is NULL this table will have only one row for each COGS_OM_LINE_ID, essentially making it the primary key for non-PAC rows.
The secondary purpose of this table is to store the elemental and total unit costs for the item that is shipped orginially by the sales order issue, as well as the COGS and deferred COGS accounts. Then when costing subsequent events that refer to this original sales order (such as COGS Recognition events and RMA Receipts) these unit costs and accounts are readily available. It's important to store these since the subsequent related events must use the same unit costs and COGS accounts as the original sales issue. The row with NULL pac_cost_type_id stores the perpetual unit costs. PAC rows will populate the PAC_COST_TYPE_ID with the cost type ID so that you can have one row for each PAC cost type and COGS line ID combination.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_REV_COGS_MATCH_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	COGS_OM_LINE_ID PAC_COST_TYPE_ID
CST_REV_COGS_MATCH_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REVENUE_OM_LINE_ID
CST_REV_COGS_MATCH_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OPERATING_UNIT_ID SALES_ORDER_ISSUE_DATE

Columns

Name	Datatype	Mandatory	Comments
COGS_OM_LINE_ID	NUMBER	Yes	Reference to the line ID of the original sales order issue to which this COGS event applies. In Order Management's table: oe_order_lines.line_id.
PAC_COST_TYPE_ID	NUMBER		Each COGS OM LINE ID will have one row where this column is NULL (the perpetual row), and the remaining will have this populated with the Periodic Average Costing Cost Type ID.
REVENUE_OM_LINE_ID	NUMBER	Yes	Stores the OM Line ID that contains the relevant revenue recognition percentage that this COGS Line ID must match with.
DEFERRED_COGS_ACCT_ID	NUMBER	Yes	Stores the CCID of the Deferred COGS account which applies to this order line.
COGS_ACCT_ID	NUMBER	Yes	Stores the CCID of the COGS account which applies to this order line.
ORGANIZATION_ID	NUMBER	Yes	Unique identifier for the inventory organization of the sales order issue.
INVENTORY_ITEM_ID	NUMBER	Yes	Unique identifier of the inventory item.
OPERATING_UNIT_ID	NUMBER	Yes	Operating unit
COST_GROUP_ID	NUMBER		Cost group in which the original sales order issue was costed
LEDGER_ID	NUMBER	Yes	Ledger identifier
SALES_ORDER_ISSUE_DATE	DATE	Yes	Original sales order issue shipment date
UNIT_MATERIAL_COST	NUMBER		Elemental material cost per unit
UNIT_MOH_COST	NUMBER		Elemental material overhead cost per unit
UNIT_RESOURCE_COST	NUMBER		Elemental resource cost per unit
UNIT_OP_COST	NUMBER		Elemental outside processing cost per unit
UNIT_OVERHEAD_COST	NUMBER		Elemental overhead cost per unit
UNIT_COST	NUMBER		Total unit cost
ORIGINAL_SHIPPED_QTY	NUMBER		Quantity shipped for the sales order issue. If the sales issue is composed of multiple MMT transactions, this will contain the total quantity across those transactions.
LAST_UPDATE_DATE	DATE	Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	Yes	Standard Who Column
CREATION_DATE	DATE	Yes	Standard Who Column
CREATED_BY	NUMBER	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER		Standard Who Column
REQUEST_ID	NUMBER		Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER		Standard Who Column
PROGRAM_ID	NUMBER		Standard Who Column
PROGRAM_UPDATE_DATE	DATE		Standard Who Column

Query Text

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


SELECT COGS_OM_LINE_ID
,      PAC_COST_TYPE_ID
,      REVENUE_OM_LINE_ID
,      DEFERRED_COGS_ACCT_ID
,      COGS_ACCT_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      OPERATING_UNIT_ID
,      COST_GROUP_ID
,      LEDGER_ID
,      SALES_ORDER_ISSUE_DATE
,      UNIT_MATERIAL_COST
,      UNIT_MOH_COST
,      UNIT_RESOURCE_COST
,      UNIT_OP_COST
,      UNIT_OVERHEAD_COST
,      UNIT_COST
,      ORIGINAL_SHIPPED_QTY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM BOM.CST_REVENUE_COGS_MATCH_LINES;

Dependencies

[top of page]

BOM.CST_REVENUE_COGS_MATCH_LINES does not reference any database object

BOM.CST_REVENUE_COGS_MATCH_LINES is referenced by following:

APPS: CST_REVENUE_COGS_MATCH_LINES