eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_AR_PAYMENT_PVT dependencies on AR_RECEIVABLE_APPLICATIONS

Line 573: --p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

569: p_receipt_number => NULL, --p_claim_rec.receipt_number,
570: p_amount_applied => l_amount_applied,
571: --p_apply_date => SYSDATE, --AR should default
572: --p_apply_gl_date => p_claim_rec.gl_date, --11.5.10 Enhancements. AR should default
573: --p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
574: --p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
575: -- Global Flexfield parameters
576: --p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
577: -- bug#9279072 (+)

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 958: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,

954: p_amount_applied_from => p_new_applied_from_amount,--4684931
955: p_apply_date => p_apply_date, -- Fix for Bug 3091401. TM passes old apply date
956: -- this is the allocated receipt amount
957: /*
958: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
959: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
960: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
961: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
962: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

Line 959: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,

955: p_apply_date => p_apply_date, -- Fix for Bug 3091401. TM passes old apply date
956: -- this is the allocated receipt amount
957: /*
958: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
959: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
960: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
961: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
962: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
963: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

Line 960: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,

956: -- this is the allocated receipt amount
957: /*
958: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
959: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
960: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
961: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
962: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
963: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
964: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,

Line 961: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,

957: /*
958: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
959: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
960: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
961: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
962: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
963: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
964: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
965: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,

Line 962: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

958: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE DEFAULT NULL,
959: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
960: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
961: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
962: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
963: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
964: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
965: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
966: p_show_closed_invoices IN VARCHAR2 DEFAULT 'FALSE',

Line 963: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

959: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE DEFAULT NULL,
960: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
961: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
962: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
963: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
964: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
965: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
966: p_show_closed_invoices IN VARCHAR2 DEFAULT 'FALSE',
967: p_called_from IN VARCHAR2 DEFAULT NULL,

Line 964: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,

960: p_discount IN ar_receivable_applications.earned_discount_taken%TYPE DEFAULT NULL,
961: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
962: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
963: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
964: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
965: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
966: p_show_closed_invoices IN VARCHAR2 DEFAULT 'FALSE',
967: p_called_from IN VARCHAR2 DEFAULT NULL,
968: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',

Line 969: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,

965: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
966: p_show_closed_invoices IN VARCHAR2 DEFAULT 'FALSE',
967: p_called_from IN VARCHAR2 DEFAULT NULL,
968: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
969: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,
970: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
971: */
972: -- ******* Global Flexfield parameters *******
973: --p_global_attribute_rec => p_global_attribute_rec,

Line 1873: FROM ar_receivable_applications

1869: , cv_claim_id IN NUMBER
1870: ) IS
1871: SELECT receivable_application_id
1872: , applied_payment_schedule_id
1873: FROM ar_receivable_applications
1874: WHERE cash_receipt_id = cv_cash_receipt_id
1875: AND applied_customer_trx_id = cv_customer_trx_id
1876: AND application_ref_type = 'CLAIM'
1877: ANd secondary_application_ref_id = cv_claim_id

Line 1926: FROM ar_receivable_applications rec

1922: SELECT pay.amount_due_remaining,
1923: pay.amount_line_items_remaining,
1924: pay.tax_remaining,
1925: pay.freight_remaining
1926: FROM ar_receivable_applications rec
1927: , ar_payment_schedules pay
1928: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
1929: AND rec.cash_receipt_id = cv_cash_receipt_id
1930: AND pay.customer_trx_id = cv_customer_trx_id

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 2643: FROM ar_receivable_applications rec

2639: , rec.application_ref_num
2640: , rec.secondary_application_ref_id
2641: , rec.application_ref_reason
2642: , rec.customer_reference
2643: FROM ar_receivable_applications rec
2644: , ar_payment_schedules pay
2645: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
2646: AND rec.cash_receipt_id = cv_cash_receipt_id
2647: AND pay.customer_trx_id = cv_customer_trx_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 2688: FROM ar_receivable_applications rec

