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

Line 564: l_bill_to_customer_number hz_cust_accounts.account_number%type;

560: l_new_customer_trx_id ra_customer_trx.customer_trx_id%type;
561: l_new_rowid varchar(18);
562: l_bill_to_customer_id ra_customer_trx.bill_to_customer_id%type;
563: l_bill_to_customer_name hz_parties.party_name%type;
564: l_bill_to_customer_number hz_cust_accounts.account_number%type;
565: l_bill_to_location hz_cust_site_uses.location%type;
566: l_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;
567: l_bill_to_contact_id ra_customer_trx.bill_to_contact_id%type;
568: l_bill_to_contact_first_name hz_parties.person_first_name%type;

Line 572: l_ship_to_customer_number hz_cust_accounts.account_number%type;

568: l_bill_to_contact_first_name hz_parties.person_first_name%type;
569: l_bill_to_contact_last_name hz_parties.person_last_name%type;
570: l_ship_to_customer_id ra_customer_trx.ship_to_customer_id%type;
571: l_ship_to_customer_name hz_parties.party_name%type;
572: l_ship_to_customer_number hz_cust_accounts.account_number%type;
573: l_ship_to_location hz_cust_site_uses.location%type;
574: l_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;
575: l_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;
576: l_ship_to_contact_first_name hz_parties.person_first_name%type;

Line 594: l_sold_to_customer_number hz_cust_accounts.account_number%type;

590: l_remit_to_address_id ra_customer_trx.remit_to_address_id%type;
591: l_cust_location_site_num hz_cust_acct_sites.cust_acct_site_id%type;
592: l_sold_to_customer_id ra_customer_trx.bill_to_customer_id%type;
593: l_sold_to_customer_name hz_parties.party_name%type;
594: l_sold_to_customer_number hz_cust_accounts.account_number%type;
595: l_start_date_commitmenmt DATE;
596: l_end_date_commitmenmt DATE;
597: l_paying_customer_id ra_customer_trx.ship_to_customer_id%type;
598: l_paying_customer_name hz_parties.party_name%type;

Line 599: l_paying_customer_number hz_cust_accounts.account_number%type;

595: l_start_date_commitmenmt DATE;
596: l_end_date_commitmenmt DATE;
597: l_paying_customer_id ra_customer_trx.ship_to_customer_id%type;
598: l_paying_customer_name hz_parties.party_name%type;
599: l_paying_customer_number hz_cust_accounts.account_number%type;
600: l_paying_location hz_cust_site_uses.location%type;
601: l_paying_site_use_id ra_customer_trx.ship_to_site_use_id%type;
602: l_receipt_method_id ra_customer_trx.receipt_method_id%type;
603: l_receipt_method_name ar_receipt_methods.name%type;

Line 2178: FROM hz_cust_accounts hca,

2174: l_party_id,
2175: l_trx_number,
2176: l_payment_channel,
2177: l_customer_trx_id
2178: FROM hz_cust_accounts hca,
2179: hz_parties party,
2180: ra_customer_trx trx,
2181: ar_receipt_methods rm
2182: WHERE trx.customer_trx_id = p_customer_trx_id