APPS.OKS_CCMIGRATE_PVT dependencies on OKS_K_HEADERS_BH

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 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