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_COGS_EVENTS

Object Details

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

This is the accounting events table for all types of events impacting Cost of Goods Sold. That includes sales order issues, RMA receipts, COGS Recognition events, and COGS Adjustment events resulting from backdated COGS events. This table maintains the quantities, percentages, and percentage changes necessary to build the accounting distributions for an event. It also links all of the related COGS events together by order line ID, and builds the sequential relationships between these events using the prior event ID and prior COGS percentage. Thus it serves two important purposes: 1) Provides the information necessary to create accounting distributions around COGS events, and 2) Assists in the creation of additional COGS events by providing the latest recorded COGS percentage for a given order line. This second role is accomplished with the help of two additional tables - CST_REVENUE_COGS_MATCH_LINES and CST_REVENUE_RECOGNITION_LINES - during the Generate COGS Recognition Events concurrent request.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_COGS_EVENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EVENT_ID
CST_COGS_EVENTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	MMT_TRANSACTION_ID
CST_COGS_EVENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COGS_OM_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EVENT_ID	NUMBER		Yes	Unique identifier for a COGS event row in this table.
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.
EVENT_DATE	DATE		Yes	Truncated date of the COGS event. For COGS recognition event types, it corresponds to the Oracle Receivables GL date of the revenue recognition event.
MMT_TRANSACTION_ID	NUMBER			All of the types of events in this table except for RMA placeholders have a corresponding transaction in mtl_material_transactions.
COGS_PERCENTAGE	NUMBER		Yes	The percentage of the total outstanding cost of an order line shipment that is recognized as Cost of Goods Sold.
PRIOR_COGS_PERCENTAGE	NUMBER			The amount of COGS recognized by the previous COGS event in the sequence. It stores the same value as the cogs_percentage in the event pointed to by prior_event_id.
PRIOR_EVENT_ID	NUMBER			For a given COGS_OM_LINE_ID, all events impacting COGS all into a sequence that is built using this column. The original sales order itself will not have a prior_event_id as it is the starting point.
EVENT_TYPE	NUMBER		Yes	Specifies the type of COGS event: (1) Sales Order Issue (2) RMA Receipt (3) COGS Recognition Event (4) COGS Rec. Percent Adjustment (5) COGS Rec. Qty. Adj. (6) RMA placeholder
EVENT_OM_LINE_ID	NUMBER			Holds oe_order_lines_all.line_id of the OM event which was the source of this COGS event. It will only be populated for sales order issues and RMA receipts.
EVENT_QUANTITY	NUMBER		Yes	Quantity affected by the COGS event
COSTED	VARCHAR2	(1)		Set to 'N' until the event is processed and accounting is created, at which point it is set ot NULL.
PARENT_EVENT_ID	NUMBER		Yes	All quantity adjustments (such as RMAs and COGS Rec. Qty. Adj. events) are constructed as child events of a single parent. These child events do store a prior_event_id as they are not directly in the chain of COGS events. To find the quantity for a given node on the event chain, total up all of the quantity for a given parent_event_id. Note for parent events: parent_event_id = event_id.
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 EVENT_ID
,      COGS_OM_LINE_ID
,      EVENT_DATE
,      MMT_TRANSACTION_ID
,      COGS_PERCENTAGE
,      PRIOR_COGS_PERCENTAGE
,      PRIOR_EVENT_ID
,      EVENT_TYPE
,      EVENT_OM_LINE_ID
,      EVENT_QUANTITY
,      COSTED
,      PARENT_EVENT_ID
,      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_COGS_EVENTS;

Dependencies

[top of page]

BOM.CST_COGS_EVENTS does not reference any database object

BOM.CST_COGS_EVENTS is referenced by following:

BOM: CST_COGS_EVENTS#