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.JMF_SHIKYU_ONT_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 576: -- The view oe_invoice_to_orgs_v selects HZ_CUST_SITE_USES_ALL.CUST_ACCOUNT_ID

572: lStmtNo := 60;
573:
574: -- Bug 4597298
575: -- Remove reference to RA_CUSTOMERS, which have been obsoleted for R12
576: -- The view oe_invoice_to_orgs_v selects HZ_CUST_SITE_USES_ALL.CUST_ACCOUNT_ID
577: -- as customer_id, and HZ_CUST_SITE_USES_ALL.CUST_ACCOUNT_ID is just a foreign
578: -- key to HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID. So it should be safe to just
579: -- remove the join with RA_CUSTOMERS, since the replacement object for getting
580: -- the CUSTOMER_ID of RA_CUSTOMERS is HZ_CUST_ACCOUNTS.

Line 577: -- as customer_id, and HZ_CUST_SITE_USES_ALL.CUST_ACCOUNT_ID is just a foreign

573:
574: -- Bug 4597298
575: -- Remove reference to RA_CUSTOMERS, which have been obsoleted for R12
576: -- The view oe_invoice_to_orgs_v selects HZ_CUST_SITE_USES_ALL.CUST_ACCOUNT_ID
577: -- as customer_id, and HZ_CUST_SITE_USES_ALL.CUST_ACCOUNT_ID is just a foreign
578: -- key to HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID. So it should be safe to just
579: -- remove the join with RA_CUSTOMERS, since the replacement object for getting
580: -- the CUSTOMER_ID of RA_CUSTOMERS is HZ_CUST_ACCOUNTS.
581:

Line 591: FROM hz_cust_site_uses_all site,

587: -- exception being thrown if there exists any inactive sites.
588:
589: SELECT site.site_use_id
590: INTO l_header_rec.invoice_to_org_id
591: FROM hz_cust_site_uses_all site,
592: hz_cust_acct_sites_all acct_site
593: WHERE site.cust_acct_site_id = acct_site.cust_acct_site_id
594: AND site.site_use_code = 'BILL_TO'
595: AND site.org_id = acct_site.org_id