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_IREC_PAYMENTS dependencies on CE_BANK_ACCT_USES

Line 534: ce_bank_acct_uses_ou_v aba,

530: arc.creation_status receipt_creation_status
531: FROM ar_receipt_methods arm,
532: ra_cust_receipt_methods rcrm,
533: ar_receipt_method_accounts arma,
534: ce_bank_acct_uses_ou_v aba,
535: ce_bank_accounts cba,
536: ar_receipt_classes arc
537: WHERE arm.receipt_method_id = rcrm.receipt_method_id
538: AND arm.receipt_method_id = arma.receipt_method_id

Line 633: ce_bank_acct_uses_ou_v aba,

629: arm.payment_channel_code payment_channel_code,
630: arc.creation_status receipt_creation_status
631: FROM ar_receipt_methods arm,
632: ar_receipt_method_accounts arma,
633: ce_bank_acct_uses_ou_v aba,
634: ce_bank_accounts cba,
635: ar_receipt_classes arc
636: WHERE arm.payment_channel_code = 'CREDIT_CARD'
637: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_CC_PMT_METHOD')), arm.receipt_method_id)

Line 654: ce_bank_acct_uses_ou_v aba,

650: arm.payment_channel_code payment_channel_code,
651: arc.creation_status receipt_creation_status
652: FROM ar_receipt_methods arm,
653: ar_receipt_method_accounts arma,
654: ce_bank_acct_uses_ou_v aba,
655: ce_bank_accounts cba,
656: ar_receipt_classes arc
657: WHERE NVL(arm.payment_channel_code,'NONE') <> 'CREDIT_CARD'
658: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_BA_PMT_METHOD')), arm.receipt_method_id)

Line 4999: ce_bank_acct_uses bau,

4995:
4996: BEGIN
4997: select pr.home_country into l_home_country
4998: from ar_cash_receipts_all cr,
4999: ce_bank_acct_uses bau,
5000: ce_bank_accounts cba,
5001: hz_parties bank,
5002: hz_organization_profiles pr
5003: where cr.cash_receipt_id = p_cash_receipt_id

Line 5875: ce_bank_acct_uses_ou_v aba,

5871: SELECT arm.receipt_method_id receipt_method_id,
5872: arc.creation_status receipt_creation_status
5873: FROM ar_receipt_methods arm,
5874: ar_receipt_method_accounts arma,
5875: ce_bank_acct_uses_ou_v aba,
5876: ce_bank_accounts cba,
5877: ar_receipt_classes arc
5878: WHERE arm.payment_channel_code = 'CREDIT_CARD'
5879: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_CC_PMT_METHOD')), arm.receipt_method_id)

Line 5948: ce_bank_acct_uses_ou_v ba,

5944: FROM ar_system_parameters sp,
5945: ar_receipt_methods rm,
5946: ar_receipt_method_accounts rma,
5947: ce_bank_accounts cba,
5948: ce_bank_acct_uses_ou_v ba,
5949: ar_receipt_classes rc
5950: WHERE sp.irec_cc_receipt_method_id = rm.receipt_method_id
5951: AND rma.receipt_method_id = rm.receipt_method_id
5952: AND rma.remit_bank_acct_use_id = ba.bank_acct_use_id

Line 5976: ce_bank_acct_uses_ou_v aba,

5972: INTO customer_cc_payment_method
5973: FROM ar_receipt_methods arm,
5974: ra_cust_receipt_methods rcrm,
5975: ar_receipt_method_accounts arma,
5976: ce_bank_acct_uses_ou_v aba,
5977: ce_bank_accounts cba,
5978: ar_receipt_classes arc
5979: WHERE arm.receipt_method_id = rcrm.receipt_method_id
5980: AND arm.receipt_method_id = arma.receipt_method_id

Line 6064: ce_bank_acct_uses_ou_v aba,

6060: SELECT arm.receipt_method_id receipt_method_id,
6061: arc.creation_status receipt_creation_status
6062: FROM ar_receipt_methods arm,
6063: ar_receipt_method_accounts arma,
6064: ce_bank_acct_uses_ou_v aba,
6065: ce_bank_accounts cba,
6066: ar_receipt_classes arc
6067: WHERE NVL(arm.payment_channel_code,'NONE') <> 'CREDIT_CARD'
6068: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_BA_PMT_METHOD')), arm.receipt_method_id)

Line 6134: ce_bank_acct_uses_ou_v ba,

6130: INTO system_bank_payment_method
6131: FROM ar_system_parameters sp,
6132: ar_receipt_methods rm,
6133: ar_receipt_method_accounts rma,
6134: ce_bank_acct_uses_ou_v ba,
6135: ce_bank_accounts cba
6136: WHERE sp.irec_ba_receipt_method_id = rm.receipt_method_id
6137: AND rma.receipt_method_id = rm.receipt_method_id
6138: AND rma.remit_bank_acct_use_id = ba.bank_acct_use_id

Line 6153: ce_bank_acct_uses_ou_v aba,

6149: INTO customer_bank_payment_method
6150: FROM ar_receipt_methods arm,
6151: ra_cust_receipt_methods rcrm,
6152: ar_receipt_method_accounts arma,
6153: ce_bank_acct_uses_ou_v aba,
6154: ce_bank_accounts cba,
6155: ar_receipt_classes arc
6156: WHERE arm.receipt_method_id = rcrm.receipt_method_id
6157: AND arm.receipt_method_id = arma.receipt_method_id