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

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

Line 1973: hz_cust_accounts b

1969: ore.attribute_value cc_no,
1970: ore.cc_expiry_date cc_exp_date,
1971: (SELECT party_name
1972: FROM hz_parties a,
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,

Line 1999: hz_cust_accounts b

1995: ore.attribute_value cc_no,
1996: ore.cc_expiry_date cc_exp_date,
1997: (SELECT party_name
1998: FROM hz_parties a,
1999: hz_cust_accounts b
2000: WHERE a.party_id = b.party_id
2001: AND b.cust_account_id = cust_acct_id) party_name
2002: FROM oks_rule_error ore,
2003: okc_k_headers_all_bh kh,

Line 2025: hz_cust_accounts b

2021: ore.attribute_value cc_no,
2022: ore.cc_expiry_date cc_exp_date,
2023: (SELECT party_name
2024: FROM hz_parties a,
2025: hz_cust_accounts b
2026: WHERE a.party_id = b.party_id
2027: AND b.cust_account_id = lc.cust_acct_id) party_name,
2028: (SELECT decode(fnd_profile.value('OKS_ITEM_DISPLAY_PREFERENCE'),'DISPLAY_DESC',
2029: B.CONCATENATED_SEGMENTS ,T.DESCRIPTION )

Line 2068: hz_cust_accounts b

2064: ore.attribute_value cc_no,
2065: ore.cc_expiry_date cc_exp_date,
2066: (SELECT party_name
2067: FROM hz_parties a,
2068: hz_cust_accounts b
2069: WHERE a.party_id = b.party_id
2070: AND b.cust_account_id = lc.cust_acct_id) party_name,
2071: (SELECT decode(fnd_profile.value('OKS_ITEM_DISPLAY_PREFERENCE'),'DISPLAY_DESC',
2072: B.CONCATENATED_SEGMENTS ,T.DESCRIPTION )