[Home] [Help] [Dependency Information]
Object Name: | AS_LLOG_STATUS_SUMMARY |
---|---|
Object Type: | TABLE |
Owner: | OSM |
FND Design Data: | AS.AS_LLOG_STATUS_SUMMARY |
Subobject Name: | |
Status: | VALID |
This table store the status summary data for opprotunity aging reports. The summary
data is populated based on the source data in table AS_LEADS_LOG table.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AS_LLOG_STATUS_SUMMARY_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
LEAD_ID
STATUS_CODE |
AS_LLOG_STATUS_SUMMARY_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | LAST_UPDATE_DATE |
AS_LLOG_STATUS_SUMMARY_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | DECISION_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column | |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | Yes | Standard who column | |
REQUEST_ID | NUMBER | Standard who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Application identifier of last concurrent program to update record | ||
PROGRAM_ID | NUMBER | Identifier of last concurrent program to update record | ||
PROGRAM_UPDATE_DATE | DATE | Last date concurrent program updated record | ||
LEAD_ID | NUMBER | Yes | Lead Identifier | |
DECISION_DATE | DATE | The date that the purchase decision will be made by the prospect | ||
STATUS_CODE | VARCHAR2 | (30) | Yes | The status of the lead validated against as_statuses_vl |
STATUS_DAYS | NUMBER | Number of days the opportunity stayed in this status. For the cuttent status, the number of days counts to the date in column STATUS_END _DATE. | ||
STATUS_START_DATE | DATE | The date this status was first set for the opportunity. | ||
STATUS_END_DATE | DATE | The date the status was last stayed for this opportunity. For current status, this is the date the value of column STATUS_DAYS counts to. | ||
CURRENT_STATUS | NUMBER | Indicates if the status represent the current status of the opportunity. | ||
OBJECT_VERSION_NUMBER | NUMBER | Object Version Number |
Cut, paste (and edit) the following text to query this object:
SELECT LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, REQUEST_ID
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, LEAD_ID
, DECISION_DATE
, STATUS_CODE
, STATUS_DAYS
, STATUS_START_DATE
, STATUS_END_DATE
, CURRENT_STATUS
, OBJECT_VERSION_NUMBER
FROM OSM.AS_LLOG_STATUS_SUMMARY;
OSM.AS_LLOG_STATUS_SUMMARY does not reference any database object
OSM.AS_LLOG_STATUS_SUMMARY is referenced by following:
|
|
|