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_SITE_USES_ALL

Line 1239: hz_cust_site_uses_all site, hz_cust_acct_sites_all acct

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
1243: and site.site_use_code = 'BILL_TO' ) IV,

Line 1301: hz_cust_site_uses_all site, hz_cust_acct_sites_all acct

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
1305: and site.site_use_code = 'BILL_TO') IV,

Line 1633: hz_cust_site_uses_all site, hz_cust_acct_sites_all acct

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
1637: and site.site_use_code = 'BILL_TO') IV,

Line 1694: hz_cust_site_uses_all site, hz_cust_acct_sites_all acct

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
1698: and site.site_use_code = 'BILL_TO') IV,