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.ARP_REVERSE_RECEIPT dependencies on HZ_CUST_ACCOUNTS

Line 1657: CURSOR bill_to_customer_C( l_customer_id hz_cust_accounts.cust_account_id%TYPE,

1653: /* 08-SEP-1999 J Rautiainen BugFix for bug 976703
1654: * Cursor customer_C was split into two separate cursors for performance
1655: * reasons */
1656: -- Added 2nd i/p parameter to fix bug 1063133
1657: CURSOR bill_to_customer_C( l_customer_id hz_cust_accounts.cust_account_id%TYPE,
1658: l_site_use_id ar_cash_receipts.customer_site_use_id%TYPE ) IS
1659: SELECT su1.site_use_id site_use_id,
1660: su1.cust_acct_site_id address_id
1661: FROM hz_cust_site_uses su1,

Line 1671: CURSOR ship_to_customer_C( l_customer_id hz_cust_accounts.cust_account_id%TYPE ) IS

1667: AND su1.site_use_code in ('BILL_TO','DRAWEE')
1668: AND su1.site_use_id = nvl(l_site_use_id,su1.site_use_id)
1669: ORDER BY su1.primary_flag desc;
1670:
1671: CURSOR ship_to_customer_C( l_customer_id hz_cust_accounts.cust_account_id%TYPE ) IS
1672: SELECT DECODE( su2.site_use_id,
1673: NULL, NULL, add2.cust_account_id ) ship_to_customer_id,
1674: su2.site_use_id ship_to_site_use_id
1675: FROM hz_cust_site_uses su2,