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.

APPS.OKS_CUSTOMER_ACCEPTANCE_PVT dependencies on FND_USER

Line 833: AND res.user_name IS NOT NULL -- Salesrep MUST be a FND USER

829: AND ct.jtot_object1_code='OKX_SALEPERS' --bug 6243682
830: AND res.CATEGORY IN
831: ('EMPLOYEE', 'OTHER', 'PARTY', 'PARTNER', 'SUPPLIER_CONTACT')
832: -- AND srp.email_address IS NOT NULL -- bug 4918198
833: AND res.user_name IS NOT NULL -- Salesrep MUST be a FND USER
834: AND khr.ID = p_chr_id;
835:
836: -- bug 5218842
837: CURSOR csr_party_helpdesk (

Line 3610: AND res.user_name IS NOT NULL -- Salesrep MUST BE a FND USER

3606: AND ct.jtot_object1_code='OKX_SALEPERS' --bug 6243682
3607: AND res.CATEGORY IN
3608: ('EMPLOYEE', 'OTHER', 'PARTY', 'PARTNER', 'SUPPLIER_CONTACT')
3609: -- AND srp.email_address IS NOT NULL -- bug 4918198
3610: AND res.user_name IS NOT NULL -- Salesrep MUST BE a FND USER
3611: AND khr.ID = p_chr_id;
3612:
3613: CURSOR csr_party_helpdesk (
3614: p_k_party_id IN NUMBER

Line 3617: fnd.user_name

3613: CURSOR csr_party_helpdesk (
3614: p_k_party_id IN NUMBER
3615: ) IS
3616: SELECT gcd.email_address,
3617: fnd.user_name
3618: FROM oks_k_defaults gcd,
3619: fnd_user fnd
3620: WHERE gcd.user_id = fnd.user_id
3621: AND gcd.cdt_type = 'SDT'

Line 3619: fnd_user fnd

3615: ) IS
3616: SELECT gcd.email_address,
3617: fnd.user_name
3618: FROM oks_k_defaults gcd,
3619: fnd_user fnd
3620: WHERE gcd.user_id = fnd.user_id
3621: AND gcd.cdt_type = 'SDT'
3622: AND gcd.jtot_object_code = 'OKX_PARTY'
3623: -- AND gcd.email_address IS NOT NULL -- bug 4918198

Line 3620: WHERE gcd.user_id = fnd.user_id

3616: SELECT gcd.email_address,
3617: fnd.user_name
3618: FROM oks_k_defaults gcd,
3619: fnd_user fnd
3620: WHERE gcd.user_id = fnd.user_id
3621: AND gcd.cdt_type = 'SDT'
3622: AND gcd.jtot_object_code = 'OKX_PARTY'
3623: -- AND gcd.email_address IS NOT NULL -- bug 4918198
3624: AND gcd.segment_id1 = p_k_party_id;

Line 3630: fnd.user_name

3626: CURSOR csr_org_helpdesk (
3627: p_k_org_id IN NUMBER
3628: ) IS
3629: SELECT gcd.email_address,
3630: fnd.user_name
3631: FROM oks_k_defaults gcd,
3632: fnd_user fnd
3633: WHERE gcd.user_id = fnd.user_id
3634: AND gcd.cdt_type = 'SDT'

Line 3632: fnd_user fnd

3628: ) IS
3629: SELECT gcd.email_address,
3630: fnd.user_name
3631: FROM oks_k_defaults gcd,
3632: fnd_user fnd
3633: WHERE gcd.user_id = fnd.user_id
3634: AND gcd.cdt_type = 'SDT'
3635: AND gcd.jtot_object_code = 'OKX_OPERUNIT'
3636: -- AND gcd.email_address IS NOT NULL -- bug 4918198

Line 3633: WHERE gcd.user_id = fnd.user_id

3629: SELECT gcd.email_address,
3630: fnd.user_name
3631: FROM oks_k_defaults gcd,
3632: fnd_user fnd
3633: WHERE gcd.user_id = fnd.user_id
3634: AND gcd.cdt_type = 'SDT'
3635: AND gcd.jtot_object_code = 'OKX_OPERUNIT'
3636: -- AND gcd.email_address IS NOT NULL -- bug 4918198
3637: AND gcd.segment_id1 = p_k_org_id;

Line 3641: fnd.user_name

3637: AND gcd.segment_id1 = p_k_org_id;
3638:
3639: CURSOR csr_global_helpdesk IS
3640: SELECT gcd.email_address,
3641: fnd.user_name
3642: FROM oks_k_defaults gcd,
3643: fnd_user fnd
3644: WHERE gcd.user_id = fnd.user_id
3645: AND gcd.cdt_type = 'MDT';

Line 3643: fnd_user fnd

3639: CURSOR csr_global_helpdesk IS
3640: SELECT gcd.email_address,
3641: fnd.user_name
3642: FROM oks_k_defaults gcd,
3643: fnd_user fnd
3644: WHERE gcd.user_id = fnd.user_id
3645: AND gcd.cdt_type = 'MDT';
3646: BEGIN
3647: -- start debug log

Line 3644: WHERE gcd.user_id = fnd.user_id

3640: SELECT gcd.email_address,
3641: fnd.user_name
3642: FROM oks_k_defaults gcd,
3643: fnd_user fnd
3644: WHERE gcd.user_id = fnd.user_id
3645: AND gcd.cdt_type = 'MDT';
3646: BEGIN
3647: -- start debug log
3648: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN