[Home] [Help]
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:
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' );
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 );
347: WHERE gt.receipt_method_id IS NOT NULL
348: AND gt.payment_trxn_extension_id IS NULL
349: AND EXISTS
350: (SELECT 'X'
351: FROM ar_receipt_methods rm,
352: ar_receipt_classes rc
353: WHERE rm.receipt_method_id = gt.receipt_method_id
354: AND rm.receipt_class_id = rc.receipt_class_id
355: AND rc.creation_method_code = 'AUTOMATIC' );
1098: FROM ar_trx_header_gt gt
1099: WHERE gt.customer_bank_account_id IS NOT NULL
1100: AND NOT EXISTS (
1101: SELECT 'X'
1102: FROM ar_receipt_methods rm,
1103: ar_receipt_classes rc
1104: WHERE rm.receipt_class_id = rc.receipt_class_id
1105: AND rm.receipt_method_id = gt.receipt_method_id
1106: AND rc.creation_method_code = 'AUTOMATIC');
6132: payment_trxn_extension_id
6133: FROM ar_trx_header_gt
6134: WHERE receipt_method_id IS NULL;
6135: --AND payment_trxn_extension_id IS NOT NULL;
6136: l_receipt_method_name ar_receipt_methods.name%type;
6137: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;
6138: l_creation_method_code ar_receipt_classes.creation_method_code%type;
6139: l_bank_account_id ce_bank_accounts.bank_account_id%type;
6140: l_bank_account_num ce_bank_accounts.bank_account_num%type;
6133: FROM ar_trx_header_gt
6134: WHERE receipt_method_id IS NULL;
6135: --AND payment_trxn_extension_id IS NOT NULL;
6136: l_receipt_method_name ar_receipt_methods.name%type;
6137: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;
6138: l_creation_method_code ar_receipt_classes.creation_method_code%type;
6139: l_bank_account_id ce_bank_accounts.bank_account_id%type;
6140: l_bank_account_num ce_bank_accounts.bank_account_num%type;
6141: l_bank_name ce_bank_branches_v.bank_name%type;
6199: FROM ar_trx_header_gt
6200: WHERE receipt_method_id IS NULL
6201: AND payment_trxn_extension_id IS NULL;
6202:
6203: l_receipt_method_name ar_receipt_methods.name%type;
6204: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;
6205: l_creation_method_code ar_receipt_classes.creation_method_code%type;
6206: l_bank_account_id ce_bank_accounts.bank_account_id%type;
6207: l_bank_account_num ce_bank_accounts.bank_account_num%type;
6200: WHERE receipt_method_id IS NULL
6201: AND payment_trxn_extension_id IS NULL;
6202:
6203: l_receipt_method_name ar_receipt_methods.name%type;
6204: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;
6205: l_creation_method_code ar_receipt_classes.creation_method_code%type;
6206: l_bank_account_id ce_bank_accounts.bank_account_id%type;
6207: l_bank_account_num ce_bank_accounts.bank_account_num%type;
6208: l_bank_name ce_bank_branches_v.bank_name%type;
6265:
6266: SELECT payment_channel_code,decode(payment_channel_code,'BANK_ACCT_XFER','BANKACCOUNT',
6267: 'BILLS_RECEIVABLE','BANKACCOUNT','CREDIT_CARD','CREDITCARD','BANKACCOUNT')
6268: INTO l_payment_channel_code,l_instrument_type
6269: FROM ar_receipt_methods
6270: WHERE receipt_method_id = l_receipt_method_id;
6271:
6272:
6273: arp_trx_defaults_3.get_instr_defaults(