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

TABLE: BOM.CST_COGS_QTY_ADJ_EVENTS_TEMP

Object Details
Object Name: CST_COGS_QTY_ADJ_EVENTS_TEMP
Object Type: TABLE
Owner: BOM
FND Design Data: TableBOM.CST_COGS_QTY_ADJ_EVENTS_TEMP
Subobject Name:
Status: VALID

Global Temporary table used for matching COGS to Revenue in the package CST_RevenueCogsMatch_PVT. This table specifically helps create bulk quantity adjustment events which may result from backdated RMA receipts.

Temporary Table Details

BOM.CST_COGS_QTY_ADJ_EVENTS_TEMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
ADJ_EVENT_ID NUMBER

ADJ_MMT_TXN_ID NUMBER

ADJ_COGS_OM_LINE_ID NUMBER

ADJ_RMA_OM_LINE_ID NUMBER

ADJ_EVENT_DATE DATE

ADJ_NEW_COGS_PERCENTAGE NUMBER

ADJ_PRIOR_COGS_PERCENTAGE NUMBER

ADJ_EVENT_QUANTITY NUMBER

PARENT_EVENT_ID NUMBER

INVENTORY_ITEM_ID NUMBER

PRIMARY_UOM VARCHAR2 (3)
ORGANIZATION_ID NUMBER

COST_GROUP_ID NUMBER

COGS_ACCT_ID NUMBER

OPM_ORG_FLAG VARCHAR2 (1)
ACCT_PERIOD_ID NUMBER

Query Text

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


SELECT ADJ_EVENT_ID
,      ADJ_MMT_TXN_ID
,      ADJ_COGS_OM_LINE_ID
,      ADJ_RMA_OM_LINE_ID
,      ADJ_EVENT_DATE
,      ADJ_NEW_COGS_PERCENTAGE
,      ADJ_PRIOR_COGS_PERCENTAGE
,      ADJ_EVENT_QUANTITY
,      PARENT_EVENT_ID
,      INVENTORY_ITEM_ID
,      PRIMARY_UOM
,      ORGANIZATION_ID
,      COST_GROUP_ID
,      COGS_ACCT_ID
,      OPM_ORG_FLAG
,      ACCT_PERIOD_ID
FROM BOM.CST_COGS_QTY_ADJ_EVENTS_TEMP;

Dependencies

[top of page]

BOM.CST_COGS_QTY_ADJ_EVENTS_TEMP does not reference any database object

BOM.CST_COGS_QTY_ADJ_EVENTS_TEMP is referenced by following:

SchemaAPPS
SynonymCST_COGS_QTY_ADJ_EVENTS_TEMP