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 3658: AND res.user_name IS NOT NULL -- Salesrep MUST BE a FND USER

3654: AND ct.jtot_object1_code='OKX_SALEPERS' --bug 6243682
3655: AND res.CATEGORY IN
3656: ('EMPLOYEE', 'OTHER', 'PARTY', 'PARTNER', 'SUPPLIER_CONTACT')
3657: -- AND srp.email_address IS NOT NULL -- bug 4918198
3658: AND res.user_name IS NOT NULL -- Salesrep MUST BE a FND USER
3659: AND khr.ID = p_chr_id;
3660:
3661: CURSOR csr_party_helpdesk (
3662: p_k_party_id IN NUMBER

Line 3665: fnd.user_name

3661: CURSOR csr_party_helpdesk (
3662: p_k_party_id IN NUMBER
3663: ) IS
3664: SELECT gcd.email_address,
3665: fnd.user_name
3666: FROM oks_k_defaults gcd,
3667: fnd_user fnd
3668: WHERE gcd.user_id = fnd.user_id
3669: AND gcd.cdt_type = 'SDT'

Line 3667: fnd_user fnd

3663: ) IS
3664: SELECT gcd.email_address,
3665: fnd.user_name
3666: FROM oks_k_defaults gcd,
3667: fnd_user fnd
3668: WHERE gcd.user_id = fnd.user_id
3669: AND gcd.cdt_type = 'SDT'
3670: AND gcd.jtot_object_code = 'OKX_PARTY'
3671: -- AND gcd.email_address IS NOT NULL -- bug 4918198

Line 3668: WHERE gcd.user_id = fnd.user_id

3664: SELECT gcd.email_address,
3665: fnd.user_name
3666: FROM oks_k_defaults gcd,
3667: fnd_user fnd
3668: WHERE gcd.user_id = fnd.user_id
3669: AND gcd.cdt_type = 'SDT'
3670: AND gcd.jtot_object_code = 'OKX_PARTY'
3671: -- AND gcd.email_address IS NOT NULL -- bug 4918198
3672: AND gcd.segment_id1 = p_k_party_id;

Line 3678: fnd.user_name

3674: CURSOR csr_org_helpdesk (
3675: p_k_org_id IN NUMBER
3676: ) IS
3677: SELECT gcd.email_address,
3678: fnd.user_name
3679: FROM oks_k_defaults gcd,
3680: fnd_user fnd
3681: WHERE gcd.user_id = fnd.user_id
3682: AND gcd.cdt_type = 'SDT'

Line 3680: fnd_user fnd

3676: ) IS
3677: SELECT gcd.email_address,
3678: fnd.user_name
3679: FROM oks_k_defaults gcd,
3680: fnd_user fnd
3681: WHERE gcd.user_id = fnd.user_id
3682: AND gcd.cdt_type = 'SDT'
3683: AND gcd.jtot_object_code = 'OKX_OPERUNIT'
3684: -- AND gcd.email_address IS NOT NULL -- bug 4918198

Line 3681: WHERE gcd.user_id = fnd.user_id

3677: SELECT gcd.email_address,
3678: fnd.user_name
3679: FROM oks_k_defaults gcd,
3680: fnd_user fnd
3681: WHERE gcd.user_id = fnd.user_id
3682: AND gcd.cdt_type = 'SDT'
3683: AND gcd.jtot_object_code = 'OKX_OPERUNIT'
3684: -- AND gcd.email_address IS NOT NULL -- bug 4918198
3685: AND gcd.segment_id1 = p_k_org_id;

Line 3689: fnd.user_name

3685: AND gcd.segment_id1 = p_k_org_id;
3686:
3687: CURSOR csr_global_helpdesk IS
3688: SELECT gcd.email_address,
3689: fnd.user_name
3690: FROM oks_k_defaults gcd,
3691: fnd_user fnd
3692: WHERE gcd.user_id = fnd.user_id
3693: AND gcd.cdt_type = 'MDT';

Line 3691: fnd_user fnd

3687: CURSOR csr_global_helpdesk IS
3688: SELECT gcd.email_address,
3689: fnd.user_name
3690: FROM oks_k_defaults gcd,
3691: fnd_user fnd
3692: WHERE gcd.user_id = fnd.user_id
3693: AND gcd.cdt_type = 'MDT';
3694: BEGIN
3695: -- start debug log

Line 3692: WHERE gcd.user_id = fnd.user_id

3688: SELECT gcd.email_address,
3689: fnd.user_name
3690: FROM oks_k_defaults gcd,
3691: fnd_user fnd
3692: WHERE gcd.user_id = fnd.user_id
3693: AND gcd.cdt_type = 'MDT';
3694: BEGIN
3695: -- start debug log
3696: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN