VIEW: OSM.AS_SALES_LEADS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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