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 RA_CUSTOMER_TRX_ALL

Line 650: ra_customer_trx_all ct

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
653: AND ps.status = 'OP' -- status = Open
654: AND ps.customer_id = p_cust_account_id

Line 674: ra_customer_trx_all ct,

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
677: FROM HZ_CUST_ACCT_RELATE_ALL REL, HZ_CUST_ACCT_SITES_ALL ACCT_SITE,
678: HZ_CUST_SITE_USES_ALL SITE

Line 723: ra_customer_trx_all ct

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
726: AND ps.status = 'OP' -- status = Open
727: AND ps.customer_id = p_cust_account_id

Line 747: ra_customer_trx_all ct,

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
750: FROM HZ_CUST_ACCT_RELATE_ALL REL,
751: HZ_CUST_ACCT_SITES_ALL ACCT_SITE,