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 556: -- The view oe_invoice_to_orgs_v selects HZ_CUST_SITE_USES_ALL.CUST_ACCOUNT_ID

552: END IF;
553:
554: -- Bug 4597298
555: -- Remove reference to RA_CUSTOMERS, which have been obsoleted for R12
556: -- The view oe_invoice_to_orgs_v selects HZ_CUST_SITE_USES_ALL.CUST_ACCOUNT_ID
557: -- as customer_id, and HZ_CUST_SITE_USES_ALL.CUST_ACCOUNT_ID is just a foreign
558: -- key to HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID. So it should be safe to just
559: -- remove the join with RA_CUSTOMERS, since the replacement object for getting
560: -- the CUSTOMER_ID of RA_CUSTOMERS is HZ_CUST_ACCOUNTS.

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

553:
554: -- Bug 4597298
555: -- Remove reference to RA_CUSTOMERS, which have been obsoleted for R12
556: -- The view oe_invoice_to_orgs_v selects HZ_CUST_SITE_USES_ALL.CUST_ACCOUNT_ID
557: -- as customer_id, and HZ_CUST_SITE_USES_ALL.CUST_ACCOUNT_ID is just a foreign
558: -- key to HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID. So it should be safe to just
559: -- remove the join with RA_CUSTOMERS, since the replacement object for getting
560: -- the CUSTOMER_ID of RA_CUSTOMERS is HZ_CUST_ACCOUNTS.
561:

Line 571: FROM hz_cust_site_uses_all site,

567: -- exception being thrown if there exists any inactive sites.
568:
569: SELECT site.site_use_id
570: INTO l_header_rec.invoice_to_org_id
571: FROM hz_cust_site_uses_all site,
572: hz_cust_acct_sites_all acct_site
573: WHERE site.cust_acct_site_id = acct_site.cust_acct_site_id
574: AND site.site_use_code = 'BILL_TO'
575: AND site.org_id = acct_site.org_id