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 HZ_CUST_ACCOUNTS_ALL

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 1238: from okc_k_headers_all_b hdr, hz_cust_accounts_all hz,

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
1240: where hdr.bill_to_site_use_id = site.site_use_id
1241: and site.cust_acct_site_id = acct.cust_acct_site_id
1242: and acct.cust_account_id = hz.cust_account_id

Line 1300: from okc_k_headers_all_b hdr, hz_cust_accounts_all hz,

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
1302: where hdr.bill_to_site_use_id = site.site_use_id
1303: and site.cust_acct_site_id = acct.cust_acct_site_id
1304: and acct.cust_account_id = hz.cust_account_id

Line 1632: from okc_k_headers_all_b hdr, hz_cust_accounts_all hz,

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
1634: where hdr.bill_to_site_use_id = site.site_use_id
1635: and site.cust_acct_site_id = acct.cust_acct_site_id
1636: and acct.cust_account_id = hz.cust_account_id

Line 1693: from okc_k_headers_all_b hdr, hz_cust_accounts_all hz,

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
1695: where hdr.bill_to_site_use_id = site.site_use_id
1696: and site.cust_acct_site_id = acct.cust_acct_site_id
1697: and acct.cust_account_id = hz.cust_account_id