Search Partner Directory

[Record_Nav]

Y 20 #FFFFFF #EEEEEE Name All All All All All All DECODE( ':SortBy', 'Level', DECODE( ':String'||REPLACE(':Products','All',Null), Null, '[Row]', '[Row]' ), '[Row]' )p.Doc_Id1p.Partner_IdDECODE( U.Get_Group_Id, 0, '' || CHR(10), Null )p.Company_NameDECODE( p.Partner_Type, Null, Null, ' (' || REPLACE( REPLACE( REPLACE( p.Partner_Type, '', ', ' ), '', Null ), '', Null ) || ')' )DECODE( ':SortBy', 'Name', Null, ' - ' || DECODE( p.Partner_Level, Null, Null, p.Partner_Level ) )DECODE( p.Profile_URL, Null, p.Website_URL, REPLACE( '/pages' || p.Profile_URL, U.Get_URL( 'WWW' ), Null ) || '?String=[String]&Region=[Region]&State=[State]&Partner_Type=[Partner_Type]' ) &Products=[Products]&Services=[Services]&Certification=[Certification] NVL( p.Country, ' ' )DECODE( p.About_Company, Null, Null, '
' || SUBSTR( p.About_Company, 1, 300 ) || DECODE( SUBSTR( p.About_Company, 301 ), Null, Null, ' ...' || DECODE( p.Profile_URL, Null, 'More', 'More' ) ) )DECODE( ':SortBy', 'Level', DECODE( ':String'||REPLACE(':Products','All',Null), Null, DECODE( p.Partner_Level, 'Referral', '5', 'Silver', '4', 'Gold', '3', 'Platinum', '2', 'Alliance', '1', '9' ), TO_CHAR( 1000 - Data_Util.Search_String( '|' || p.Company_Name || '|' || p.City || '|' || p.State || '|' || p.Country || '|' || p.Partner_Type || '|' || p.Region || '|' || p.Partner_Level || '|' || p.Custom_Data_3 || '|', ':String' ), '099999990' ) ), 'Name', LOWER( p.Company_Name ), 'Location', UPPER( NVL( TRIM( p.City ), 'ZZZ' ) || ' ' || NVL( TRIM( p.State ), 'ZZZ' ) || ' ' || NVL( TRIM( p.Country ), 'ZZZ' ) ), 'Type', LOWER( DECODE( p.Partner_Type, Null, ' ', REPLACE( REPLACE( REPLACE( p.Partner_Type, '', ', ' ), '', Null ), '', Null ) ) ), DECODE( p.Partner_Level, 'Referral', '5', 'Silver', '4', 'Gold', '3', 'Platinum', '2', 'Alliance', '1', '9' ) )DECODE( p.Profile_URL, Null, '/pages/partners/directory/partner_profile.html?p_Partner_Id=' || p.Partner_Id, REPLACE( '/pages/partners/directory/partner_profile.html?p_Partner_Id=' || p.Partner_Id, U.Get_URL( 'WWW' ), Null ) || '&String=[String]&Region=[Region]&State=[State]&Partner_Type=[Partner_Type]' )( SELECT DISTINCT p.Partner_Id, p.Doc_Id, p.Company_Name, p.Partner_Level, p.Partner_Type, p.Custom_Data_3, p.Profile_URL, p.Website_URL, REPLACE( REPLACE( REPLACE( REPLACE( p.About_Company, '

', Null ), '

