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_OM_RG_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 1885: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for Bug# 4434287

1881: SELECT excise_duty_range,excise_duty_division
1882: FROM JAI_CMN_CUS_ADDRESSES
1883: WHERE customer_id = p_customer_id
1884: AND address_id = (SELECT cust_acct_site_id -- address_id
1885: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for Bug# 4434287
1886: WHERE A.site_use_id = p_customer_site_id);
1887:
1888: /***added by Jagdish and vijay on */
1889: CURSOR rg_manufactured_loose_cur IS

Line 2461: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for BUg# 4434287

2457: SELECT excise_duty_range,excise_duty_division
2458: FROM JAI_CMN_CUS_ADDRESSES
2459: WHERE customer_id = p_customer_id
2460: AND address_id = (SELECT cust_acct_site_id -- address_id
2461: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for BUg# 4434287
2462: WHERE A.site_use_id = p_customer_site_id);
2463: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_rg23_part_I_entry';
2464: BEGIN
2465:

Line 2622: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for Bug# 4434287

2618: SELECT excise_duty_range, excise_duty_division
2619: FROM JAI_CMN_CUS_ADDRESSES
2620: WHERE customer_id = p_customer_id
2621: AND address_id = (SELECT cust_acct_site_id -- address_id
2622: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for Bug# 4434287
2623: WHERE A.site_use_id = p_customer_site_id);
2624: CURSOR rm_account_cur IS
2625: SELECT modvat_rm_account_id , excise_edu_cess_rm_account ,SH_CESS_RM_ACCOUNT/*Bug 5989740 bduvarag*/
2626: FROM JAI_CMN_INVENTORY_ORGS

Line 3102: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for Bug# 4434287

3098: SELECT excise_duty_range, excise_duty_division
3099: FROM JAI_CMN_CUS_ADDRESSES
3100: WHERE customer_id = p_customer_id
3101: AND address_id = (SELECT cust_acct_site_id -- address_id
3102: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for Bug# 4434287
3103: WHERE A.site_use_id = p_customer_site_id);
3104:
3105: CURSOR serial_no_cur IS
3106: SELECT NVL(MAX(slno),0) , NVL(MAX(slno),0) + 1