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 OKS_K_LINES_B

Line 158: FROM oks_k_lines_b oksline, okc_k_lines_b okcline

154: FROM
155: (SELECT /*+ no_merge parallel(kln) */ ID, FLOOR((ROWNUM-1)/l_bucket_size) Worker_Bucket
156: FROM
157: ( SELECT oksline.id
158: FROM oks_k_lines_b oksline, okc_k_lines_b okcline
159: WHERE oksline.cle_id=okcline.id
160: and oksline.cc_no IS NOT NULL
161: AND oksline.payment_type = 'CCR'
162: AND oksline.trxn_extension_id is null

Line 192: From OKS_K_LINES_B oksline ;

188: max(oksline.id) maxid,
189: avg(oksline.id) avgid,
190: stddev(oksline.id) stdid,
191: count(*) total
192: From OKS_K_LINES_B oksline ;
193:
194: Cursor l_line_agg_csr2 IS
195: Select /*+ PARALLEL(okslineh) */
196: min(okslineh.id) minid,

Line 201: From OKS_K_LINES_BH okslineh ;

197: max(okslineh.id) maxid,
198: avg(okslineh.id) avgid,
199: stddev(okslineh.id) stdid,
200: count(*) total
201: From OKS_K_LINES_BH okslineh ;
202:
203: l_agg_rec l_line_agg_csr2%rowtype;
204: l_sub_requests number;
205: l_sub_req number;

Line 260: -- The following csr is on OKS_K_LINES_BH

256: END IF;
257:
258:
259:
260: -- The following csr is on OKS_K_LINES_BH
261: open l_line_agg_csr2;
262: fetch l_line_agg_csr2 into l_agg_rec;
263: close l_line_agg_csr2;
264:

Line 455: from OKS_K_LINES_BH oksline,

451: SEC.sec_segment_id,
452: SEC.cc_number_length,
453: SEC.cc_unmask_digits,
454: LPAD(sec.cc_unmask_digits, NVL(range.card_number_length, length(oksline.cc_no)),'X')
455: from OKS_K_LINES_BH oksline,
456: (select hz.party_id, hdr.authoring_org_id, hdr.id hdr_id, line.cust_acct_id,
457: line.bill_to_site_use_id, line.id line_id
458: from okc_k_lines_b line, okc_k_headers_all_b hdr, hz_cust_accounts_all hz
459: where line.dnz_chr_id = hdr.id

Line 516: from oks_k_lines_bh oksline,

512: SUBSTR(oksline.cc_no,GREATEST(-4,-LENGTH(oksline.cc_no))) cc_unmask_digits,
513: LPAD(SUBSTR(oksline.cc_no, GREATEST(-4,-LENGTH(oksline.cc_no))),
514: LENGTH(oksline.cc_no),
515: 'X' ) masked_cc_number
516: from oks_k_lines_bh oksline,
517: (select hz.party_id, hdr.authoring_org_id, hdr.id hdr_id, line.cust_acct_id,
518: line.bill_to_site_use_id, line.id line_id
519: from okc_k_lines_b line, okc_k_headers_all_b hdr, hz_cust_accounts_all hz
520: where line.dnz_chr_id = hdr.id

Line 717: UPDATE oks_k_lines_bh

713:
714: -- update the foreign key relationship
715:
716: FORALL i in c_trxn_entity_id.first..c_trxn_entity_id.last
717: UPDATE oks_k_lines_bh
718: SET TRXN_EXTENSION_ID = c_trxn_entity_id(i)
719: WHERE id = oksline_id(i)
720: AND major_version = oksline_major_version(i);
721:

Line 845: from OKS_K_LINES_B oksline,

841: SEC.sec_segment_id,
842: SEC.cc_number_length,
843: SEC.cc_unmask_digits,
844: LPAD(sec.cc_unmask_digits, NVL(range.card_number_length, length(oksline.cc_no)),'X')
845: from OKS_K_LINES_B oksline,
846: (select hz.party_id, hdr.authoring_org_id, hdr.id hdr_id, line.cust_acct_id,
847: line.bill_to_site_use_id, line.id line_id
848: from okc_k_lines_b line, okc_k_headers_all_b hdr, hz_cust_accounts_all hz
849: where line.dnz_chr_id = hdr.id

Line 905: from oks_k_lines_b oksline,

901: SUBSTR(oksline.cc_no,GREATEST(-4,-LENGTH(oksline.cc_no))) cc_unmask_digits,
902: LPAD(SUBSTR(oksline.cc_no, GREATEST(-4,-LENGTH(oksline.cc_no))),
903: LENGTH(oksline.cc_no),
904: 'X' ) masked_cc_number
905: from oks_k_lines_b oksline,
906: (select hz.party_id, hdr.authoring_org_id, hdr.id hdr_id, line.cust_acct_id,
907: line.bill_to_site_use_id, line.id line_id
908: from okc_k_lines_b line, okc_k_headers_all_b hdr, hz_cust_accounts_all hz
909: where line.dnz_chr_id = hdr.id

Line 1106: UPDATE oks_k_lines_b

1102:
1103: -- update the foreign key relationship
1104:
1105: FORALL i in c_trxn_entity_id.first..c_trxn_entity_id.last
1106: UPDATE oks_k_lines_b
1107: SET TRXN_EXTENSION_ID = c_trxn_entity_id(i)
1108: WHERE id = oksline_id(i);
1109:
1110: Exception

Line 1893: UPDATE oks_k_lines_b

1889:
1890: -- update the foreign key relationship
1891:
1892: FORALL i in c_trxn_entity_id.first..c_trxn_entity_id.last
1893: UPDATE oks_k_lines_b
1894: SET TRXN_EXTENSION_ID = c_trxn_entity_id(i)
1895: WHERE id = okshdr_id(i);
1896:
1897: Exception

Line 2041: oks_k_lines_b ls,

2037:
2038: FROM oks_rule_error ore,
2039: okc_k_headers_all_b kh,
2040: okc_statuses_v st,
2041: oks_k_lines_b ls,
2042: okc_k_lines_b lc,
2043: okc_k_items it
2044: WHERE ore.RULE_INFORMATION_CATEGORY = 'R12CC'
2045: AND ore.cle_id = ls.cle_ID

Line 2691: FROM oks_k_lines_b oksline, okc_k_lines_b okcline

2687: FROM
2688: (SELECT /*+ no_merge parallel(kln) */ ID, FLOOR((ROWNUM-1)/l_bucket_size) Worker_Bucket
2689: FROM
2690: ( SELECT oksline.id
2691: FROM oks_k_lines_b oksline, okc_k_lines_b okcline
2692: WHERE oksline.cle_id=okcline.id
2693: and okcline.lse_id in (1,12,19,46)
2694: and ((oksline.cc_no IS NOT NULL
2695: AND oksline.payment_type = 'CCR'

Line 2725: From OKS_K_LINES_BH okslineh ;

2721: max(okslineh.id) maxid,
2722: avg(okslineh.id) avgid,
2723: stddev(okslineh.id) stdid,
2724: count(*) total
2725: From OKS_K_LINES_BH okslineh ;
2726:
2727: l_agg_rec l_line_hist_agg_csr%rowtype;
2728: l_sub_requests number;
2729: l_sub_req number;

Line 2877: From oks_k_lines_bh ks

2873:
2874:
2875: Cursor l_line_hist_csr Is
2876: Select Ks.id
2877: From oks_k_lines_bh ks
2878: where Ks.cc_no is not null
2879: And Ks.trxn_extension_id is not null
2880: And Ks.id between p_id_low and p_id_high;
2881:

Line 2895: Update Oks_k_Lines_bh

2891:
2892: -- Update Line history table
2893:
2894: Forall i in l_line_id.first..l_line_id.last
2895: Update Oks_k_Lines_bh
2896: Set cc_no = null,
2897: cc_bank_acct_id = null,
2898: cc_expiry_date = null,
2899: cc_auth_code = null

Line 3079: From oks_k_lines_b ks

3075:
3076:
3077: Cursor l_line_csr Is
3078: Select Ks.id
3079: From oks_k_lines_b ks
3080: Where Ks.cc_no is not null
3081: And Ks.trxn_extension_id is not null
3082: And Ks.id between p_id_low and p_id_high;
3083:

Line 3098: Update Oks_k_Lines_b

3094:
3095: -- Update Line table
3096:
3097: Forall i in l_line_id.first..l_line_id.last
3098: Update Oks_k_Lines_b
3099: Set cc_no = null,
3100: cc_bank_acct_id = null,
3101: cc_expiry_date = null,
3102: cc_auth_code = null