APPS.AR_INVOICE_UTILS dependencies on AR_RECEIPT_METHODS

Line 287: FROM ar_receipt_methods rm

283: FROM ar_trx_header_gt gt
284: WHERE gt.receipt_method_id IS NOT NULL
285: AND NOT EXISTS
286: (SELECT 'X'
287: FROM ar_receipt_methods rm
288: WHERE rm.receipt_method_id = gt.receipt_method_id
289: AND gt.trx_date BETWEEN NVL(rm.start_date, gt.trx_date)
290: AND NVL(rm.end_date, gt.trx_date));
291:

Line 316: FROM ar_receipt_methods rm,

312: FROM ar_trx_header_gt gt
313: WHERE gt.payment_trxn_extension_id IS NOT NULL
314: AND EXISTS
315: (SELECT 'X'
316: FROM ar_receipt_methods rm,
317: ar_receipt_classes rc
318: WHERE rm.receipt_method_id = gt.receipt_method_id
319: AND rm.receipt_class_id = rc.receipt_class_id
320: AND rc.creation_method_code = 'MANUAL' );

Line 333: FROM ar_receipt_methods rm,

329: FROM ar_trx_header_gt gt
330: WHERE gt.payment_trxn_extension_id IS NOT NULL
331: AND EXISTS
332: (SELECT 'X'
333: FROM ar_receipt_methods rm,
334: iby_trxn_extensions_v iby
335: WHERE rm.receipt_method_id = gt.receipt_method_id
336: AND iby.trxn_extension_id= gt.payment_trxn_extension_id
337: AND iby.PAYMENT_CHANNEL_CODE <> rm.payment_channel_code );

Line 1095: FROM ar_receipt_methods rm,

1091: FROM ar_trx_header_gt gt
1092: WHERE gt.customer_bank_account_id IS NOT NULL
1093: AND NOT EXISTS (
1094: SELECT 'X'
1095: FROM ar_receipt_methods rm,
1096: ar_receipt_classes rc
1097: WHERE rm.receipt_class_id = rc.receipt_class_id
1098: AND rm.receipt_method_id = gt.receipt_method_id
1099: AND rc.creation_method_code = 'AUTOMATIC');

Line 6008: l_receipt_method_name ar_receipt_methods.name%type;

6004: bill_to_site_use_id, trx_date, trx_header_id
6005: FROM ar_trx_header_gt
6006: WHERE receipt_method_id IS NULL
6007: AND payment_trxn_extension_id IS NOT NULL;
6008: l_receipt_method_name ar_receipt_methods.name%type;
6009: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;
6010: l_creation_method_code ar_receipt_classes.creation_method_code%type;
6011: l_bank_account_id ce_bank_accounts.bank_account_id%type;
6012: l_bank_account_num ce_bank_accounts.bank_account_num%type;

Line 6009: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;

6005: FROM ar_trx_header_gt
6006: WHERE receipt_method_id IS NULL
6007: AND payment_trxn_extension_id IS NOT NULL;
6008: l_receipt_method_name ar_receipt_methods.name%type;
6009: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;
6010: l_creation_method_code ar_receipt_classes.creation_method_code%type;
6011: l_bank_account_id ce_bank_accounts.bank_account_id%type;
6012: l_bank_account_num ce_bank_accounts.bank_account_num%type;
6013: l_bank_name ce_bank_branches_v.bank_name%type;