APPS.OKS_CCMIGRATE_PVT dependencies on OKS_K_HEADERS_B

Line 142: FROM oks_k_headers_b okshdr

138: FROM
139: (SELECT /*+ no_merge parallel(khdr) */ ID, FLOOR((ROWNUM-1)/l_bucket_size) Worker_Bucket
140: FROM
141: ( SELECT id
142: FROM oks_k_headers_b okshdr
143: WHERE okshdr.cc_no IS NOT NULL
144: AND okshdr.payment_type = 'CCR'
145: AND okshdr.trxn_extension_id is null
146: order by id) KHDR) WB GROUP BY Worker_Bucket) WBR;

Line 174: From OKS_K_HEADERS_B okshdr ;

170: max(okshdr.id) maxid,
171: avg(okshdr.id) avgid,
172: stddev(okshdr.id) stdid,
173: count(*) total
174: From OKS_K_HEADERS_B okshdr ;
175: Cursor l_hdr_agg_csr2 IS
176:
177: Select /*+ PARALLEL(okshdrh) */
178: min(okshdrh.id) minid,

Line 183: From OKS_K_HEADERS_BH okshdrh ;

179: max(okshdrh.id) maxid,
180: avg(okshdrh.id) avgid,
181: stddev(okshdrh.id) stdid,
182: count(*) total
183: From OKS_K_HEADERS_BH okshdrh ;
184:
185: Cursor l_line_agg_csr1 IS
186: Select /*+ PARALLEL(oksline) */
187: min(oksline.id) minid,

Line 1235: from OKS_K_HEADERS_BH okshdr,

