I am trying to have our Oracle engineers send and receive mail as an
external entity/user with GroupWise MTA v6.0.4

How do I set this up and is this possible?
Thank you
Eric

Here is the Oracle script.
How do I get this to send and receive with GroupWise NTA v6.0.4


SELECT /*+NO_MERGE(core_sql)*/
/************************************************** ****
**
** Alert Name : HRMS Alert- Direct Hires
** Version Number : 115.2
**2
** PLEASE READ
** =============
** 1/ Please read the Oracle HRMS Alerts Supplement
** before using Oracle HRMS Alerts.
** 2/ It is recommended that before using this Alert
** that you copy and rename it.
** 3/ Changing the SQL for this Alert is not supported.
**
************************************************** ****/
/*Get the Alert Recipient Email Addresses */
CASE
WHEN lkp_lookup_code = 'NAMED_USER' THEN
(:SEND_TO_NAMED_USER)
WHEN lkp_lookup_code = 'ASG_SPVSR' THEN
hr_view_alert_recipient.Get_asg_sup_eml_addrss(wrk _asg_assignment_id)
WHEN lkp_lookup_code = 'PASG_SPVSR' THEN
hr_view_alert_recipient.Get_pasg_sup_eml_addrss(wr k_asg_assignment_id)
END rcpt_email_address
/* MESSAGE- Email Subject */
,CASE
WHEN lkp_lookup_code = 'NAMED_USER' THEN
hr_view_alert_messages.get_message_lng_psn
('HR_AT_WRKLST',wrk_asg_person_id)
WHEN lkp_lookup_code = 'ASG_SPVSR' THEN
hr_view_alert_messages.get_message_lng_sup
('HR_AT_WRKLST',wrk_asg_assignment_id)
WHEN lkp_lookup_code = 'PASG_SPVSR' THEN
hr_view_alert_messages.get_message_lng_psup
('HR_AT_WRKLST',wrk_asg_assignment_id)
END hr_at_wrklst
/* MESSAGE - Email Header Text */
,CASE
WHEN lkp_lookup_code = 'NAMED_USER' THEN
hr_view_alert_messages.get_message_lng_psn
('HR_AH_WRKLST',wrk_asg_person_id)
WHEN lkp_lookup_code = 'ASG_SPVSR' THEN
hr_view_alert_messages.get_message_lng_sup
('HR_AH_WRKLST',wrk_asg_assignment_id)
WHEN lkp_lookup_code = 'PASG_SPVSR' THEN
hr_view_alert_messages.get_message_lng_psup
('HR_AH_WRKLST',wrk_asg_assignment_id)
END hr_ah_wrklst
,CASE
WHEN lkp_lookup_code = 'NAMED_USER' THEN
hr_view_alert_messages.get_message_lng_psn('HR_AB_ WRKLST'
,psn_full_name
,hr_view_alert_messages.get_message_lng_psn(
DECODE(psn_current_employee_flag
,'Y'
,'HR_AO_EMPLOYEE'
,DECODE(psn_current_npw_flag
,'Y'
,'HR_AO_CONTINGENT'
,'HR_AO_OTHER'))
,psn_person_id)
,NVL(psn_employee_number, psn_npw_number)
,hr_view_alert_messages.get_message_lng_psn(
DECODE(wrk_asg_primary_flag
,'Y'
,'HR_AO_ASG_PRIMARY'
,'HR_AO_ASG_SECONDARY')
,psn_person_id)
,hr_view_alert_recipient.get_asg_sup_nm(wrk_asg_as signment_id) --New
Column
,hr_view_alert_trnslt.psn_lng_job(
psn_person_id
,wrk_asg_job_id)
,hr_view_alert_trnslt.psn_lng_position(
psn_person_id
,wrk_asg_position_id)
,hr_view_alert_trnslt.psn_lng_grade(
psn_person_id
,wrk_asg_grade_id)
,pay_payroll_name
,hr_view_alert_trnslt.psn_lng_organization(
psn_person_id
,wrk_asg_business_group_id)
,hr_view_alert_trnslt.psn_lng_organization(
psn_person_id
,wrk_asg_organization_id)
,hr_view_alert_trnslt.psn_lng_location(
psn_person_id
,wrk_asg_location_id)
,wrk_asg_person_id)
WHEN lkp_lookup_code = 'ASG_SPVSR' THEN
hr_view_alert_messages.get_message_lng_sup('HR_AB_ WRKLST'
,psn_full_name
,hr_view_alert_messages.get_message_lng_sup(
DECODE(psn_current_employee_flag
,'Y'
,'HR_AO_EMPLOYEE'
,DECODE(psn_current_npw_flag
,'Y'
,'HR_AO_CONTINGENT'
,'HR_AO_OTHER'))
,wrk_asg_assignment_id)
,NVL(psn_employee_number, psn_npw_number)
,hr_view_alert_messages.get_message_lng_sup(
DECODE(wrk_asg_primary_flag
,'Y'
,'HR_AO_ASG_PRIMARY'
,'HR_AO_ASG_SECONDARY')
,wrk_asg_assignment_id)
,hr_view_alert_recipient.get_asg_sup_nm(wrk_asg_as signment_id)
,hr_view_alert_trnslt.asg_sup_lng_job(
wrk_asg_assignment_id
,wrk_asg_job_id)
,hr_view_alert_trnslt.asg_sup_lng_position(
wrk_asg_assignment_id
,wrk_asg_position_id)
,hr_view_alert_trnslt.asg_sup_lng_grade(
wrk_asg_assignment_id
,wrk_asg_grade_id)
,pay_payroll_name
,hr_view_alert_trnslt.asg_sup_lng_organization(
wrk_asg_assignment_id
,wrk_asg_business_group_id)
,hr_view_alert_trnslt.asg_sup_lng_organization(
wrk_asg_assignment_id
,wrk_asg_organization_id)
,hr_view_alert_trnslt.asg_sup_lng_location(
wrk_asg_assignment_id
,wrk_asg_location_id)
,wrk_asg_assignment_id)
WHEN lkp_lookup_code = 'PASG_SPVSR' THEN
hr_view_alert_messages.get_message_lng_psup('HR_AB _WRKLST'
,psn_full_name
,hr_view_alert_messages.get_message_lng_psup(
DECODE(psn_current_employee_flag
,'Y'
,'HR_AO_EMPLOYEE'
,DECODE(psn_current_npw_flag
,'Y'
,'HR_AO_CONTINGENT'
,'HR_AO_OTHER'))
,wrk_asg_assignment_id)
,NVL(psn_employee_number, psn_npw_number)
,hr_view_alert_messages.get_message_lng_psup(
DECODE(wrk_asg_primary_flag
,'Y'
,'HR_AO_ASG_PRIMARY'
,'HR_AO_ASG_SECONDARY')
,wrk_asg_assignment_id)
,hr_view_alert_recipient.get_asg_sup_nm(wrk_asg_as signment_id) --New
Column
,hr_view_alert_trnslt.pasg_sup_lng_job(
wrk_asg_assignment_id
,wrk_asg_job_id)
,hr_view_alert_trnslt.pasg_sup_lng_position(
wrk_asg_assignment_id
,wrk_asg_position_id)
,hr_view_alert_trnslt.pasg_sup_lng_grade(
wrk_asg_assignment_id
,wrk_asg_grade_id)
,pay_payroll_name
,hr_view_alert_trnslt.pasg_sup_lng_organization(
wrk_asg_assignment_id
,wrk_asg_business_group_id)
,hr_view_alert_trnslt.pasg_sup_lng_organization(
wrk_asg_assignment_id
,wrk_asg_organization_id)
,hr_view_alert_trnslt.pasg_sup_lng_location(
wrk_asg_assignment_id
,wrk_asg_location_id)
,wrk_asg_assignment_id)
END hr_ab_wrklst
,psn_full_name orderby1
INTO
&rcpt_email_address
,&hr_at_wrklst
,&hr_ah_wrklst
,&hr_ab_wrklst
,&orderby1
FROM (
SELECT /*+ NO_MERGE */
wrk_asg_assignment_id
wrk_asg_assignment_id
,wrk_asg_person_id
wrk_asg_person_id
,psn_current_employee_flag
psn_current_employee_flag
,psn_current_npw_flag
psn_current_npw_flag
,psn_person_id
psn_person_id
,psn_employee_number
psn_employee_number
,psn_npw_number
psn_npw_number
,wrk_asg_primary_flag
wrk_asg_primary_flag
,wrk_asg_job_id
wrk_asg_job_id
,wrk_asg_position_id
wrk_asg_position_id
,wrk_asg_grade_id
wrk_asg_grade_id
,pay_payroll_name
pay_payroll_name
,wrk_asg_business_group_id
wrk_asg_business_group_id
,wrk_asg_organization_id
wrk_asg_organization_id
,wrk_asg_location_id
wrk_asg_location_id
,lkp.lookup_code
lkp_lookup_code
,psn_full_name
psn_full_name
FROM
(
SELECT /*+ NO_MERGE ORDERED */
wrk_asg.assignment_id
wrk_asg_assignment_id
,wrk_asg.person_id
wrk_asg_person_id
,psn.current_employee_flag
psn_current_employee_flag
,psn.current_npw_flag
psn_current_npw_flag
,psn.person_id
psn_person_id
,psn.employee_number
psn_employee_number
,psn.npw_number
psn_npw_number
,wrk_asg.primary_flag
wrk_asg_primary_flag
,wrk_asg.job_id
wrk_asg_job_id
,wrk_asg.position_id
wrk_asg_position_id
,wrk_asg.grade_id
wrk_asg_grade_id
,pay.payroll_name
pay_payroll_name
,wrk_asg.business_group_id
wrk_asg_business_group_id
,wrk_asg.organization_id
wrk_asg_organization_id
,wrk_asg.location_id
wrk_asg_location_id
,psn.full_name
psn_full_name
FROM hr_all_organization_units org1
,per_all_assignments_f wrk_asg
,per_all_people_f psn
,pay_all_payrolls_f pay
WHERE
/* joins */
TRUNC(SYSDATE) BETWEEN wrk_asg.effective_start_date
AND wrk_asg.effective_end_date
AND wrk_asg.person_id = psn.person_id
AND TRUNC(SYSDATE) BETWEEN psn.effective_start_date
AND psn.effective_end_date
AND wrk_asg.payroll_id = pay.payroll_id (+)
AND TRUNC(SYSDATE) BETWEEN pay.effective_start_date (+)
AND pay.effective_end_date (+)
/* Restrictions */
AND wrk_asg.assignment_type IN ('E','C')
/* Configurable scope */
AND (((psn.current_employee_flag = 'Y') AND
(:INCLUDE_EMP_FLAG = 'Y')) OR
((psn.current_npw_flag = 'Y') AND
(:INCLUDE_CONT_FLAG = 'Y')))
/* security */
AND wrk_asg.organization_id = org1.organization_id
AND TRUNC(SYSDATE)
BETWEEN org1.date_from
AND NVL(org1.date_to
,hr_general.end_of_time)
AND (
(:INCLUDE_BUSINESS_GROUP IS NULL)
AND
(:INCLUDE_ORGANIZATION IS NOT NULL)
AND
(org1.name =
:INCLUDE_ORGANIZATION)
)
UNION ALL
SELECT /*+ NO_MERGE ORDERED */
wrk_asg.assignment_id
wrk_asg_assignment_id
,wrk_asg.person_id
wrk_asg_person_id
,psn.current_employee_flag
psn_current_employee_flag
,psn.current_npw_flag
psn_current_npw_flag
,psn.person_id
psn_person_id
,psn.employee_number
psn_employee_number
,psn.npw_number
psn_npw_number
,wrk_asg.primary_flag
wrk_asg_primary_flag
,wrk_asg.job_id
wrk_asg_job_id
,wrk_asg.position_id
wrk_asg_position_id
,wrk_asg.grade_id
wrk_asg_grade_id
,pay.payroll_name
pay_payroll_name
,wrk_asg.business_group_id
wrk_asg_business_group_id
,wrk_asg.organization_id
wrk_asg_organization_id
,wrk_asg.location_id
wrk_asg_location_id
,psn.full_name
psn_full_name
FROM hr_all_organization_units org2
,per_all_assignments_f wrk_asg
,per_all_people_f psn
,pay_all_payrolls_f pay
WHERE
/* joins */
TRUNC(SYSDATE) BETWEEN wrk_asg.effective_start_date
AND wrk_asg.effective_end_date
AND wrk_asg.person_id = psn.person_id
AND TRUNC(SYSDATE) BETWEEN psn.effective_start_date
AND psn.effective_end_date
AND wrk_asg.payroll_id = pay.payroll_id (+)
AND TRUNC(SYSDATE) BETWEEN pay.effective_start_date (+)
AND pay.effective_end_date (+)
/* Restrictions */
AND wrk_asg.assignment_type IN ('E','C')
/* Configurable scope */
AND (((psn.current_employee_flag = 'Y') AND
(:INCLUDE_EMP_FLAG = 'Y')) OR
((psn.current_npw_flag = 'Y') AND
(:INCLUDE_CONT_FLAG = 'Y')))
/* security */
AND wrk_asg.business_group_id = org2.organization_id
AND TRUNC(SYSDATE)
BETWEEN org2.date_from
AND NVL(org2.date_to
,hr_general.end_of_time)
AND (
(:INCLUDE_ORGANIZATION IS NULL)
AND
(:INCLUDE_BUSINESS_GROUP IS NOT NULL)
AND
(org2.name =
:INCLUDE_BUSINESS_GROUP)
)
UNION ALL
SELECT /*+ NO_MERGE ORDERED */
wrk_asg.assignment_id
wrk_asg_assignment_id
,wrk_asg.person_id
wrk_asg_person_id
,psn.current_employee_flag
psn_current_employee_flag
,psn.current_npw_flag
psn_current_npw_flag
,psn.person_id
psn_person_id
,psn.employee_number
psn_employee_number
,psn.npw_number
psn_npw_number
,wrk_asg.primary_flag
wrk_asg_primary_flag
,wrk_asg.job_id
wrk_asg_job_id
,wrk_asg.position_id
wrk_asg_position_id
,wrk_asg.grade_id
wrk_asg_grade_id
,pay.payroll_name
pay_payroll_name
,wrk_asg.business_group_id
wrk_asg_business_group_id
,wrk_asg.organization_id
wrk_asg_organization_id
,wrk_asg.location_id
wrk_asg_location_id
,psn.full_name
psn_full_name
FROM hr_all_organization_units org2
,hr_all_organization_units org1
,per_all_assignments_f wrk_asg
,per_all_people_f psn
,pay_all_payrolls_f pay
WHERE
/* joins */
TRUNC(SYSDATE) BETWEEN wrk_asg.effective_start_date
AND wrk_asg.effective_end_date
AND wrk_asg.person_id = psn.person_id
AND TRUNC(SYSDATE) BETWEEN psn.effective_start_date
AND psn.effective_end_date
AND wrk_asg.payroll_id = pay.payroll_id (+)
AND TRUNC(SYSDATE) BETWEEN pay.effective_start_date (+)
AND pay.effective_end_date (+)
/* Restrictions */
AND wrk_asg.assignment_type IN ('E','C')
/* Configurable scope */
AND (((psn.current_employee_flag = 'Y') AND
(:INCLUDE_EMP_FLAG = 'Y')) OR
((psn.current_npw_flag = 'Y') AND
(:INCLUDE_CONT_FLAG = 'Y')))
/* security */
AND wrk_asg.organization_id = org1.organization_id
AND wrk_asg.business_group_id = org2.organization_id
AND TRUNC(SYSDATE)
BETWEEN org1.date_from
AND NVL(org1.date_to
,hr_general.end_of_time)
AND TRUNC(SYSDATE)
BETWEEN org2.date_from
AND NVL(org2.date_to
,hr_general.end_of_time)
AND (
(
(:INCLUDE_ORGANIZATION IS NOT NULL)
AND
(:INCLUDE_BUSINESS_GROUP IS NOT NULL)
)
AND
(
(org1.name =
:INCLUDE_ORGANIZATION)
AND
(org2.name =
:INCLUDE_BUSINESS_GROUP)
)
)
UNION ALL
SELECT /*+ NO_MERGE USE_HASH(wrk_asg psn pay) */
wrk_asg.assignment_id
wrk_asg_assignment_id
,wrk_asg.person_id
wrk_asg_person_id
,psn.current_employee_flag
psn_current_employee_flag
,psn.current_npw_flag
psn_current_npw_flag
,psn.person_id
psn_person_id
,psn.employee_number
psn_employee_number
,psn.npw_number
psn_npw_number
,wrk_asg.primary_flag
wrk_asg_primary_flag
,wrk_asg.job_id
wrk_asg_job_id
,wrk_asg.position_id
wrk_asg_position_id
,wrk_asg.grade_id
wrk_asg_grade_id
,pay.payroll_name
pay_payroll_name
,wrk_asg.business_group_id
wrk_asg_business_group_id
,wrk_asg.organization_id
wrk_asg_organization_id
,wrk_asg.location_id
wrk_asg_location_id
,psn.full_name
psn_full_name
FROM per_all_assignments_f wrk_asg
,per_all_people_f psn
,pay_all_payrolls_f pay
WHERE
/* joins */
TRUNC(SYSDATE) BETWEEN wrk_asg.effective_start_date
AND wrk_asg.effective_end_date
AND wrk_asg.person_id = psn.person_id
AND TRUNC(SYSDATE) BETWEEN psn.effective_start_date
AND psn.effective_end_date
AND wrk_asg.payroll_id = pay.payroll_id (+)
AND TRUNC(SYSDATE) BETWEEN pay.effective_start_date (+)
AND pay.effective_end_date (+)
/* Restrictions */
AND wrk_asg.assignment_type IN ('E','C')
/* Configurable scope */
AND (((psn.current_employee_flag = 'Y') AND
(:INCLUDE_EMP_FLAG = 'Y')) OR
((psn.current_npw_flag = 'Y') AND
(:INCLUDE_CONT_FLAG = 'Y')))
/* security */
AND ((:INCLUDE_BUSINESS_GROUP IS NULL) AND
(:INCLUDE_ORGANIZATION IS NULL))
) central_sql
,hr_lookups lkp
WHERE lkp.lookup_type = 'HR_ALERT_RECIPIENTS'
AND lkp.lookup_code IN ('NAMED_USER'
,'ASG_SPVSR'
,'PASG_SPVSR')
) core_sql
WHERE (((lkp_lookup_code = 'NAMED_USER') AND
(:SEND_TO_NAMED_USER <> 'N'))
OR
((lkp_lookup_code = 'ASG_SPVSR') AND
(:SEND_TO_ASG_SPVSR = 'Y') AND
(hr_view_alert_recipient.Check_asg_sup_in_scope(
wrk_asg_assignment_id) = wrk_asg_assignment_id))
OR
((lkp_lookup_code = 'PASG_SPVSR') AND
(:SEND_TO_PASG_SPVSR = 'Y') AND
(hr_view_alert_recipient.Check_pasg_sup_in_scope(
wrk_asg_assignment_id) = wrk_asg_assignment_id)))
ORDER BY 1,5