VIEW: OSM.AS_FORECASTS#

Source

View Text - Preformatted

select FORECAST_ID FORECAST_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, COLLECTED_BY_OSC COLLECTED_BY_OSC, CURRENCY_CODE CURRENCY_CODE, PERIOD_NAME PERIOD_NAME, FORECAST_AMOUNT FORECAST_AMOUNT, UPSIDE_AMOUNT UPSIDE_AMOUNT, SALES_QUOTA_ID SALES_QUOTA_ID, REVENUE_FLAG REVENUE_FLAG, MANAGER_REVIEW_FLAG MANAGER_REVIEW_FLAG, MANAGER_REVIEW_DATE MANAGER_REVIEW_DATE, SALESFORCE_ID SALESFORCE_ID, EMPLOYEE_PERSON_ID EMPLOYEE_PERSON_ID, SALES_GROUP_ID SALES_GROUP_ID, PARTNER_ADDRESS_ID PARTNER_ADDRESS_ID, PARTNER_CUSTOMER_ID PARTNER_CUSTOMER_ID, ORIGINAL_FORECAST_ID ORIGINAL_FORECAST_ID, FREEZE_PERIOD FREEZE_PERIOD, UOM_CODE UOM_CODE, FORECAST_QUANTITY FORECAST_QUANTITY, UPSIDE_QUANTITY UPSIDE_QUANTITY, LEAD_WON_AMOUNT LEAD_WON_AMOUNT, LEAD_WON_QUANTITY LEAD_WON_QUANTITY, LEAD_FORECAST_AMOUNT LEAD_FORECAST_AMOUNT, LEAD_FORECAST_QUANTITY LEAD_FORECAST_QUANTITY, LEAD_UPSIDE_AMOUNT LEAD_UPSIDE_AMOUNT, LEAD_UPSIDE_QUANTITY LEAD_UPSIDE_QUANTITY, SALES_QUOTA_AMOUNT SALES_QUOTA_AMOUNT, PRICE_LIST_ID PRICE_LIST_ID, PRICE PRICE, PRICE_VOLUME_MARGIN PRICE_VOLUME_MARGIN, COMMIT_FLAG COMMIT_FLAG, 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, SHIP_DATE SHIP_DATE, END_SHIP_DATE END_SHIP_DATE from "OSM"."AS_FORECASTS"

View Text - HTML Formatted

SELECT FORECAST_ID FORECAST_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
, COLLECTED_BY_OSC COLLECTED_BY_OSC
, CURRENCY_CODE CURRENCY_CODE
, PERIOD_NAME PERIOD_NAME
, FORECAST_AMOUNT FORECAST_AMOUNT
, UPSIDE_AMOUNT UPSIDE_AMOUNT
, SALES_QUOTA_ID SALES_QUOTA_ID
, REVENUE_FLAG REVENUE_FLAG
, MANAGER_REVIEW_FLAG MANAGER_REVIEW_FLAG
, MANAGER_REVIEW_DATE MANAGER_REVIEW_DATE
, SALESFORCE_ID SALESFORCE_ID
, EMPLOYEE_PERSON_ID EMPLOYEE_PERSON_ID
, SALES_GROUP_ID SALES_GROUP_ID
, PARTNER_ADDRESS_ID PARTNER_ADDRESS_ID
, PARTNER_CUSTOMER_ID PARTNER_CUSTOMER_ID
, ORIGINAL_FORECAST_ID ORIGINAL_FORECAST_ID
, FREEZE_PERIOD FREEZE_PERIOD
, UOM_CODE UOM_CODE
, FORECAST_QUANTITY FORECAST_QUANTITY
, UPSIDE_QUANTITY UPSIDE_QUANTITY
, LEAD_WON_AMOUNT LEAD_WON_AMOUNT
, LEAD_WON_QUANTITY LEAD_WON_QUANTITY
, LEAD_FORECAST_AMOUNT LEAD_FORECAST_AMOUNT
, LEAD_FORECAST_QUANTITY LEAD_FORECAST_QUANTITY
, LEAD_UPSIDE_AMOUNT LEAD_UPSIDE_AMOUNT
, LEAD_UPSIDE_QUANTITY LEAD_UPSIDE_QUANTITY
, SALES_QUOTA_AMOUNT SALES_QUOTA_AMOUNT
, PRICE_LIST_ID PRICE_LIST_ID
, PRICE PRICE
, PRICE_VOLUME_MARGIN PRICE_VOLUME_MARGIN
, COMMIT_FLAG COMMIT_FLAG
, 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
, SHIP_DATE SHIP_DATE
, END_SHIP_DATE END_SHIP_DATE
FROM "OSM"."AS_FORECASTS"