2684:
2685: CURSOR csr_old_claim_investigation( cv_cash_receipt_id IN NUMBER
2686: , cv_root_claim_id IN NUMBER) IS
2687: SELECT rec.amount_applied
2688: FROM ar_receivable_applications rec
2689: WHERE rec.applied_payment_schedule_id = -4
2690: AND rec.cash_receipt_id = cv_cash_receipt_id
2691: AND rec.application_ref_type = 'CLAIM'
2692: AND rec.display = 'Y'

Line 3332: FROM ar_receivable_applications rec

3328: , rec.application_ref_num
3329: , rec.secondary_application_ref_id
3330: , rec.application_ref_reason
3331: , rec.customer_reference
3332: FROM ar_receivable_applications rec
3333: , ar_payment_schedules pay
3334: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
3335: AND rec.cash_receipt_id = cv_cash_receipt_id
3336: AND pay.customer_trx_id = cv_customer_trx_id

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 3364: FROM ar_receivable_applications rec

3360:
3361: CURSOR csr_old_claim_investigation( cv_cash_receipt_id IN NUMBER
3362: , cv_root_claim_id IN NUMBER) IS
3363: SELECT rec.amount_applied
3364: FROM ar_receivable_applications rec
3365: WHERE rec.applied_payment_schedule_id = -4
3366: AND rec.cash_receipt_id = cv_cash_receipt_id
3367: AND rec.application_ref_type = 'CLAIM'
3368: AND rec.display = 'Y'

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 3713: l_apply_date ar_receivable_applications.apply_date%TYPE; -- Fix for Bug 3091401. TM passes old apply date

