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_CLAIM_UTILITY_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 648: FROM ar_payment_schedules_all ps,

644: p_deduction_amount IN NUMBER, p_ref_number IN VARCHAR2) IS
645: SELECT ps.customer_trx_id,
646: ps.trx_number,
647: ps.amount_due_remaining
648: FROM ar_payment_schedules_all ps,
649: ra_cust_trx_types_all ctt,
650: ra_customer_trx_all ct
651: WHERE
652: ps.class in ('CM') --class = Credit Memo

Line 672: FROM ar_payment_schedules_all ps,

668: p_deduction_amount IN NUMBER, p_ref_number IN VARCHAR2) IS
669: SELECT ps.customer_trx_id,
670: ps.trx_number,
671: ps.amount_due_remaining
672: FROM ar_payment_schedules_all ps,
673: ra_cust_trx_types_all ctt,
674: ra_customer_trx_all ct,
675: (
676: SELECT SITE.site_use_id site_use_id

Line 721: ar_payment_schedules_all ps,

717: SELECT ps.customer_trx_id,
718: ps.trx_number,
719: ps.amount_due_remaining
720: FROM
721: ar_payment_schedules_all ps,
722: ra_cust_trx_types_all ctt,
723: ra_customer_trx_all ct
724: WHERE
725: ps.class in ('CM') --class = Credit Memo

Line 745: ar_payment_schedules_all ps,

741: SELECT ps.customer_trx_id,
742: ps.trx_number,
743: ps.amount_due_remaining
744: FROM
745: ar_payment_schedules_all ps,
746: ra_cust_trx_types_all ctt,
747: ra_customer_trx_all ct,
748: (
749: SELECT SITE.site_use_id site_use_id