VIEW: OSM.AS_LEADS_ALL#

Source

View Text - Preformatted

select LEAD_ID 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 STATUS, CUSTOMER_ID CUSTOMER_ID, ADDRESS_ID ADDRESS_ID, LEAD_SOURCE_CODE LEAD_SOURCE_CODE, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE, SALES_STAGE_ID SALES_STAGE_ID, INITIATING_CONTACT_ID INITIATING_CONTACT_ID, CHANNEL_CODE CHANNEL_CODE, TOTAL_AMOUNT TOTAL_AMOUNT, CURRENCY_CODE CURRENCY_CODE, DECISION_DATE DECISION_DATE, WIN_PROBABILITY WIN_PROBABILITY, CLOSE_REASON CLOSE_REASON, CLOSE_COMPETITOR_CODE CLOSE_COMPETITOR_CODE, CLOSE_COMPETITOR_ID CLOSE_COMPETITOR_ID, CLOSE_COMPETITOR CLOSE_COMPETITOR, CLOSE_COMMENT CLOSE_COMMENT, DESCRIPTION DESCRIPTION, RANK RANK, END_USER_CUSTOMER_NAME END_USER_CUSTOMER_NAME, SOURCE_PROMOTION_ID SOURCE_PROMOTION_ID, END_USER_CUSTOMER_ID END_USER_CUSTOMER_ID, END_USER_ADDRESS_ID END_USER_ADDRESS_ID, ORG_ID ORG_ID, NO_OPP_ALLOWED_FLAG NO_OPP_ALLOWED_FLAG, DELETE_ALLOWED_FLAG DELETE_ALLOWED_FLAG, PARENT_PROJECT PARENT_PROJECT, PRICE_LIST_ID PRICE_LIST_ID, 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, DELETED_FLAG DELETED_FLAG, AUTO_ASSIGNMENT_TYPE AUTO_ASSIGNMENT_TYPE, PRM_ASSIGNMENT_TYPE PRM_ASSIGNMENT_TYPE, CUSTOMER_BUDGET CUSTOMER_BUDGET, METHODOLOGY_CODE METHODOLOGY_CODE, ORIGINAL_LEAD_ID ORIGINAL_LEAD_ID, DECISION_TIMEFRAME_CODE DECISION_TIMEFRAME_CODE, SECURITY_GROUP_ID SECURITY_GROUP_ID, INCUMBENT_PARTNER_RESOURCE_ID INCUMBENT_PARTNER_RESOURCE_ID, INCUMBENT_PARTNER_PARTY_ID INCUMBENT_PARTNER_PARTY_ID, OFFER_ID OFFER_ID, VEHICLE_RESPONSE_CODE VEHICLE_RESPONSE_CODE, BUDGET_STATUS_CODE BUDGET_STATUS_CODE, FOLLOWUP_DATE FOLLOWUP_DATE, PRM_EXEC_SPONSOR_FLAG PRM_EXEC_SPONSOR_FLAG, PRM_PRJ_LEAD_IN_PLACE_FLAG PRM_PRJ_LEAD_IN_PLACE_FLAG, PRM_IND_CLASSIFICATION_CODE PRM_IND_CLASSIFICATION_CODE, PRM_LEAD_TYPE PRM_LEAD_TYPE, FREEZE_FLAG FREEZE_FLAG, SALES_METHODOLOGY_ID SALES_METHODOLOGY_ID, OWNER_SALESFORCE_ID OWNER_SALESFORCE_ID, OWNER_SALES_GROUP_ID OWNER_SALES_GROUP_ID, PRM_REFERRAL_CODE PRM_REFERRAL_CODE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, TOTAL_REVENUE_OPP_FORECAST_AMT TOTAL_REVENUE_OPP_FORECAST_AMT from "OSM"."AS_LEADS_ALL"

View Text - HTML Formatted

SELECT LEAD_ID 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 STATUS
, CUSTOMER_ID CUSTOMER_ID
, ADDRESS_ID ADDRESS_ID
, LEAD_SOURCE_CODE LEAD_SOURCE_CODE
, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, SALES_STAGE_ID SALES_STAGE_ID
, INITIATING_CONTACT_ID INITIATING_CONTACT_ID
, CHANNEL_CODE CHANNEL_CODE
, TOTAL_AMOUNT TOTAL_AMOUNT
, CURRENCY_CODE CURRENCY_CODE
, DECISION_DATE DECISION_DATE
, WIN_PROBABILITY WIN_PROBABILITY
, CLOSE_REASON CLOSE_REASON
, CLOSE_COMPETITOR_CODE CLOSE_COMPETITOR_CODE
, CLOSE_COMPETITOR_ID CLOSE_COMPETITOR_ID
, CLOSE_COMPETITOR CLOSE_COMPETITOR
, CLOSE_COMMENT CLOSE_COMMENT
, DESCRIPTION DESCRIPTION
, RANK RANK
, END_USER_CUSTOMER_NAME END_USER_CUSTOMER_NAME
, SOURCE_PROMOTION_ID SOURCE_PROMOTION_ID
, END_USER_CUSTOMER_ID END_USER_CUSTOMER_ID
, END_USER_ADDRESS_ID END_USER_ADDRESS_ID
, ORG_ID ORG_ID
, NO_OPP_ALLOWED_FLAG NO_OPP_ALLOWED_FLAG
, DELETE_ALLOWED_FLAG DELETE_ALLOWED_FLAG
, PARENT_PROJECT PARENT_PROJECT
, PRICE_LIST_ID PRICE_LIST_ID
, 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
, DELETED_FLAG DELETED_FLAG
, AUTO_ASSIGNMENT_TYPE AUTO_ASSIGNMENT_TYPE
, PRM_ASSIGNMENT_TYPE PRM_ASSIGNMENT_TYPE
, CUSTOMER_BUDGET CUSTOMER_BUDGET
, METHODOLOGY_CODE METHODOLOGY_CODE
, ORIGINAL_LEAD_ID ORIGINAL_LEAD_ID
, DECISION_TIMEFRAME_CODE DECISION_TIMEFRAME_CODE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, INCUMBENT_PARTNER_RESOURCE_ID INCUMBENT_PARTNER_RESOURCE_ID
, INCUMBENT_PARTNER_PARTY_ID INCUMBENT_PARTNER_PARTY_ID
, OFFER_ID OFFER_ID
, VEHICLE_RESPONSE_CODE VEHICLE_RESPONSE_CODE
, BUDGET_STATUS_CODE BUDGET_STATUS_CODE
, FOLLOWUP_DATE FOLLOWUP_DATE
, PRM_EXEC_SPONSOR_FLAG PRM_EXEC_SPONSOR_FLAG
, PRM_PRJ_LEAD_IN_PLACE_FLAG PRM_PRJ_LEAD_IN_PLACE_FLAG
, PRM_IND_CLASSIFICATION_CODE PRM_IND_CLASSIFICATION_CODE
, PRM_LEAD_TYPE PRM_LEAD_TYPE
, FREEZE_FLAG FREEZE_FLAG
, SALES_METHODOLOGY_ID SALES_METHODOLOGY_ID
, OWNER_SALESFORCE_ID OWNER_SALESFORCE_ID
, OWNER_SALES_GROUP_ID OWNER_SALES_GROUP_ID
, PRM_REFERRAL_CODE PRM_REFERRAL_CODE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TOTAL_REVENUE_OPP_FORECAST_AMT TOTAL_REVENUE_OPP_FORECAST_AMT
FROM "OSM"."AS_LEADS_ALL"