APPS.AR_AUTOREM_API dependencies on AR_DISTRIBUTIONS

Line 1340: ar_distributions d

1336: /*ar_remit_gt g,*/
1337: ar_cash_receipt_history crh,
1338: ar_batches bat,
1339: ar_receipt_method_accounts rma,
1340: ar_distributions d
1341: WHERE cr.selected_remittance_batch_id = :b_batch_id
1342: AND cr.REMIT_BANK_ACCT_USE_ID = rma.REMIT_BANK_ACCT_USE_ID
1343: AND bat.batch_id = cr.selected_remittance_batch_id
1344: AND rm.receipt_method_id = cr.receipt_method_id

Line 1828: p_code_combination_id ar_distributions.code_combination_id%TYPE;

1824: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
1825: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1826: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
1827: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
1828: p_code_combination_id ar_distributions.code_combination_id%TYPE;
1829: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1830: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
1831: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;
1832: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;

Line 1967: ar_distributions d

1963: ar_receipt_methods rm,
1964: ar_batches bat,
1965: ar_receipt_method_accounts rma,
1966: ar_payment_schedules ps,
1967: ar_distributions d
1968: WHERE cr.selected_remittance_batch_id = :ab_batch_id
1969: AND cr.REMIT_BANK_ACCT_USE_ID = rma.REMIT_BANK_ACCT_USE_ID
1970: AND bat.batch_id = cr.selected_remittance_batch_id
1971: AND rm.receipt_method_id = cr.receipt_method_id

Line 2430: ins_dist1 := 'INSERT into ar_distributions

2426:
2427:
2428: /* the first update into ar_cash_receipt_history */
2429:
2430: ins_dist1 := 'INSERT into ar_distributions
2431: (line_id,
2432: source_id,
2433: source_table,
2434: source_type,

Line 2453: ar_distributions_s.nextval,

2449: last_updated_by,
2450: org_id,
2451: last_update_login)
2452: select
2453: ar_distributions_s.nextval,
2454: r.cash_receipt_history_id,
2455: ''CRH'',
2456: decode(:factor_flag,
2457: ''N'',decode(l.lookup_code,

Line 2609: p_code_combination_id ar_distributions.code_combination_id%TYPE;

2605: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
2606: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
2607: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
2608: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
2609: p_code_combination_id ar_distributions.code_combination_id%TYPE;
2610: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2611: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
2612: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;
2613: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;

Line 3202: ins_dist1 := 'INSERT into ar_distributions

3198:
3199:
3200: /* the first update into ar_cash_receipt_history */
3201:
3202: ins_dist1 := 'INSERT into ar_distributions
3203: (line_id,
3204: source_id,
3205: source_table,
3206: source_type,

Line 3225: ar_distributions_s.nextval,

3221: last_updated_by,
3222: org_id,
3223: last_update_login)
3224: select
3225: ar_distributions_s.nextval,
3226: r.cash_receipt_history_id,
3227: ''CRH'',
3228: decode(:factor_flag,
3229: ''N'',decode(l.lookup_code,

Line 6025: delete from ar_distributions

6021: IF PG_DEBUG in ('Y','C') THEN
6022: fnd_file.put_line(FND_FILE.LOG,' rows UPDATED CRH = ' || SQL%ROWCOUNT );
6023: END IF;
6024:
6025: delete from ar_distributions
6026: where source_table = 'CRH'
6027: and source_id in ( select crh.cash_receipt_history_id
6028: from ar_cash_receipt_history crh,
6029: ar_cash_receipts cr

Line 6128: ar_distributions dis

6124: AND xe.event_number > 0
6125: AND NOT EXISTS
6126: (SELECT 'x'
6127: FROM ar_receivable_applications ra,
6128: ar_distributions dis
6129: WHERE ra.cash_receipt_id = cr.cash_receipt_id
6130: AND dis.source_id = ra.receivable_application_id
6131: AND dis.source_table = 'RA'
6132: AND ra.posting_control_id = -3

Line 6137: ar_distributions dis

6133: AND ra.event_id = xe.event_id
6134: UNION
6135: SELECT 'x'
6136: FROM ar_cash_receipt_history crh,
6137: ar_distributions dis
6138: WHERE crh.cash_receipt_id = cr.cash_receipt_id
6139: AND dis.source_id = crh.cash_receipt_history_id
6140: AND dis.source_table = 'CRH'
6141: AND crh.posting_control_id = -3

Line 6146: ar_distributions dis

6142: AND crh.event_id = xe.event_id
6143: UNION
6144: SELECT 'x'
6145: FROM ar_misc_cash_distributions mcd,
6146: ar_distributions dis
6147: WHERE mcd.cash_receipt_id = cr.cash_receipt_id
6148: AND dis.source_id = mcd.misc_cash_distribution_id
6149: AND dis.source_table = 'MCD'
6150: AND mcd.posting_control_id = -3