APPS.OKS_CCMIGRATE_PVT dependencies on OKC_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 458: from okc_k_lines_b line, okc_k_headers_all_b hdr, hz_cust_accounts_all hz

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
460: and line.lse_id in (1,12,19,46)
461: and hz.cust_account_id = line.cust_acct_id) IV,
462: IBY_EXTERNAL_PAYERS_ALL payer,

Line 519: from okc_k_lines_b line, okc_k_headers_all_b hdr, hz_cust_accounts_all hz

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
521: and line.lse_id in (1,12,19,46)
522: and hz.cust_account_id = line.cust_acct_id) IV,
523: IBY_EXTERNAL_PAYERS_ALL payer

Line 848: from okc_k_lines_b line, okc_k_headers_all_b hdr, hz_cust_accounts_all hz

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
850: and line.lse_id in (1,12,19,46)
851: and hz.cust_account_id = line.cust_acct_id) IV,
852: IBY_EXTERNAL_PAYERS_ALL payer,

Line 908: from okc_k_lines_b line, okc_k_headers_all_b hdr, hz_cust_accounts_all hz

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
910: and line.lse_id in (1,12,19,46)
911: and hz.cust_account_id = line.cust_acct_id) IV,
912: IBY_EXTERNAL_PAYERS_ALL payer

Line 2042: okc_k_lines_b lc,

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
2046: AND ore.CHR_id = ls.DNZ_CHR_ID

Line 2084: okc_k_lines_bh lc,

2080:
2081: FROM oks_rule_error ore,
2082: okc_k_headers_all_b kh,
2083: okc_statuses_v st,
2084: okc_k_lines_bh lc,
2085: okc_k_items it
2086: WHERE ore.RULE_INFORMATION_CATEGORY = 'R12CC'
2087: AND ore.cle_id = lc.id
2088: AND kh.id = lc.dnz_chr_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'