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_LEAD_LINE_ADJS#

Source

View Text - Preformatted


select LEAD_LINE_ADJUSTMENT_ID LEAD_LINE_ADJUSTMENT_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, LEAD_ADJUSTMENT_ID LEAD_ADJUSTMENT_ID, ORIGINAL_LEAD_ID ORIGINAL_LEAD_ID, ORIGINAL_LEAD_LINE_ID ORIGINAL_LEAD_LINE_ID, ORIGINAL_LEAD_LINE_FLAG ORIGINAL_LEAD_LINE_FLAG, WIN_PROBABILITY WIN_PROBABILITY, STATUS_CODE STATUS_CODE, DECISION_DATE DECISION_DATE, TOTAL_AMOUNT TOTAL_AMOUNT, ADJUSTED_BY_PERSON_ID ADJUSTED_BY_PERSON_ID, SALES_STAGE_ID SALES_STAGE_ID, SHIP_DATE SHIP_DATE, QUANTITY QUANTITY, HISTORIC_WIN_PROBABILITY HISTORIC_WIN_PROBABILITY, HISTORIC_SALES_STAGE_ID HISTORIC_SALES_STAGE_ID, HISTORIC_STATUS_CODE HISTORIC_STATUS_CODE, HISTORIC_DECISION_DATE HISTORIC_DECISION_DATE, HISTORIC_SHIP_DATE HISTORIC_SHIP_DATE, HISTORIC_TOTAL_AMOUNT HISTORIC_TOTAL_AMOUNT, HISTORIC_QUANTITY HISTORIC_QUANTITY, UOM_CODE UOM_CODE, PRICE_LIST_ID PRICE_LIST_ID, PRICE PRICE, PRICE_VOLUME_MARGIN PRICE_VOLUME_MARGIN, ADJUSTED_BY_SALESFORCE_ID ADJUSTED_BY_SALESFORCE_ID, COMMIT_FLAG COMMIT_FLAG, HISTORIC_CREDIT_AMOUNT HISTORIC_CREDIT_AMOUNT from "OSM"."AS_LEAD_LINE_ADJS"

View Text - HTML Formatted

SELECT LEAD_LINE_ADJUSTMENT_ID LEAD_LINE_ADJUSTMENT_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
, LEAD_ADJUSTMENT_ID LEAD_ADJUSTMENT_ID
, ORIGINAL_LEAD_ID ORIGINAL_LEAD_ID
, ORIGINAL_LEAD_LINE_ID ORIGINAL_LEAD_LINE_ID
, ORIGINAL_LEAD_LINE_FLAG ORIGINAL_LEAD_LINE_FLAG
, WIN_PROBABILITY WIN_PROBABILITY
, STATUS_CODE STATUS_CODE
, DECISION_DATE DECISION_DATE
, TOTAL_AMOUNT TOTAL_AMOUNT
, ADJUSTED_BY_PERSON_ID ADJUSTED_BY_PERSON_ID
, SALES_STAGE_ID SALES_STAGE_ID
, SHIP_DATE SHIP_DATE
, QUANTITY QUANTITY
, HISTORIC_WIN_PROBABILITY HISTORIC_WIN_PROBABILITY
, HISTORIC_SALES_STAGE_ID HISTORIC_SALES_STAGE_ID
, HISTORIC_STATUS_CODE HISTORIC_STATUS_CODE
, HISTORIC_DECISION_DATE HISTORIC_DECISION_DATE
, HISTORIC_SHIP_DATE HISTORIC_SHIP_DATE
, HISTORIC_TOTAL_AMOUNT HISTORIC_TOTAL_AMOUNT
, HISTORIC_QUANTITY HISTORIC_QUANTITY
, UOM_CODE UOM_CODE
, PRICE_LIST_ID PRICE_LIST_ID
, PRICE PRICE
, PRICE_VOLUME_MARGIN PRICE_VOLUME_MARGIN
, ADJUSTED_BY_SALESFORCE_ID ADJUSTED_BY_SALESFORCE_ID
, COMMIT_FLAG COMMIT_FLAG
, HISTORIC_CREDIT_AMOUNT HISTORIC_CREDIT_AMOUNT
FROM "OSM"."AS_LEAD_LINE_ADJS"