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

Line 1685: from hz_cust_site_uses_all where site_use_id=

1681: AND Address_Id = AddressId;
1682:
1683: CURSOR Fetch_OE_Address_Cur IS
1684: SELECT cust_acct_site_id address_id
1685: from hz_cust_site_uses_all where site_use_id=
1686: (select SHIP_TO_LOCATION_ID
1687: FROM wsh_delivery_details
1688: WHERE delivery_detail_id = p_ref_line_id);
1689:

Line 1692: FROM hz_cust_site_uses_all where site_use_id in

1688: WHERE delivery_detail_id = p_ref_line_id);
1689:
1690: CURSOR Fetch_AR_Address_Cur IS
1691: SELECT cust_acct_site_id address_id
1692: FROM hz_cust_site_uses_all where site_use_id in
1693: (select ship_to_site_use_id from RA_Customer_Trx_All
1694: WHERE Customer_trx_Id in (select customer_trx_id from
1695: ra_customer_trx_lines_all where customer_trx_line_id = p_ref_line_id));
1696: