[Home] [Help]
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;
604: l_cust_bank_account_id ra_customer_trx.customer_bank_account_id%type;
605: l_cust_bank_account_name ap_bank_accounts.bank_account_name%type;
606: l_cust_bank_account_number ap_bank_accounts.bank_account_num%type;
607: l_agreement_id ra_customer_trx.agreement_id%type;
604: l_cust_bank_account_id ra_customer_trx.customer_bank_account_id%type;
605: l_cust_bank_account_name ap_bank_accounts.bank_account_name%type;
606: l_cust_bank_account_number ap_bank_accounts.bank_account_num%type;
607: l_agreement_id ra_customer_trx.agreement_id%type;
608: l_fin_payment_method_name ar_receipt_methods.name%type;
609: l_fin_receipt_method_id ra_customer_trx.receipt_method_id%type;
610: l_fin_creation_method_code ar_receipt_classes.creation_method_code%type;
611: l_fin_bank_account_num ap_bank_accounts.bank_account_num%type;
612: l_fin_bank_name ce_bank_branches_v.bank_name%type;
2140: l_msg_count NUMBER;
2141: l_msg_data VARCHAR2(2000);
2142:
2143:
2144: l_payment_channel ar_receipt_methods.payment_channel_code%type;
2145: l_customer_id ra_customer_trx.paying_customer_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;
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
2184: AND hca.cust_account_id = trx.paying_customer_id
2185: AND trx.receipt_method_id = rm.receipt_method_id(+) ;