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_RECOGNITION_LINES

Object Details

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

This table is populated with data from Order Management (OM) and Oracle Receivables (AR) about the revenue recognition percentage for a given OM line. AR data is loaded via an API they provide during the 2nd phase of the Generate COGS Recognition Events concurrent request. OM data is loaded via a Costing API that is called by OM when an order line gets closed that was never invoiced (see the functional design for more details). The main purpose of the table is to store a revenue recognition percent for each OM line and accounting period. Thus the primary key of the table is REVENUE_OM_LINE_ID + ACCT_PERIOD_NUM. The Matching program will compare the information in this table with the latest percentage in CST_COGS_EVENTS for each period, and use any differences to build COGS Recognition events.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_REV_REC_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REVENUE_OM_LINE_ID ACCT_PERIOD_NUM
CST_REV_REC_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POTENTIALLY_UNMATCHED_FLAG
CST_REV_REC_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEDGER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REVENUE_OM_LINE_ID	NUMBER		Yes	Order Line from oe_order_lines_all for which a revenue recognition percentage is relevant (determined by whether the line is invoicable or whether it's the top model of a configuration).
ACCT_PERIOD_NUM	NUMBER		Yes	Unique representation of an accounting period for a given set of books and application ID. Corresponds to GL_PERIOD_STATUSES.EFFECTIVE_PERIOD_NUM.
POTENTIALLY_UNMATCHED_FLAG	VARCHAR2	(1)		Indicator that is set to 'Y' whenever an action is taken that may have resulted in a Revenue/COGS mismatch. Cleared to NULL after the concurrent request is run to match revenue and COGS.
REVENUE_RECOGNITION_PERCENT	NUMBER		Yes	The latest known revenue recognition percentage for this OM line and accounting period.
LAST_EVENT_DATE	DATE		Yes	The GL date corresponding to this revenue recognition percentage.
OPERATING_UNIT_ID	NUMBER		Yes	Operating Unit
LEDGER_ID	NUMBER		Yes	Ledger identifier
INVENTORY_ITEM_ID	NUMBER			Item unique identifier
CUSTOMER_TRX_LINE_ID	NUMBER			Invoice line number
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 REVENUE_OM_LINE_ID
,      ACCT_PERIOD_NUM
,      POTENTIALLY_UNMATCHED_FLAG
,      REVENUE_RECOGNITION_PERCENT
,      LAST_EVENT_DATE
,      OPERATING_UNIT_ID
,      LEDGER_ID
,      INVENTORY_ITEM_ID
,      CUSTOMER_TRX_LINE_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_REVENUE_RECOGNITION_LINES;

Dependencies

[top of page]

BOM.CST_REVENUE_RECOGNITION_LINES does not reference any database object

BOM.CST_REVENUE_RECOGNITION_LINES is referenced by following:

BOM: CST_REVENUE_RECOGNITION_LINES#