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 1804: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for Bug# 4434287

1800: SELECT excise_duty_range,excise_duty_division
1801: FROM JAI_CMN_CUS_ADDRESSES
1802: WHERE customer_id = p_customer_id
1803: AND address_id = (SELECT cust_acct_site_id -- address_id
1804: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for Bug# 4434287
1805: WHERE A.site_use_id = p_customer_site_id);
1806:
1807: /***added by Jagdish and vijay on */
1808: CURSOR rg_manufactured_loose_cur IS

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

2298: SELECT excise_duty_range,excise_duty_division
2299: FROM JAI_CMN_CUS_ADDRESSES
2300: WHERE customer_id = p_customer_id
2301: AND address_id = (SELECT cust_acct_site_id -- address_id
2302: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for BUg# 4434287
2303: WHERE A.site_use_id = p_customer_site_id);
2304: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_rg23_part_I_entry';
2305: BEGIN
2306:

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

2453: SELECT excise_duty_range, excise_duty_division
2454: FROM JAI_CMN_CUS_ADDRESSES
2455: WHERE customer_id = p_customer_id
2456: AND address_id = (SELECT cust_acct_site_id -- address_id
2457: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for Bug# 4434287
2458: WHERE A.site_use_id = p_customer_site_id);
2459: CURSOR rm_account_cur IS
2460: SELECT modvat_rm_account_id , excise_edu_cess_rm_account ,SH_CESS_RM_ACCOUNT/*Bug 5989740 bduvarag*/
2461: FROM JAI_CMN_INVENTORY_ORGS

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

2866: SELECT excise_duty_range, excise_duty_division
2867: FROM JAI_CMN_CUS_ADDRESSES
2868: WHERE customer_id = p_customer_id
2869: AND address_id = (SELECT cust_acct_site_id -- address_id
2870: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for Bug# 4434287
2871: WHERE A.site_use_id = p_customer_site_id);
2872:
2873: CURSOR serial_no_cur IS
2874: SELECT NVL(MAX(slno),0) , NVL(MAX(slno),0) + 1