APPS.ARP_RECONCILE dependencies on AR_RECEIVABLE_APPLICATIONS

Line 661: ar_receivable_applications app

657: ard.tax_code_id tax_code_id,
658: ard.code_combination_id code_combination_id';
659:
660: from1_stmt VARCHAR2(150) := ' from ar_distributions ard,
661: ar_receivable_applications app
662: where ';
663:
664: where1_stmt VARCHAR2(3000) := ' app.applied_customer_trx_id = :p_customer_trx_id
665: and :p_calling_point IN (''TRAN'', ''BLTR'')

Line 834: -- ar_receivable_applications app

830: tax_code_id,
831: code_combination_id';
832:
833: --from1_mrc_stmt VARCHAR2(100) := ' from ar_mc_distributions_all ard,
834: -- ar_receivable_applications app
835: -- where ';
836:
837: --where1_mrc_stmt VARCHAR2(150) := ' ard.set_of_books_id = :sob_id and ';
838:

Line 1139: FROM ar_receivable_applications app,

1135: nvl(app.freight_uediscounted,0)) freight_amount,
1136: sum(nvl(app.receivables_charges_applied,0) +
1137: nvl(app.charges_ediscounted,0) +
1138: nvl(app.charges_uediscounted,0)) receivables_charges_amount
1139: FROM ar_receivable_applications app,
1140: ar_payment_schedules pay
1141: WHERE app.applied_customer_trx_id = p_customer_trx_id
1142: AND app.status = 'APP'
1143: AND nvl(app.confirmed_flag, 'Y') = 'Y'

Line 1255: FROM ar_receivable_applications app

1251: l_cm_line_amt,
1252: l_cm_tax_amt,
1253: l_cm_frt_amt,
1254: l_cm_chrg_amt
1255: FROM ar_receivable_applications app
1256: WHERE app.applied_customer_trx_id = p_customer_trx_id
1257: AND app.application_type = 'CM'
1258: AND nvl(app.confirmed_flag, 'Y') = 'Y'
1259: AND app.status = 'APP';

Line 1326: FROM ar_receivable_applications app

1322: l_cm_line_amt,
1323: l_cm_tax_amt,
1324: l_cm_frt_amt,
1325: l_cm_chrg_amt
1326: FROM ar_receivable_applications app
1327: WHERE app.customer_trx_id = p_customer_trx_id
1328: AND app.application_type = 'CM'
1329: AND nvl(app.confirmed_flag, 'Y') = 'Y'
1330: AND app.status = 'APP';

Line 1612: l_app_rec ar_receivable_applications%ROWTYPE;

1608: l_pay_ctr BINARY_INTEGER := 0;
1609:
1610: l_br_tbl l_br_tbl_type;
1611:
1612: l_app_rec ar_receivable_applications%ROWTYPE;
1613:
1614: --The bill closed flag is defaulted to N
1615: l_all_br_closed VARCHAR2(1) := 'N';
1616: l_pay_class ar_payment_schedules.class%TYPE;

Line 2311: ar_receivable_applications app

2307: nvl(ard.taxable_entered_cr,0)) taxable_amount ,
2308: sum(nvl(ard.taxable_accounted_dr,0) * -1 +
2309: nvl(ard.taxable_accounted_cr,0)) taxable_acctd_amount
2310: from ar_distributions ard,
2311: ar_receivable_applications app
2312: where p_ae_sys_rec.sob_type = 'P'
2313: and app.applied_customer_trx_id = p_customer_trx_id
2314: and p_calling_point IN ('TRAN', 'BLTR')
2315: and app.status = 'APP'

Line 2435: l_app_rec ar_receivable_applications%ROWTYPE;

2431: l_ae_empty_line_rec ae_line_rec_type;
2432:
2433: l_ae_rule_rec ae_rule_rec_type;
2434:
2435: l_app_rec ar_receivable_applications%ROWTYPE;
2436: l_adj_rec ar_adjustments%ROWTYPE;
2437:
2438: l_tax_ctr NUMBER := 0;
2439: l_tax_ctr1 NUMBER := 0;

Line 3600: FROM ar_receivable_applications

3596: (SELECT ard.code_combination_id
3597: FROM ar_distributions ard
3598: WHERE ard.source_table = 'RA'
3599: AND source_id IN (SELECT receivable_application_id
3600: FROM ar_receivable_applications
3601: WHERE applied_customer_trx_id = p_customer_trx_id)
3602: AND ard.tax_code_id = nvl(p_tax_code_id,-999)
3603: AND source_type = 'TAX'
3604: AND source_type_secondary = 'PAYMENT'