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 1140: FROM ar_receivable_applications app,

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

Line 1256: FROM ar_receivable_applications app

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

Line 1327: FROM ar_receivable_applications app

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

Line 1613: l_app_rec ar_receivable_applications%ROWTYPE;

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

Line 2312: ar_receivable_applications app

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

Line 2436: l_app_rec ar_receivable_applications%ROWTYPE;

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