Advertisement
Advertisement
| 05.16.2008 at 11:28AM PDT, ID: 23409303 |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
|
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
| Microsoft |
| Apple |
| Internet |
| Gamers |
| Digital Living |
| Virus & Spyware |
| Hardware |
| Software |
| ITPro |
| Developer |
| Storage |
| OS |
| Database |
| Security |
| Programming |
| Web Development |
| Networking |
| Other |
| Community Support |
| 05.16.2008 at 12:03PM PDT, ID: 21585484 |
| 05.16.2008 at 12:07PM PDT, ID: 21585509 |
| 05.16.2008 at 12:23PM PDT, ID: 21585643 |
| 05.20.2008 at 11:04AM PDT, ID: 21608638 |
| 05.20.2008 at 04:14PM PDT, ID: 21611083 |
| 05.20.2008 at 06:54PM PDT, ID: 21611659 |
| 05.21.2008 at 03:08PM PDT, ID: 21619455 |
| 05.22.2008 at 05:23AM PDT, ID: 21623069 |
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: |
SELECT email_address
FROM (SELECT xec.email_address
FROM apps.xx_contact_emails xec,
disc.local_license_details lld,
apps.xx_license_contacts xxlc,
apps.ra_contact_roles rcr,
disc.local_contacts lc
WHERE lc.country != 'Japan'
AND NVL(lc.bad_email, 'N') = 'N'
AND lc.contact_status = 'A'
AND NVL(lc.restricted_email, 'N') = 'N'
AND lc.contact_id = xec.contact_id
AND lc.contact_id = rcr.contact_id
AND rcr.contact_role_id = xxlc.contact_role_id
AND xxlc.license_id = lld.license_id
AND lld.VERSION >= '6'
AND lld.license_status = 'Latest'
AND rcr.usage_code IN('REGISTER', 'SITE', 'MARKET')
AND NOT EXISTS(
SELECT 1
FROM as_interests_all ai,
as_interest_codes_all aic2,
as_interest_codes_all aic,
as_interest_types_all ait
WHERE lc.contact_id = ai.contact_id
AND aic.interest_type_id = ait.interest_type_id
AND aic.interest_code_id = ai.primary_interest_code_id
AND aic2.interest_code_id(+) =
ai.secondary_interest_code_id
AND ait.interest_type = 'Marketing list'
AND aic.code IN
('Online Seminars', 'Wolfram Education Group')
AND ai.status_code = 'REMOVE'
AND ROWNUM = 1)
UNION
SELECT xec.email_address
FROM apps.xx_contact_emails xec, disc.local_contacts lc
WHERE lc.contact_creation_date > ADD_MONTHS(SYSDATE, -6)
AND lc.country != 'Japan'
AND lc.contact_id = xec.contact_id
AND NOT EXISTS(
SELECT 1
FROM apps.ra_contact_roles rcr
WHERE lc.contact_id = rcr.contact_id
AND rcr.usage_code IS NOT NULL
AND ROWNUM = 1))
MINUS
SELECT xec.email_address
FROM apps.xx_contact_emails xec,
ra_contacts rco,
ra_customers rcu,
ra_addresses_all raa,
ra_contacts_dfv rcd,
as_interests_all ai,
as_interest_codes_all aic2,
as_interest_codes_all aic,
as_interest_types_all ait
WHERE rcu.customer_id = raa.customer_id
AND rco.contact_id = xec.contact_id
AND raa.address_id = rco.address_id
AND rcu.sales_channel_code NOT IN('CERTRESELL', 'RESELLER')
AND rco.status = 'A'
AND rcu.status = 'A'
AND rco.ROWID = rcd.row_id
AND ai.contact_id = rco.contact_id
AND aic.interest_type_id = ait.interest_type_id
AND aic.interest_code_id = ai.primary_interest_code_id
AND aic2.interest_code_id(+) = ai.secondary_interest_code_id
AND ait.interest_type = 'Marketing list'
AND aic.code = 'Online Seminars'
AND ai.status_code = 'REMOVE'
|
