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

VIEW: OSM.AS_LEADS_LOG#

Object Details
Object Name: AS_LEADS_LOG#
Object Type: VIEW
Owner: OSM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
LOG_ID NUMBER
Yes
LEAD_ID NUMBER
Yes
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

STATUS_CODE VARCHAR2 (30)
SALES_STAGE_ID NUMBER

WIN_PROBABILITY NUMBER

DECISION_DATE DATE

SECURITY_GROUP_ID NUMBER

LOG_MODE VARCHAR2 (1)
CUSTOMER_ID NUMBER

ADDRESS_ID NUMBER

CHANNEL_CODE VARCHAR2 (240)
CURRENCY_CODE VARCHAR2 (240)
TOTAL_AMOUNT NUMBER

DESCRIPTION VARCHAR2 (240)
SOURCE_PROMOTION_ID NUMBER

OFFER_ID NUMBER

CLOSE_COMPETITOR_ID NUMBER

VEHICLE_RESPONSE_CODE VARCHAR2 (30)
SALES_METHODOLOGY_ID NUMBER

OWNER_SALESFORCE_ID NUMBER

OWNER_SALES_GROUP_ID NUMBER

ORG_ID NUMBER

LOG_START_DATE DATE

LOG_END_DATE DATE

LOG_ACTIVE_DAYS NUMBER

ENDDAY_LOG_FLAG VARCHAR2 (1)
CURRENT_LOG NUMBER

OBJECT_VERSION_NUMBER NUMBER

Query Text

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


SELECT LOG_ID
,      LEAD_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      STATUS_CODE
,      SALES_STAGE_ID
,      WIN_PROBABILITY
,      DECISION_DATE
,      SECURITY_GROUP_ID
,      LOG_MODE
,      CUSTOMER_ID
,      ADDRESS_ID
,      CHANNEL_CODE
,      CURRENCY_CODE
,      TOTAL_AMOUNT
,      DESCRIPTION
,      SOURCE_PROMOTION_ID
,      OFFER_ID
,      CLOSE_COMPETITOR_ID
,      VEHICLE_RESPONSE_CODE
,      SALES_METHODOLOGY_ID
,      OWNER_SALESFORCE_ID
,      OWNER_SALES_GROUP_ID
,      ORG_ID
,      LOG_START_DATE
,      LOG_END_DATE
,      LOG_ACTIVE_DAYS
,      ENDDAY_LOG_FLAG
,      CURRENT_LOG
,      OBJECT_VERSION_NUMBER
FROM OSM.AS_LEADS_LOG#;

Dependencies

[top of page]

OSM.AS_LEADS_LOG# references the following:

SchemaOSM
TableAS_LEADS_LOG
OSM.AS_LEADS_LOG# is referenced by following:

SchemaAPPS
SynonymAS_LEADS_LOG