DBA Data[Home] [Help]

APPS.OZF_CLAIM_UTILITY_PVT dependencies on RA_CUST_TRX_TYPES_ALL

Line 649: ra_cust_trx_types_all ctt,

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

Line 673: ra_cust_trx_types_all ctt,

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

Line 722: ra_cust_trx_types_all ctt,

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

Line 746: ra_cust_trx_types_all ctt,

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