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_PARTIES

Line 563: l_bill_to_customer_name hz_parties.party_name%type;

559: l_new_trx_number ra_customer_trx.trx_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;

Line 568: l_bill_to_contact_first_name hz_parties.person_first_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;
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;

Line 569: l_bill_to_contact_last_name hz_parties.person_last_name%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;
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;

Line 571: l_ship_to_customer_name hz_parties.party_name%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;
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;

Line 576: l_ship_to_contact_first_name hz_parties.person_first_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;
577: l_ship_to_contact_last_name hz_parties.person_last_name%type;
578: l_usr_currency_code ra_customer_trx.invoice_currency_code%type;
579: l_usr_exchange_rate_type ra_customer_trx.exchange_rate_type%type;
580: l_currency_code ra_customer_trx.invoice_currency_code%type;

Line 577: l_ship_to_contact_last_name hz_parties.person_last_name%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;
577: l_ship_to_contact_last_name hz_parties.person_last_name%type;
578: l_usr_currency_code ra_customer_trx.invoice_currency_code%type;
579: l_usr_exchange_rate_type ra_customer_trx.exchange_rate_type%type;
580: l_currency_code ra_customer_trx.invoice_currency_code%type;
581: l_exchange_rate_type ra_customer_trx.exchange_rate_type%type;

Line 593: l_sold_to_customer_name hz_parties.party_name%type;

589: l_gl_date Date;
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;

Line 598: l_paying_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;
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;

Line 2150: l_party_id hz_parties.party_id%type;

2146: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;
2147: l_org_id ra_customer_trx.org_id%type;
2148: l_trx_number ra_customer_trx.trx_number%type;
2149: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
2150: l_party_id hz_parties.party_id%type;
2151:
2152:
2153: BEGIN
2154:

Line 2179: hz_parties party,

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
2183: AND hca.party_id = party.party_id