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.JAI_CREDIT_CHECK_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 59: hz_cust_acct_sites_all,

55: CURSOR chk_credit_check_site
56: IS
57: select HZ_CUSTOMER_PROFILES.credit_checking
58: from HZ_CUST_SITE_USES_all,
59: hz_cust_acct_sites_all,
60: HZ_CUSTOMER_PROFILES
61: where hz_cust_acct_sites_all.cust_acct_site_id = HZ_CUST_SITE_USES_all.cust_acct_site_id
62: and hz_cust_acct_sites_all.cust_account_id = pn_cust_account_id
63: and HZ_CUST_SITE_USES_all.site_use_code = 'BILL_TO'

Line 61: where hz_cust_acct_sites_all.cust_acct_site_id = HZ_CUST_SITE_USES_all.cust_acct_site_id

57: select HZ_CUSTOMER_PROFILES.credit_checking
58: from HZ_CUST_SITE_USES_all,
59: hz_cust_acct_sites_all,
60: HZ_CUSTOMER_PROFILES
61: where hz_cust_acct_sites_all.cust_acct_site_id = HZ_CUST_SITE_USES_all.cust_acct_site_id
62: and hz_cust_acct_sites_all.cust_account_id = pn_cust_account_id
63: and HZ_CUST_SITE_USES_all.site_use_code = 'BILL_TO'
64: and HZ_CUST_SITE_USES_all.site_use_id = HZ_CUSTOMER_PROFILES.site_use_id
65: and HZ_CUST_SITE_USES_all.site_use_id = pn_site_use_id;

Line 62: and hz_cust_acct_sites_all.cust_account_id = pn_cust_account_id

58: from HZ_CUST_SITE_USES_all,
59: hz_cust_acct_sites_all,
60: HZ_CUSTOMER_PROFILES
61: where hz_cust_acct_sites_all.cust_acct_site_id = HZ_CUST_SITE_USES_all.cust_acct_site_id
62: and hz_cust_acct_sites_all.cust_account_id = pn_cust_account_id
63: and HZ_CUST_SITE_USES_all.site_use_code = 'BILL_TO'
64: and HZ_CUST_SITE_USES_all.site_use_id = HZ_CUSTOMER_PROFILES.site_use_id
65: and HZ_CUST_SITE_USES_all.site_use_id = pn_site_use_id;
66: