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 OKC_K_HEADERS_ALL_B

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 1978: okc_k_headers_all_b kh,

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,
1978: okc_k_headers_all_b kh,
1979: okc_statuses_v st
1980: WHERE ore.RULE_INFORMATION_CATEGORY = 'R12CC'
1981: AND ore.chr_id = kh.ID
1982: AND ore.cle_id IS NULL

Line 2003: okc_k_headers_all_bh kh,

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,
2004: okc_statuses_v st
2005: WHERE ore.RULE_INFORMATION_CATEGORY = 'R12CC'
2006: AND ore.chr_id = kh.ID
2007: AND ore.cle_id IS NULL

Line 2039: okc_k_headers_all_b kh,

2035: AND B.INVENTORY_ITEM_ID = object1_id1
2036: AND ROWNUM < 2) service_name
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

Line 2082: okc_k_headers_all_b kh,

2078: AND B.INVENTORY_ITEM_ID = object1_id1
2079: AND ROWNUM < 2) service_name
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'