VIEW: OSM.AS_SALES_CREDITS_DENORM#

Source

View Text - Preformatted

select SALES_CREDIT_ID SALES_CREDIT_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, SALES_GROUP_ID SALES_GROUP_ID, SALES_GROUP_NAME SALES_GROUP_NAME, SALESFORCE_ID SALESFORCE_ID, EMPLOYEE_PERSON_ID EMPLOYEE_PERSON_ID, SALES_REP_NAME SALES_REP_NAME, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_CATEGORY CUSTOMER_CATEGORY, CUSTOMER_CATEGORY_CODE CUSTOMER_CATEGORY_CODE, ADDRESS_ID ADDRESS_ID, LEAD_ID LEAD_ID, LEAD_NUMBER LEAD_NUMBER, OPP_DESCRIPTION OPP_DESCRIPTION, DECISION_DATE DECISION_DATE, SALES_STAGE_ID SALES_STAGE_ID, SALES_STAGE SALES_STAGE, WIN_PROBABILITY WIN_PROBABILITY, STATUS_CODE STATUS_CODE, STATUS STATUS, SECURITY_GROUP_ID SECURITY_GROUP_ID, CHANNEL_CODE CHANNEL_CODE, LEAD_SOURCE_CODE LEAD_SOURCE_CODE, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE, LEAD_LINE_ID LEAD_LINE_ID, INTEREST_TYPE_ID INTEREST_TYPE_ID, PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID, SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID, CURRENCY_CODE CURRENCY_CODE, TOTAL_AMOUNT TOTAL_AMOUNT, SALES_CREDIT_AMOUNT SALES_CREDIT_AMOUNT, WON_AMOUNT WON_AMOUNT, WEIGHTED_AMOUNT WEIGHTED_AMOUNT, C1_CURRENCY_CODE C1_CURRENCY_CODE, C1_TOTAL_AMOUNT C1_TOTAL_AMOUNT, C1_SALES_CREDIT_AMOUNT C1_SALES_CREDIT_AMOUNT, C1_WON_AMOUNT C1_WON_AMOUNT, C1_WEIGHTED_AMOUNT C1_WEIGHTED_AMOUNT, LAST_NAME LAST_NAME, FIRST_NAME FIRST_NAME, ORG_ID ORG_ID, INTEREST_TYPE INTEREST_TYPE, PRIMARY_INTEREST_CODE PRIMARY_INTEREST_CODE, SECONDARY_INTEREST_CODE SECONDARY_INTEREST_CODE, OPPORTUNITY_LAST_UPDATE_DATE OPPORTUNITY_LAST_UPDATE_DATE, OPPORTUNITY_LAST_UPDATED_BY OPPORTUNITY_LAST_UPDATED_BY, REQUEST_ID REQUEST_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CONVERSION_STATUS_FLAG CONVERSION_STATUS_FLAG, CREDIT_TYPE_ID CREDIT_TYPE_ID, QUANTITY QUANTITY, UOM_CODE UOM_CODE, UOM_DESCRIPTION UOM_DESCRIPTION, FORECAST_ROLLUP_FLAG FORECAST_ROLLUP_FLAG, WIN_LOSS_INDICATOR WIN_LOSS_INDICATOR, ITEM_ID ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, ITEM_DESCRIPTION ITEM_DESCRIPTION, PARTNER_CUSTOMER_ID PARTNER_CUSTOMER_ID, PARTNER_ADDRESS_ID PARTNER_ADDRESS_ID, PARTNER_CUSTOMER_NAME PARTNER_CUSTOMER_NAME, PARENT_PROJECT PARENT_PROJECT, SEQUENCE SEQUENCE, EMPLOYEE_NUMBER EMPLOYEE_NUMBER, OPP_OPEN_STATUS_FLAG OPP_OPEN_STATUS_FLAG, OPP_DELETED_FLAG OPP_DELETED_FLAG, PARTY_TYPE PARTY_TYPE, REVENUE_FLAG REVENUE_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, OPPORTUNITY_LAST_UPDATED_NAME OPPORTUNITY_LAST_UPDATED_NAME, OPPORTUNITY_CREATED_BY OPPORTUNITY_CREATED_BY, OPPORTUNITY_CREATION_DATE OPPORTUNITY_CREATION_DATE, OPPORTUNITY_CREATED_NAME OPPORTUNITY_CREATED_NAME, CLOSE_REASON CLOSE_REASON, CLOSE_REASON_MEANING CLOSE_REASON_MEANING, BUSINESS_GROUP_NAME BUSINESS_GROUP_NAME, SOURCE_PROMOTION_ID SOURCE_PROMOTION_ID, SALES_METHODOLOGY_ID SALES_METHODOLOGY_ID, FORECAST_DATE FORECAST_DATE, ROLLING_FORECAST_FLAG ROLLING_FORECAST_FLAG, CLOSE_COMPETITOR_ID CLOSE_COMPETITOR_ID, COMPETITOR_NAME COMPETITOR_NAME, OWNER_SALESFORCE_ID OWNER_SALESFORCE_ID, OWNER_SALES_GROUP_ID OWNER_SALES_GROUP_ID, OWNER_PERSON_NAME OWNER_PERSON_NAME, OWNER_LAST_NAME OWNER_LAST_NAME, OWNER_FIRST_NAME OWNER_FIRST_NAME, OWNER_GROUP_NAME OWNER_GROUP_NAME, PRODUCT_CATEGORY_ID PRODUCT_CATEGORY_ID, PRODUCT_CAT_SET_ID PRODUCT_CAT_SET_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, OPP_WORST_FORECAST_AMOUNT OPP_WORST_FORECAST_AMOUNT, OPP_FORECAST_AMOUNT OPP_FORECAST_AMOUNT, OPP_BEST_FORECAST_AMOUNT OPP_BEST_FORECAST_AMOUNT from "OSM"."AS_SALES_CREDITS_DENORM"

