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


VIEW: OSM.AS_SALES_LEADS#

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

[View Source]

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

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

LEAD_NUMBER VARCHAR2 (30) Yes
STATUS_CODE VARCHAR2 (30) Yes
CUSTOMER_ID NUMBER
Yes
ADDRESS_ID NUMBER

SOURCE_PROMOTION_ID NUMBER

INITIATING_CONTACT_ID NUMBER

ORIG_SYSTEM_REFERENCE VARCHAR2 (240)
CONTACT_ROLE_CODE VARCHAR2 (30)
CHANNEL_CODE VARCHAR2 (30)
BUDGET_AMOUNT NUMBER

CURRENCY_CODE VARCHAR2 (15)
DECISION_TIMEFRAME_CODE VARCHAR2 (30)
CLOSE_REASON VARCHAR2 (30)
LEAD_RANK_CODE VARCHAR2 (30)
PARENT_PROJECT VARCHAR2 (80)
DESCRIPTION VARCHAR2 (2000)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ASSIGN_TO_PERSON_ID NUMBER

ASSIGN_DATE DATE

BUDGET_STATUS_CODE VARCHAR2 (30)
ACCEPT_FLAG VARCHAR2 (1)
VEHICLE_RESPONSE_CODE VARCHAR2 (30)
TOTAL_SCORE NUMBER

SCORECARD_ID NUMBER

KEEP_FLAG VARCHAR2 (1)
URGENT_FLAG VARCHAR2 (1)
IMPORT_FLAG VARCHAR2 (1)
REJECT_REASON_CODE VARCHAR2 (30)
LEAD_RANK_ID NUMBER

ASSIGN_SALES_GROUP_ID NUMBER

DELETED_FLAG VARCHAR2 (1)
OFFER_ID NUMBER

SECURITY_GROUP_ID NUMBER

INCUMBENT_PARTNER_PARTY_ID NUMBER

INCUMBENT_PARTNER_RESOURCE_ID NUMBER

PRM_EXEC_SPONSOR_FLAG VARCHAR2 (1)
PRM_PRJ_LEAD_IN_PLACE_FLAG VARCHAR2 (1)
ASSIGN_TO_SALESFORCE_ID NUMBER

PRM_SALES_LEAD_TYPE VARCHAR2 (30)
PRM_IND_CLASSIFICATION_CODE VARCHAR2 (30)
AUTO_ASSIGNMENT_TYPE VARCHAR2 (30)
QUALIFIED_FLAG VARCHAR2 (1)
ORIG_SYSTEM_CODE VARCHAR2 (30)
PRM_ASSIGNMENT_TYPE VARCHAR2 (30)
PRIMARY_CONTACT_PARTY_ID NUMBER

PRIMARY_CNT_PERSON_PARTY_ID NUMBER

PRIMARY_CONTACT_PHONE_ID NUMBER

REFERRED_BY NUMBER

REFERRAL_STATUS VARCHAR2 (30)
REF_ORDER_NUMBER NUMBER

REF_ORDER_AMT NUMBER

REF_COMM_AMT NUMBER

REF_DECLINE_REASON VARCHAR2 (30)
REF_COMM_LTR_STATUS VARCHAR2 (30)
REFERRAL_TYPE VARCHAR2 (30)
TRUNC_CREATION_DATE DATE

LEAD_DATE DATE

COUNTRY VARCHAR2 (60)
SOURCE_SYSTEM VARCHAR2 (30)
TOTAL_AMOUNT NUMBER

EXPIRATION_DATE DATE

LEAD_RANK_IND VARCHAR2 (1)
LEAD_ENGINE_RUN_DATE DATE

CURRENT_REROUTES NUMBER

STATUS_OPEN_FLAG VARCHAR2 (1)
LEAD_RANK_SCORE NUMBER

MARKETING_SCORE NUMBER

INTERACTION_SCORE NUMBER

SOURCE_PRIMARY_REFERENCE VARCHAR2 (240)
SOURCE_SECONDARY_REFERENCE VARCHAR2 (240)
SALES_METHODOLOGY_ID NUMBER

SALES_STAGE_ID NUMBER

OBJECT_VERSION_NUMBER NUMBER

Query Text

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


SELECT SALES_LEAD_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LEAD_NUMBER
,      STATUS_CODE
,      CUSTOMER_ID
,      ADDRESS_ID
,      SOURCE_PROMOTION_ID
,      INITIATING_CONTACT_ID
,      ORIG_SYSTEM_REFERENCE
,      CONTACT_ROLE_CODE
,      CHANNEL_CODE
,      BUDGET_AMOUNT
,      CURRENCY_CODE
,      DECISION_TIMEFRAME_CODE
,      CLOSE_REASON
,      LEAD_RANK_CODE
,      PARENT_PROJECT
,      DESCRIPTION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ASSIGN_TO_PERSON_ID
,      ASSIGN_DATE
,      BUDGET_STATUS_CODE
,      ACCEPT_FLAG
,      VEHICLE_RESPONSE_CODE
,      TOTAL_SCORE
,      SCORECARD_ID
,      KEEP_FLAG
,      URGENT_FLAG
,      IMPORT_FLAG
,      REJECT_REASON_CODE
,      LEAD_RANK_ID
,      ASSIGN_SALES_GROUP_ID
,      DELETED_FLAG
,      OFFER_ID
,      SECURITY_GROUP_ID
,      INCUMBENT_PARTNER_PARTY_ID
,      INCUMBENT_PARTNER_RESOURCE_ID
,      PRM_EXEC_SPONSOR_FLAG
,      PRM_PRJ_LEAD_IN_PLACE_FLAG
,      ASSIGN_TO_SALESFORCE_ID
,      PRM_SALES_LEAD_TYPE
,      PRM_IND_CLASSIFICATION_CODE
,      AUTO_ASSIGNMENT_TYPE
,      QUALIFIED_FLAG
,      ORIG_SYSTEM_CODE
,      PRM_ASSIGNMENT_TYPE
,      PRIMARY_CONTACT_PARTY_ID
,      PRIMARY_CNT_PERSON_PARTY_ID
,      PRIMARY_CONTACT_PHONE_ID
,      REFERRED_BY
,      REFERRAL_STATUS
,      REF_ORDER_NUMBER
,      REF_ORDER_AMT
,      REF_COMM_AMT
,      REF_DECLINE_REASON
,      REF_COMM_LTR_STATUS
,      REFERRAL_TYPE
,      TRUNC_CREATION_DATE
,      LEAD_DATE
,      COUNTRY
,      SOURCE_SYSTEM
,      TOTAL_AMOUNT
,      EXPIRATION_DATE
,      LEAD_RANK_IND
,      LEAD_ENGINE_RUN_DATE
,      CURRENT_REROUTES
,      STATUS_OPEN_FLAG
,      LEAD_RANK_SCORE
,      MARKETING_SCORE
,      INTERACTION_SCORE
,      SOURCE_PRIMARY_REFERENCE
,      SOURCE_SECONDARY_REFERENCE
,      SALES_METHODOLOGY_ID
,      SALES_STAGE_ID
,      OBJECT_VERSION_NUMBER
FROM OSM.AS_SALES_LEADS#;

Dependencies

[top of page]

OSM.AS_SALES_LEADS# references the following:

SchemaOSM
TableAS_SALES_LEADS
OSM.AS_SALES_LEADS# is referenced by following:

SchemaAPPS
SynonymAS_SALES_LEADS
TriggerAS_SALES_LEADS_BIUD