VIEW: OSM.AS_OPP_WORKSHEET_LINES_BACKUP#

Source

View Text - Preformatted

select OPP_WORKSHEET_LINE_ID OPP_WORKSHEET_LINE_ID, FORECAST_WORKSHEET_ID FORECAST_WORKSHEET_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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, FORECAST_ID FORECAST_ID, SALESFORCE_ID SALESFORCE_ID, SALES_GROUP_ID SALES_GROUP_ID, EMPLOYEE_PERSON_ID EMPLOYEE_PERSON_ID, LEAD_ID LEAD_ID, SALESREP_FIRST_NAME SALESREP_FIRST_NAME, SALESREP_LAST_NAME SALESREP_LAST_NAME, CUSTOMER_ID CUSTOMER_ID, CURRENCY_CODE CURRENCY_CODE, STATUS_CODE STATUS_CODE, DECISION_DATE DECISION_DATE, SALES_STAGE_ID SALES_STAGE_ID, WIN_PROBABILITY WIN_PROBABILITY, STATUS STATUS, CREDIT_TYPE_ID CREDIT_TYPE_ID, WEIGHTED_AMOUNT_FLAG WEIGHTED_AMOUNT_FLAG, WEIGHTED_AMOUNT WEIGHTED_AMOUNT, AMOUNT_FLAG AMOUNT_FLAG, AMOUNT AMOUNT, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, GROUP_FORECAST_AMOUNT_FLAG GROUP_FORECAST_AMOUNT_FLAG, GROUP_FORECAST_AMOUNT GROUP_FORECAST_AMOUNT, WORST_FORECAST_AMOUNT_FLAG WORST_FORECAST_AMOUNT_FLAG, WORST_FORECAST_AMOUNT WORST_FORECAST_AMOUNT, FORECAST_AMOUNT_FLAG FORECAST_AMOUNT_FLAG, FORECAST_AMOUNT FORECAST_AMOUNT, BEST_FORECAST_AMOUNT_FLAG BEST_FORECAST_AMOUNT_FLAG, BEST_FORECAST_AMOUNT BEST_FORECAST_AMOUNT, 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, SECURITY_GROUP_ID SECURITY_GROUP_ID, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, FORECAST_CATEGORY_ID FORECAST_CATEGORY_ID, PERIOD_NAME PERIOD_NAME, FORECAST_DATE FORECAST_DATE, RESOURCE_ID RESOURCE_ID, THRESHOLD_OPP_FLAG THRESHOLD_OPP_FLAG, THRESHOLD_OPP_COUNT THRESHOLD_OPP_COUNT, THRESHOLD_AMOUNT THRESHOLD_AMOUNT, THRESHOLD_STORE_OPP THRESHOLD_STORE_OPP, THRESHOLD_CHANNEL THRESHOLD_CHANNEL, INTEREST_TYPE INTEREST_TYPE, INTEREST_TYPE_ID INTEREST_TYPE_ID, PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID, SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID, EXPAND_FLAG EXPAND_FLAG from "OSM"."AS_OPP_WORKSHEET_LINES_BACKUP"

View Text - HTML Formatted

SELECT OPP_WORKSHEET_LINE_ID OPP_WORKSHEET_LINE_ID
, FORECAST_WORKSHEET_ID FORECAST_WORKSHEET_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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, FORECAST_ID FORECAST_ID
, SALESFORCE_ID SALESFORCE_ID
, SALES_GROUP_ID SALES_GROUP_ID
, EMPLOYEE_PERSON_ID EMPLOYEE_PERSON_ID
, LEAD_ID LEAD_ID
, SALESREP_FIRST_NAME SALESREP_FIRST_NAME
, SALESREP_LAST_NAME SALESREP_LAST_NAME
, CUSTOMER_ID CUSTOMER_ID
, CURRENCY_CODE CURRENCY_CODE
, STATUS_CODE STATUS_CODE
, DECISION_DATE DECISION_DATE
, SALES_STAGE_ID SALES_STAGE_ID
, WIN_PROBABILITY WIN_PROBABILITY
, STATUS STATUS
, CREDIT_TYPE_ID CREDIT_TYPE_ID
, WEIGHTED_AMOUNT_FLAG WEIGHTED_AMOUNT_FLAG
, WEIGHTED_AMOUNT WEIGHTED_AMOUNT
, AMOUNT_FLAG AMOUNT_FLAG
, AMOUNT AMOUNT
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, GROUP_FORECAST_AMOUNT_FLAG GROUP_FORECAST_AMOUNT_FLAG
, GROUP_FORECAST_AMOUNT GROUP_FORECAST_AMOUNT
, WORST_FORECAST_AMOUNT_FLAG WORST_FORECAST_AMOUNT_FLAG
, WORST_FORECAST_AMOUNT WORST_FORECAST_AMOUNT
, FORECAST_AMOUNT_FLAG FORECAST_AMOUNT_FLAG
, FORECAST_AMOUNT FORECAST_AMOUNT
, BEST_FORECAST_AMOUNT_FLAG BEST_FORECAST_AMOUNT_FLAG
, BEST_FORECAST_AMOUNT BEST_FORECAST_AMOUNT
, 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
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, FORECAST_CATEGORY_ID FORECAST_CATEGORY_ID
, PERIOD_NAME PERIOD_NAME
, FORECAST_DATE FORECAST_DATE
, RESOURCE_ID RESOURCE_ID
, THRESHOLD_OPP_FLAG THRESHOLD_OPP_FLAG
, THRESHOLD_OPP_COUNT THRESHOLD_OPP_COUNT
, THRESHOLD_AMOUNT THRESHOLD_AMOUNT
, THRESHOLD_STORE_OPP THRESHOLD_STORE_OPP
, THRESHOLD_CHANNEL THRESHOLD_CHANNEL
, INTEREST_TYPE INTEREST_TYPE
, INTEREST_TYPE_ID INTEREST_TYPE_ID
, PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID
, SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID
, EXPAND_FLAG EXPAND_FLAG
FROM "OSM"."AS_OPP_WORKSHEET_LINES_BACKUP"