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

TABLE: BOM.CST_REVENUE_COGS_CONTROL

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


Simple table used to keep track of the last successful run of the Generate COGS Events concurrent request. It starts out empty, and the first run of the request will populate the row which will track all subsequent runs of the request. This row is updated every time phase 2 of the request complete successfully. It is only used in the request parameter form to default the "From Date" of the request, thereby helping the user determine the lower bound of the date range for which to run the request.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CONTROL_ID NUMBER
Yes Set to 1 for the single row
LAST_PROCESS_UPTO_DATE DATE
Yes Date of the last successful run of phase 2 of the concurrent request.
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 CONTROL_ID
,      LAST_PROCESS_UPTO_DATE
,      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_CONTROL;

Dependencies

[top of page]

BOM.CST_REVENUE_COGS_CONTROL does not reference any database object

BOM.CST_REVENUE_COGS_CONTROL is referenced by following:

SchemaAPPS
SynonymCST_REVENUE_COGS_CONTROL