View Text - HTML Formatted

SELECT SALES_CREDIT_ID SALES_CREDIT_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
, SALES_GROUP_ID SALES_GROUP_ID
, SALES_GROUP_NAME SALES_GROUP_NAME
, SALESFORCE_ID SALESFORCE_ID
, EMPLOYEE_PERSON_ID EMPLOYEE_PERSON_ID
, SALES_REP_NAME SALES_REP_NAME
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_CATEGORY CUSTOMER_CATEGORY
, CUSTOMER_CATEGORY_CODE CUSTOMER_CATEGORY_CODE
, ADDRESS_ID ADDRESS_ID
, LEAD_ID LEAD_ID
, LEAD_NUMBER LEAD_NUMBER
, OPP_DESCRIPTION OPP_DESCRIPTION
, DECISION_DATE DECISION_DATE
, SALES_STAGE_ID SALES_STAGE_ID
, SALES_STAGE SALES_STAGE
, WIN_PROBABILITY WIN_PROBABILITY
, STATUS_CODE STATUS_CODE
, STATUS STATUS
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, CHANNEL_CODE CHANNEL_CODE
, LEAD_SOURCE_CODE LEAD_SOURCE_CODE
, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, LEAD_LINE_ID LEAD_LINE_ID
, INTEREST_TYPE_ID INTEREST_TYPE_ID
, PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID
, SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID
, CURRENCY_CODE CURRENCY_CODE
, TOTAL_AMOUNT TOTAL_AMOUNT
, SALES_CREDIT_AMOUNT SALES_CREDIT_AMOUNT
, WON_AMOUNT WON_AMOUNT
, WEIGHTED_AMOUNT WEIGHTED_AMOUNT
, C1_CURRENCY_CODE C1_CURRENCY_CODE
, C1_TOTAL_AMOUNT C1_TOTAL_AMOUNT
, C1_SALES_CREDIT_AMOUNT C1_SALES_CREDIT_AMOUNT
, C1_WON_AMOUNT C1_WON_AMOUNT
, C1_WEIGHTED_AMOUNT C1_WEIGHTED_AMOUNT
, LAST_NAME LAST_NAME
, FIRST_NAME FIRST_NAME
, ORG_ID ORG_ID
, INTEREST_TYPE INTEREST_TYPE
, PRIMARY_INTEREST_CODE PRIMARY_INTEREST_CODE
, SECONDARY_INTEREST_CODE SECONDARY_INTEREST_CODE
, OPPORTUNITY_LAST_UPDATE_DATE OPPORTUNITY_LAST_UPDATE_DATE
, OPPORTUNITY_LAST_UPDATED_BY OPPORTUNITY_LAST_UPDATED_BY
, REQUEST_ID REQUEST_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CONVERSION_STATUS_FLAG CONVERSION_STATUS_FLAG
, CREDIT_TYPE_ID CREDIT_TYPE_ID
, QUANTITY QUANTITY
, UOM_CODE UOM_CODE
, UOM_DESCRIPTION UOM_DESCRIPTION
, FORECAST_ROLLUP_FLAG FORECAST_ROLLUP_FLAG
, WIN_LOSS_INDICATOR WIN_LOSS_INDICATOR
, ITEM_ID ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, PARTNER_CUSTOMER_ID PARTNER_CUSTOMER_ID
, PARTNER_ADDRESS_ID PARTNER_ADDRESS_ID
, PARTNER_CUSTOMER_NAME PARTNER_CUSTOMER_NAME
, PARENT_PROJECT PARENT_PROJECT
, SEQUENCE SEQUENCE
, EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, OPP_OPEN_STATUS_FLAG OPP_OPEN_STATUS_FLAG
, OPP_DELETED_FLAG OPP_DELETED_FLAG
, PARTY_TYPE PARTY_TYPE
, REVENUE_FLAG REVENUE_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
, OPPORTUNITY_LAST_UPDATED_NAME OPPORTUNITY_LAST_UPDATED_NAME
, OPPORTUNITY_CREATED_BY OPPORTUNITY_CREATED_BY
, OPPORTUNITY_CREATION_DATE OPPORTUNITY_CREATION_DATE
, OPPORTUNITY_CREATED_NAME OPPORTUNITY_CREATED_NAME
, CLOSE_REASON CLOSE_REASON
, CLOSE_REASON_MEANING CLOSE_REASON_MEANING
, BUSINESS_GROUP_NAME BUSINESS_GROUP_NAME
, SOURCE_PROMOTION_ID SOURCE_PROMOTION_ID
, SALES_METHODOLOGY_ID SALES_METHODOLOGY_ID
, FORECAST_DATE FORECAST_DATE
, ROLLING_FORECAST_FLAG ROLLING_FORECAST_FLAG
, CLOSE_COMPETITOR_ID CLOSE_COMPETITOR_ID
, COMPETITOR_NAME COMPETITOR_NAME
, OWNER_SALESFORCE_ID OWNER_SALESFORCE_ID
, OWNER_SALES_GROUP_ID OWNER_SALES_GROUP_ID
, OWNER_PERSON_NAME OWNER_PERSON_NAME
, OWNER_LAST_NAME OWNER_LAST_NAME
, OWNER_FIRST_NAME OWNER_FIRST_NAME
, OWNER_GROUP_NAME OWNER_GROUP_NAME
, PRODUCT_CATEGORY_ID PRODUCT_CATEGORY_ID
, PRODUCT_CAT_SET_ID PRODUCT_CAT_SET_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, OPP_WORST_FORECAST_AMOUNT OPP_WORST_FORECAST_AMOUNT
, OPP_FORECAST_AMOUNT OPP_FORECAST_AMOUNT
, OPP_BEST_FORECAST_AMOUNT OPP_BEST_FORECAST_AMOUNT
FROM "OSM"."AS_SALES_CREDITS_DENORM"