1231: SEC.sec_segment_id,
1232: SEC.cc_number_length,
1233: SEC.cc_unmask_digits,
1234: LPAD(sec.cc_unmask_digits, NVL(range.card_number_length, length(okshdr.cc_no)),'X')
1235: from OKS_K_HEADERS_BH okshdr,
1236: (select hz.party_id, hdr.authoring_org_id, hdr.id hdr_id, hz.cust_account_id,
1237: hdr.bill_to_site_use_id
1238: from okc_k_headers_all_b hdr, hz_cust_accounts_all hz,
1239: hz_cust_site_uses_all site, hz_cust_acct_sites_all acct

Line 1297: from oks_k_headers_bh okshdr,

1293: SUBSTR(okshdr.cc_no,GREATEST(-4,-LENGTH(okshdr.cc_no))) cc_unmask_digits,
1294: LPAD(SUBSTR(okshdr.cc_no, GREATEST(-4,-LENGTH(okshdr.cc_no))),
1295: LENGTH(okshdr.cc_no),
1296: 'X' ) masked_cc_number
1297: from oks_k_headers_bh okshdr,
1298: (select hz.party_id, hdr.authoring_org_id, hdr.id hdr_id, hz.cust_account_id,
1299: hdr.bill_to_site_use_id
1300: from okc_k_headers_all_b hdr, hz_cust_accounts_all hz,
1301: hz_cust_site_uses_all site, hz_cust_acct_sites_all acct

Line 1501: UPDATE oks_k_headers_bh

1497:
1498: -- update the foreign key relationship
1499:
1500: FORALL i in c_trxn_entity_id.first..c_trxn_entity_id.last
1501: UPDATE oks_k_headers_bh
1502: SET TRXN_EXTENSION_ID = c_trxn_entity_id(i)
1503: WHERE id = okshdr_id(i)
1504: AND major_version = oksline_major_version(i);
1505:

Line 1629: from OKS_K_HEADERS_B okshdr,

1625: SEC.sec_segment_id,
1626: SEC.cc_number_length,
1627: SEC.cc_unmask_digits,
1628: LPAD(sec.cc_unmask_digits, NVL(range.card_number_length, length(okshdr.cc_no)),'X')
1629: from OKS_K_HEADERS_B okshdr,
1630: (select hz.party_id, hdr.authoring_org_id, hdr.id hdr_id, hz.cust_account_id,
1631: hdr.bill_to_site_use_id
1632: from okc_k_headers_all_b hdr, hz_cust_accounts_all hz,
1633: hz_cust_site_uses_all site, hz_cust_acct_sites_all acct

Line 1690: from oks_k_headers_b okshdr,

1686: SUBSTR(okshdr.cc_no,GREATEST(-4,-LENGTH(okshdr.cc_no))) cc_unmask_digits,
1687: LPAD(SUBSTR(okshdr.cc_no, GREATEST(-4,-LENGTH(okshdr.cc_no))),
1688: LENGTH(okshdr.cc_no),
1689: 'X' ) masked_cc_number
1690: from oks_k_headers_b okshdr,
1691: (select hz.party_id, hdr.authoring_org_id, hdr.id hdr_id, hz.cust_account_id,
1692: hdr.bill_to_site_use_id
1693: from okc_k_headers_all_b hdr, hz_cust_accounts_all hz,
1694: hz_cust_site_uses_all site, hz_cust_acct_sites_all acct

Line 1977: oks_k_headers_b okh,

1973: hz_cust_accounts b
1974: WHERE a.party_id = b.party_id
1975: AND b.cust_account_id = cust_acct_id) party_name
1976: FROM oks_rule_error ore,
1977: oks_k_headers_b okh,
1978: okc_k_headers_all_b kh,
1979: okc_statuses_v st
1980: WHERE ore.RULE_INFORMATION_CATEGORY = 'R12CC'
1981: AND ore.chr_id = kh.ID

Line 2647: FROM oks_k_headers_b okshdr

2643: FROM
2644: (SELECT /*+ no_merge parallel(khdr) */ ID, FLOOR((ROWNUM-1)/l_bucket_size) Worker_Bucket
2645: FROM
2646: ( SELECT id
2647: FROM oks_k_headers_b okshdr
2648: WHERE ((okshdr.cc_no IS NOT NULL
2649: AND okshdr.payment_type = 'CCR'
2650: AND okshdr.trxn_extension_id is not null)
2651: OR

Line 2670: , Oks_k_headers_b Kh

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'
2673: And rl.rule_information1 is not null
2674: And ((rg.chr_id = Kh.chr_id

Line 2716: From OKS_K_HEADERS_BH okshdrh ;

2712: max(okshdrh.id) maxid,
2713: avg(okshdrh.id) avgid,
2714: stddev(okshdrh.id) stdid,
2715: count(*) total
2716: From OKS_K_HEADERS_BH okshdrh ;
2717:
2718: Cursor l_line_hist_agg_csr IS
2719: Select /*+ PARALLEL(okslineh) */
2720: min(okslineh.id) minid,

Line 2919: From oks_k_headers_bh

2915:
2916:
2917: Cursor l_hdr_hist_csr Is
2918: Select id, chr_id
2919: From oks_k_headers_bh
2920: Where cc_no is not null
2921: And trxn_extension_id is not null
2922: And id between p_id_low and p_id_high;
2923:

Line 2940: Update Oks_k_headers_bh

2936:
2937: -- Update Header history table
2938:
2939: Forall i in l_hdr_id.first..l_hdr_id.last
2940: Update Oks_k_headers_bh
2941: Set cc_no = null,
2942: cc_bank_acct_id = null,
2943: cc_expiry_date = null,
2944: cc_auth_code = null

Line 2974: From oks_k_headers_b

2970:
2971:
2972: Cursor l_hdr_csr Is
2973: Select id, chr_id
2974: From oks_k_headers_b
2975: Where cc_no is not null
2976: And trxn_extension_id is not null
2977: And id between p_id_low and p_id_high;
2978:

Line 2995: Update Oks_k_headers_b

2991:
2992: -- Update Header table
2993:
2994: Forall i in l_hdr_id.first..l_hdr_id.last
2995: Update Oks_k_headers_b
2996: Set cc_no = null,
2997: cc_bank_acct_id = null,
2998: cc_expiry_date = null,
2999: cc_auth_code = null

Line 3031: , Oks_k_headers_b Kh

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'
3034: And rl.rule_information1 is not null
3035: And ((rg.chr_id = Kh.chr_id