3709: l_p_new_applied_from_amount NUMBER;
3710: l_receipt_currency VARCHAR2(15);
3711: l_trx_currency VARCHAR2(15);
3712: l_cm_applied_on_rec_amt NUMBER;
3713: l_apply_date ar_receivable_applications.apply_date%TYPE; -- Fix for Bug 3091401. TM passes old apply date
3714: l_cm_applied_on_rec_amt_from NUMBER;
3715:
3716: -- Fix for Bug 7494234
3717: CURSOR csr_old_applied_invoice( cv_cash_receipt_id IN NUMBER

Line 3726: FROM ar_receivable_applications rec

3722: , rec.application_ref_num
3723: , rec.secondary_application_ref_id
3724: , sum(rec.amount_applied) amount_applied
3725: , sum(rec.amount_applied_from) amount_applied_from --4684931
3726: FROM ar_receivable_applications rec
3727: , ar_payment_schedules pay
3728: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
3729: AND rec.cash_receipt_id = cv_cash_receipt_id
3730: AND pay.customer_trx_id = cv_customer_trx_id

Line 3747: FROM ar_receivable_applications rec

3743: , rec.customer_reference
3744: , rec.amount_applied
3745: , rec.amount_applied_from --4684931
3746: , pay.amount_due_remaining
3747: FROM ar_receivable_applications rec
3748: , ar_payment_schedules pay
3749: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
3750: AND rec.cash_receipt_id = cv_cash_receipt_id
3751: AND pay.customer_trx_id = cv_customer_trx_id

Line 3761: FROM ar_receivable_applications

3757: l_old_applied_invoice csr_old_applied_invoice%ROWTYPE;
3758:
3759: CURSOR csr_claim_investigation_amount(cv_root_claim_id IN NUMBER) IS
3760: SELECT amount_applied
3761: FROM ar_receivable_applications
3762: WHERE application_ref_type = 'CLAIM'
3763: AND applied_payment_schedule_id = -4
3764: AND display = 'Y'
3765: AND secondary_application_ref_id = cv_root_claim_id;

Line 3771: FROM ar_receivable_applications

3767: CURSOR csr_cm_exist_on_rec(cv_cash_receipt_id IN NUMBER, cv_customer_trx_id IN NUMBER) IS
3768: SELECT amount_applied,
3769: amount_applied_from, --4684931
3770: apply_date -- Fix for Bug 3091401. TM passes old apply date
3771: FROM ar_receivable_applications
3772: WHERE cash_receipt_id = cv_cash_receipt_id
3773: AND applied_customer_trx_id = cv_customer_trx_id
3774: AND display = 'Y'
3775: AND status = 'APP';

Line 4175: FROM ar_receivable_applications rec

4171:
4172: CURSOR csr_old_claim_investigation( cv_cash_receipt_id IN NUMBER
4173: , cv_root_claim_id IN NUMBER) IS
4174: SELECT rec.amount_applied
4175: FROM ar_receivable_applications rec
4176: WHERE rec.applied_payment_schedule_id = -4
4177: AND rec.cash_receipt_id = cv_cash_receipt_id
4178: AND rec.application_ref_type = 'CLAIM'
4179: AND rec.display = 'Y'

Line 4568: l_apply_date ar_receivable_applications.apply_date%TYPE; -- Fix for Bug 3091401. TM passes old apply date

4564: l_p_new_applied_from_amount NUMBER; --bug 4684931
4565: l_receipt_currency VARCHAR2(15);
4566: l_trx_currency VARCHAR2(15);
4567: l_dm_applied_on_rec_amt NUMBER ;
4568: l_apply_date ar_receivable_applications.apply_date%TYPE; -- Fix for Bug 3091401. TM passes old apply date
4569: l_dm_applied_on_rec_amt_from NUMBER;
4570:
4571: CURSOR csr_dm_trx_type_id(cv_claim_type_id IN NUMBER) IS
4572: SELECT dm_trx_type_id

Line 4578: FROM ar_receivable_applications

4574: WHERE claim_type_id = cv_claim_type_id;
4575:
4576: CURSOR csr_claim_investigation_amount(cv_root_claim_id IN NUMBER) IS
4577: SELECT amount_applied
4578: FROM ar_receivable_applications
4579: WHERE application_ref_type = 'CLAIM'
4580: AND applied_payment_schedule_id = -4
4581: AND display = 'Y'
4582: AND secondary_application_ref_id = cv_root_claim_id;

Line 4593: FROM ar_receivable_applications

4589: CURSOR csr_dm_exist_on_rec(cv_cash_receipt_id IN NUMBER, cv_customer_trx_id IN NUMBER) IS
4590: SELECT amount_applied,
4591: amount_applied_from,--bug 4684931
4592: apply_date -- Fix for Bug 3091401. TM passes old apply date
4593: FROM ar_receivable_applications
4594: WHERE cash_receipt_id = cv_cash_receipt_id
4595: AND applied_customer_trx_id = cv_customer_trx_id
4596: AND display = 'Y'
4597: AND status = 'APP';

Line 4640: FROM ar_receivable_applications rec

4636: , rec.application_ref_num
4637: , rec.secondary_application_ref_id
4638: , sum(rec.amount_applied) amount_applied
4639: , sum(rec.amount_applied_from) amount_applied_from --4684931
4640: FROM ar_receivable_applications rec
4641: , ar_payment_schedules pay
4642: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
4643: AND rec.cash_receipt_id = cv_cash_receipt_id
4644: AND pay.customer_trx_id = cv_customer_trx_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

Line 4673: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;

4669: l_receipt_amt NUMBER;
4670: l_trx_amt NUMBER;
4671:
4672: l_out_rec_application_id NUMBER;
4673: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
4674: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
4675: l_cm_app_rec AR_CM_API_PUB.cm_app_rec_type;
4676:
4677:

Line 4674: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;

4670: l_trx_amt NUMBER;
4671:
4672: l_out_rec_application_id NUMBER;
4673: l_acctd_amount_applied_from ar_receivable_applications.acctd_amount_applied_from%TYPE;
4674: l_acctd_amount_applied_to ar_receivable_applications.acctd_amount_applied_to%TYPE;
4675: l_cm_app_rec AR_CM_API_PUB.cm_app_rec_type;
4676:
4677:
4678: