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.

VIEW: PV.PV_PARTNER_PROFILES#

Source

View Text - Preformatted


select PARTNER_PROFILE_ID PARTNER_PROFILE_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, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PARTNER_ID PARTNER_ID, CM_ID CM_ID, TARGET_REVENUE_AMT TARGET_REVENUE_AMT, ACTUAL_REVENUE_AMT ACTUAL_REVENUE_AMT, TARGET_REVENUE_PCT TARGET_REVENUE_PCT, ACTUAL_REVENUE_PCT ACTUAL_REVENUE_PCT, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE, ORIG_SYSTEM_TYPE ORIG_SYSTEM_TYPE, CAPACITY_SIZE CAPACITY_SIZE, CAPACITY_AMOUNT CAPACITY_AMOUNT, AUTO_MATCH_ALLOWED_FLAG AUTO_MATCH_ALLOWED_FLAG, PURCHASE_METHOD PURCHASE_METHOD, SECURITY_GROUP_ID SECURITY_GROUP_ID, PH_SUPPORT_REP PH_SUPPORT_REP, LEAD_SHARING_STATUS LEAD_SHARING_STATUS, LEAD_SHARE_APPR_FLAG LEAD_SHARE_APPR_FLAG, PARTNER_RELATIONSHIP_ID PARTNER_RELATIONSHIP_ID, PARTNER_LEVEL PARTNER_LEVEL, PREFERRED_VAD_ID PREFERRED_VAD_ID, PARTNER_GROUP_ID PARTNER_GROUP_ID, PARTNER_RESOURCE_ID PARTNER_RESOURCE_ID, PARTNER_GROUP_NUMBER PARTNER_GROUP_NUMBER, PARTNER_RESOURCE_NUMBER PARTNER_RESOURCE_NUMBER, SALES_PARTNER_FLAG SALES_PARTNER_FLAG, INDIRECTLY_MANAGED_FLAG INDIRECTLY_MANAGED_FLAG, CHANNEL_MARKETING_MANAGER CHANNEL_MARKETING_MANAGER, OPPTY_LAST_OFFERED_DATE OPPTY_LAST_OFFERED_DATE, RELATED_PARTNER_ID RELATED_PARTNER_ID, MAX_USERS MAX_USERS, PARTNER_PARTY_ID PARTNER_PARTY_ID, STATUS STATUS from "PV"."PV_PARTNER_PROFILES"

View Text - HTML Formatted

SELECT PARTNER_PROFILE_ID PARTNER_PROFILE_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
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PARTNER_ID PARTNER_ID
, CM_ID CM_ID
, TARGET_REVENUE_AMT TARGET_REVENUE_AMT
, ACTUAL_REVENUE_AMT ACTUAL_REVENUE_AMT
, TARGET_REVENUE_PCT TARGET_REVENUE_PCT
, ACTUAL_REVENUE_PCT ACTUAL_REVENUE_PCT
, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, ORIG_SYSTEM_TYPE ORIG_SYSTEM_TYPE
, CAPACITY_SIZE CAPACITY_SIZE
, CAPACITY_AMOUNT CAPACITY_AMOUNT
, AUTO_MATCH_ALLOWED_FLAG AUTO_MATCH_ALLOWED_FLAG
, PURCHASE_METHOD PURCHASE_METHOD
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, PH_SUPPORT_REP PH_SUPPORT_REP
, LEAD_SHARING_STATUS LEAD_SHARING_STATUS
, LEAD_SHARE_APPR_FLAG LEAD_SHARE_APPR_FLAG
, PARTNER_RELATIONSHIP_ID PARTNER_RELATIONSHIP_ID
, PARTNER_LEVEL PARTNER_LEVEL
, PREFERRED_VAD_ID PREFERRED_VAD_ID
, PARTNER_GROUP_ID PARTNER_GROUP_ID
, PARTNER_RESOURCE_ID PARTNER_RESOURCE_ID
, PARTNER_GROUP_NUMBER PARTNER_GROUP_NUMBER
, PARTNER_RESOURCE_NUMBER PARTNER_RESOURCE_NUMBER
, SALES_PARTNER_FLAG SALES_PARTNER_FLAG
, INDIRECTLY_MANAGED_FLAG INDIRECTLY_MANAGED_FLAG
, CHANNEL_MARKETING_MANAGER CHANNEL_MARKETING_MANAGER
, OPPTY_LAST_OFFERED_DATE OPPTY_LAST_OFFERED_DATE
, RELATED_PARTNER_ID RELATED_PARTNER_ID
, MAX_USERS MAX_USERS
, PARTNER_PARTY_ID PARTNER_PARTY_ID
, STATUS STATUS
FROM "PV"."PV_PARTNER_PROFILES"