APPS.OZF_AR_PAYMENT_PVT dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 792: FROM ar_receivable_applications_all

788: , attribute12
789: , attribute13
790: , attribute14
791: , attribute15
792: FROM ar_receivable_applications_all
793: WHERE cash_receipt_id = p_cash_receipt_id
794: AND applied_customer_trx_id = p_customer_trx_id
795: AND status = 'APP'
796: AND display = 'Y';

Line 2489: FROM ar_receivable_applications_all ar,

2485: cli.credit_to,
2486: SUM(cli.quantity) qty,
2487: AVG(cli.rate) rate,
2488: SUM(NVL(cli.claim_currency_amount,0)) amount
2489: FROM ar_receivable_applications_all ar,
2490: ozf_claims_all cla,
2491: ozf_claim_lines_all cli
2492: WHERE cla.claim_id = cli.claim_id
2493: AND ar.cash_receipt_id = cla.receipt_id

Line 2667: FROM ar_receivable_applications_all rec

2663: , rec.application_ref_num
2664: , rec.secondary_application_ref_id
2665: , rec.application_ref_reason
2666: , rec.customer_reference
2667: FROM ar_receivable_applications_all rec
2668: WHERE rec.cash_receipt_id = cv_cash_receipt_id
2669: AND rec.display = 'Y';
2670:
2671: l_old_applied_invoice csr_old_applied_amount%ROWTYPE;

Line 2680: FROM ar_receivable_applications_all rec

2676: WHERE claim_id = cv_claim_id;
2677:
2678: CURSOR csr_invoice_apply_receipt(cv_invoice_id IN NUMBER) IS
2679: SELECT rec.cash_receipt_id
2680: FROM ar_receivable_applications_all rec
2681: , ar_payment_schedules pay
2682: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
2683: AND pay.customer_trx_id = cv_invoice_id;
2684:

Line 3356: FROM ar_receivable_applications_all rec

3352:
3353:
3354: CURSOR csr_invoice_apply_receipt(cv_invoice_id IN NUMBER) IS
3355: SELECT rec.cash_receipt_id
3356: FROM ar_receivable_applications_all rec
3357: , ar_payment_schedules pay
3358: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
3359: AND pay.customer_trx_id = cv_invoice_id;
3360:

Line 3387: FROM ar_receivable_applications_all ar,

3383: /*CURSOR csr_claim_lines_ar(cv_claim_id IN NUMBER) IS
3384: SELECT ar.applied_customer_trx_id,
3385: cli.source_object_id,
3386: SUM(cli.claim_currency_amount) amt
3387: FROM ar_receivable_applications_all ar,
3388: ozf_claims_all cla,
3389: ozf_claim_lines_all cli
3390: WHERE cla.claim_id = cli.claim_id
3391: AND ar.cash_receipt_id = cla.receipt_id

Line 3411: FROM ar_receivable_applications_all ar,

3407: GROUP BY cli.source_object_id;
3408:
3409: CURSOR get_applied_invoice_cnt(cv_claim_id IN NUMBER) IS
3410: SELECT count(*)
3411: FROM ar_receivable_applications_all ar,
3412: ozf_claims_all cla,
3413: ozf_claim_lines_all cli
3414: WHERE cla.claim_id = cli.claim_id
3415: AND ar.cash_receipt_id = cla.receipt_id

Line 4660: FROM ar_receivable_applications_all

4656: WHERE claim_id = cv_claim_id;
4657:
4658: CURSOR csr_receipt_amt(cv_claim_id IN NUMBER) IS
4659: SELECT amount_applied
4660: FROM ar_receivable_applications_all
4661: WHERE secondary_application_ref_id = cv_claim_id;
4662:
4663: CURSOR csr_trx_amt(cv_customer_trx_id IN NUMBER) IS
4664: SELECT amount_applied