', Null ) About_Company, p.City, p.State, p.Country, p.Region, Data_Util.Search_String( '|' || p.Company_Name || '|' || p.City || '|' || p.State || '|' || SUBSTR( p.About_Company, 1, 1000 ) || '|' || p.Country || '|' || p.Partner_Type || '|' || p.Region || '|' || p.Partner_Level || '|' || p.Custom_Data_3 || '|', ':String' ) P_Score FROM Partners p, Locations l WHERE p.Partner_Id = l.Partner_Id(+) AND NVL( p.Status, '?' ) NOT IN ( 'Deleted', 'Pending' ) AND ( p.Locator_OptIn IS NULL OR p.Locator_OptIn != 'N' ) AND p.Profile_URL IS NOT NULL AND ( ':String' IS NULL OR Data_Util.Search_String( '|' || p.Company_Name || '|' || p.City || '|' || p.State || '|' || SUBSTR( p.About_Company, 1, 1000 ) || '|' || p.Country || '|' || p.Partner_Type || '|' || p.Region || '|' || p.Partner_Level || '|' || p.Custom_Data_3 || '|', ':String' ) > 0 OR Data_Util.Search_String( '|' || l.Company_Name || '|' || l.City || '|' || l.State || '|' || l.Country || '|' || l.Region || '|', ':String' ) > 0 ) AND ( ':Partner_Type' = 'All' OR INSTR( '>' || NVL( p.Partner_Type, '?' ) || '<', '>:Partner_Type<' ) != 0 ) AND ( ':Region' = 'All' OR ( ':Region' IN ( 'United States', 'Canada' ) AND NVL( p.Country, '?' ) = ':Region' AND ( ':State' = 'All' OR NVL( p.State, '?' ) = ':State' ) ) OR ( ':Region' IN ( 'United States', 'Canada' ) AND NVL( l.Country, '?' ) = ':Region' AND ( ':State' = 'All' OR NVL( l.State, '?' ) = ':State' ) ) OR ( ':Region' NOT IN ( 'All', 'United States', 'Canada' ) AND ( ':Region' = 'All' OR NVL( p.Country, '?' ) = ':Region' ) OR ( ':Region' NOT IN ( 'All', 'United States', 'Canada' ) AND ( ':Region' = 'All' OR NVL( l.Country, '?' ) = ':Region' ) ) ) ) ) pDECODE( ':SortBy', 'Level', DECODE( ':String'||REPLACE(':Products','All',Null), Null, DECODE( p.Partner_Level, 'Referral', '5', 'Silver', '4', 'Gold', '3', 'Platinum', '2', 'Alliance', '1', '9' ), TO_CHAR( 1000 - Data_Util.Search_String( '|' || p.Company_Name || '|' || p.City || '|' || p.State || '|' || SUBSTR( p.About_Company, 1, 500 ) || '|' || p.Country || '|' || p.Partner_Type || '|' || p.Region || '|' || p.Partner_Level || '|' || p.Custom_Data_3 || '|', ':String' ), '099999990' ) ), 'Name', LOWER( p.Company_Name ), 'Location', UPPER( NVL( TRIM( p.City ), 'ZZZ' ) || ' ' || NVL( TRIM( p.State ), 'ZZZ' ) || ' ' || NVL( TRIM( p.Country ), 'ZZZ' ) ), 'Type', LOWER( DECODE( p.Partner_Type, Null, ' ', REPLACE( REPLACE( REPLACE( p.Partner_Type, '', ', ' ), '', Null ), '', Null ) ) ), DECODE( p.Partner_Level, 'Referral', '5', 'Silver', '4', 'Gold', '3', 'Platinum', '2', 'Alliance', '1', '9' ) ), LOWER( p.Company_Name )DECODE( p.Products, Null, ' ', REPLACE( REPLACE( REPLACE( p.Products, '', ', ' ), '', Null ), '', Null ) )DECODE( p.Services, Null, ' ', REPLACE( REPLACE( REPLACE( p.Services, '', ', ' ), '', Null ), '', Null ) ) AND ( ':Products' = 'All' OR INSTR( NVL( p.Products, '?' ), ':Products' ) != 0 ) AND ( ':Services' = 'All' OR INSTR( NVL( p.Services, '?' ), ':Services' ) != 0 ) AND ( ':Certification' = 'All' OR INSTR( NVL( p.Certification, '?' ), ':Certification' ) != 0 ) 'Products', LOWER( DECODE( p.Products, Null, ' ', REPLACE( REPLACE( REPLACE( p.Products, '', ', ' ), '', Null ), '', Null ) ) ), 'Services', LOWER( DECODE( p.Services, Null, ' ', REPLACE( REPLACE( REPLACE( p.Services, '', ', ' ), '', Null ), '', Null ) ) ), Break [Break]

' || DECODE( p.Partner_Level, Null, 'Other Partners', p.Partner_Level || ' Partner' ) || '

' || '' || ' Edit this Profile

' || DECODE( p.Profile_URL, Null, Null, '' || ' Un-Publish this Profile

' ) || '

[Company_Name] [Partner_Level][Partner_Type][About_Company]

Y S 5 Y [String] [Partner_Id] [Region] [State] DISTINCT DECODE( l.Address_1 || l.City || l.State || l.Country, Null, Null, DECODE( TRIM( l.Address_1 ), Null, Null, l.Address_1 || ', ' ) || DECODE( TRIM( l.City ), Null, Null, l.City || ', ' ) || DECODE( TRIM( l.State ), Null, Null, l.City, Null, l.State || ', ' ) || DECODE( l.Country, Null, Null, 'United States', 'USA', l.Country ) ) || DECODE( l.Location_Type, 'HQ', ' (HQ)', Null ) DISTINCT DECODE( l.City || l.State || l.Country, Null, Null, DECODE( TRIM( l.City ), Null, Null, l.City || ', ' ) || DECODE( TRIM( l.State ), Null, Null, l.City, Null, l.State || ', ' ) || DECODE( l.Country, Null, Null, 'United States', 'USA', l.Country ) ) || DECODE( l.Location_Type, 'HQ', ' (HQ)', Null ) TO_CHAR( 1000 - Data_Util.Search_String( '|' || l.Company_Name || '|' || l.City || '|' || l.State || '|' || l.Country || '|' || l.Region || '|', ':String' ) ) DECODE( l.Location_Type, 'HQ', '1', '2' ) '[Row' || '_Number]' Locations l l.Partner_Id = ':Partner_Id' AND ( ':String' IS NULL OR Data_Util.Search_String( '|:String|' || l.Company_Name || '|' || l.City || '|' || l.State || '|' || l.Country || '|' || l.Region || '|', ':String' ) > 0 ) AND ( ':Region' = 'All' OR ( ':Region' IN ( 'United States', 'Canada' ) AND NVL( l.Country, '?' ) = ':Region' AND ( ':State' = 'All' OR NVL( l.State, '?' ) = ':State' ) ) OR ( ':Region' NOT IN ( 'All', 'United States', 'Canada' ) AND ( ':Region' = 'All' OR NVL( l.Country, '?' ) = ':Region' ) ) ) TO_CHAR( 1000 - Data_Util.Search_String( '|' || l.Company_Name || '|' || l.City || '|' || l.State || '|' || l.Country || '|' || l.Region || '|', ':String' ) ), DECODE( l.Location_Type, 'HQ', '1', '2' ) { DECODE( '[Row_Id]', '5', '', Null ) }

	Office Locations:
	- [Location]	More
	No information available

There are no partners that match your search criteria.

[Record_Nav]