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_CCMIGRATE_PVT dependencies on OKC_RULES_B

Line 2668: From okc_rules_b rl

2664: FROM
2665: (SELECT /*+ no_merge parallel(khdr) */ ID, FLOOR((ROWNUM-1)/l_bucket_size) Worker_Bucket
2666: FROM
2667: ( Select rl.Id
2668: From okc_rules_b rl
2669: , okc_rule_groups_b rg
2670: , Oks_k_headers_b Kh
2671: Where rl.rgp_id = rg.id
2672: And rl.rule_information_category = 'CCR'

Line 2948: Update okc_rules_bh

2944: cc_auth_code = null
2945: Where id = l_hdr_id(i);
2946:
2947: Forall i in l_chr_id.first..l_chr_id.last
2948: Update okc_rules_bh
2949: Set rule_information1 = null,
2950: rule_information2 = null,
2951: rule_information3 = null,
2952: rule_information4 = null

Line 3003: Update okc_rules_b

2999: cc_auth_code = null
3000: Where id = l_hdr_id(i);
3001:
3002: Forall i in l_chr_id.first..l_chr_id.last
3003: Update okc_rules_b
3004: Set rule_information1 = null,
3005: rule_information2 = null,
3006: rule_information3 = null,
3007: rule_information4 = null

Line 3029: From okc_rules_b rl

3025:
3026:
3027: Cursor l_hdr_rule_csr Is
3028: Select rl.Id
3029: From okc_rules_b rl
3030: , okc_rule_groups_b rg
3031: , Oks_k_headers_b Kh
3032: Where rl.rgp_id = rg.id
3033: And rl.rule_information_category = 'CCR'

Line 3056: Update okc_rules_b

3052:
3053: -- Update Header Rule table
3054:
3055: Forall i in l_hdr_id.first..l_hdr_id.last
3056: Update okc_rules_b
3057: Set rule_information1 = null
3058: Where id = l_hdr_id(i);
3059:
3060: End Loop;