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_PAYMENT_SCHEDULES

Line 590: FROM ar_payment_schedules

586: l_payment_schedule_id NUMBER;
587:
588: CURSOR csr_payment_schedule(cv_customer_trx_id IN NUMBER) IS
589: SELECT payment_schedule_id
590: FROM ar_payment_schedules
591: WHERE customer_trx_id = cv_customer_trx_id;
592:
593: BEGIN
594: -------------------- initialize -----------------------

Line 700: FROM ar_payment_schedules

696: l_balance_amount NUMBER;
697:
698: CURSOR csr_payment_schedule(cv_customer_trx_id IN NUMBER) IS
699: SELECT payment_schedule_id
700: FROM ar_payment_schedules
701: WHERE customer_trx_id = cv_customer_trx_id;
702:
703: CURSOR csr_trx_balance(cv_customer_trx_id IN NUMBER) IS
704: SELECT ABS(amount_due_remaining)

Line 705: FROM ar_payment_schedules

701: WHERE customer_trx_id = cv_customer_trx_id;
702:
703: CURSOR csr_trx_balance(cv_customer_trx_id IN NUMBER) IS
704: SELECT ABS(amount_due_remaining)
705: FROM ar_payment_schedules
706: WHERE customer_trx_id = cv_customer_trx_id;
707:
708: BEGIN
709: -------------------- initialize -----------------------

Line 1002: FROM ar_payment_schedules

998: CURSOR csr_credit_amount(cv_customer_trx_id IN NUMBER) IS
999: SELECT SUM(NVL(amount_line_items_remaining, 0))
1000: , SUM(NVL(tax_remaining, 0))
1001: , SUM(NVL(freight_remaining, 0))
1002: FROM ar_payment_schedules
1003: WHERE customer_trx_id = cv_customer_trx_id;
1004:
1005: BEGIN
1006: -------------------- initialize -----------------------

Line 1639: , ar_payment_schedules pay

1635: pay.amount_line_items_remaining,
1636: pay.tax_remaining,
1637: pay.freight_remaining
1638: FROM ar_receivable_applications rec
1639: , ar_payment_schedules pay
1640: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
1641: AND rec.cash_receipt_id = cv_cash_receipt_id
1642: AND pay.customer_trx_id = cv_customer_trx_id
1643: AND rec.application_ref_type = 'CLAIM'

Line 2240: , ar_payment_schedules pay

2236: , rec.secondary_application_ref_id
2237: , rec.application_ref_reason
2238: , rec.customer_reference
2239: FROM ar_receivable_applications rec
2240: , ar_payment_schedules pay
2241: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
2242: AND rec.cash_receipt_id = cv_cash_receipt_id
2243: AND pay.customer_trx_id = cv_customer_trx_id
2244: AND rec.display = 'Y';

Line 2256: , ar_payment_schedules pay

2252:
2253: CURSOR csr_invoice_apply_receipt(cv_invoice_id IN NUMBER) IS
2254: SELECT rec.cash_receipt_id
2255: FROM ar_receivable_applications_all rec
2256: , ar_payment_schedules pay
2257: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
2258: AND pay.customer_trx_id = cv_invoice_id;
2259:
2260: CURSOR csr_old_claim_investigation( cv_cash_receipt_id IN NUMBER

Line 2868: , ar_payment_schedules pay

2864: , rec.secondary_application_ref_id
2865: , rec.application_ref_reason
2866: , rec.customer_reference
2867: FROM ar_receivable_applications rec
2868: , ar_payment_schedules pay
2869: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
2870: AND rec.cash_receipt_id = cv_cash_receipt_id
2871: AND pay.customer_trx_id = cv_customer_trx_id
2872: AND rec.display = 'Y';

Line 2892: , ar_payment_schedules pay

2888:
2889: CURSOR csr_invoice_apply_receipt(cv_invoice_id IN NUMBER) IS
2890: SELECT rec.cash_receipt_id
2891: FROM ar_receivable_applications_all rec
2892: , ar_payment_schedules pay
2893: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
2894: AND pay.customer_trx_id = cv_invoice_id;
2895:
2896: CURSOR csr_old_claim_investigation( cv_cash_receipt_id IN NUMBER

Line 3110: , ar_payment_schedules pay

3106: , rec.secondary_application_ref_id
3107: , sum(rec.amount_applied) amount_applied
3108: , sum(rec.amount_applied_from) amount_applied_from --4684931
3109: FROM ar_receivable_applications rec
3110: , ar_payment_schedules pay
3111: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
3112: AND rec.cash_receipt_id = cv_cash_receipt_id
3113: AND pay.customer_trx_id = cv_customer_trx_id
3114: AND rec.application_ref_type = 'CLAIM'

Line 3131: , ar_payment_schedules pay

3127: , rec.amount_applied
3128: , rec.amount_applied_from --4684931
3129: , pay.amount_due_remaining
3130: FROM ar_receivable_applications rec
3131: , ar_payment_schedules pay
3132: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
3133: AND rec.cash_receipt_id = cv_cash_receipt_id
3134: AND pay.customer_trx_id = cv_customer_trx_id
3135: AND rec.application_ref_type = 'CLAIM'

Line 3982: SELECT claim_id, amount_due_remaining FROM ozf_claims_all, ar_payment_schedules_all

3978: l_settlement_amount NUMBER := NULL ;
3979:
3980: -- Start Fix for Bug4324426
3981: CURSOR csr_ded_details(p_customer_trx_id IN NUMBER) IS
3982: SELECT claim_id, amount_due_remaining FROM ozf_claims_all, ar_payment_schedules_all
3983: WHERE source_object_id = customer_trx_id
3984: AND source_object_class = class
3985: AND claim_class = 'DEDUCTION'
3986: AND cust_account_id = customer_id