eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: OSM.AS_LEADS_LOG#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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