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_GRP dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 1974: FROM ar_receivable_applications_all

1970: -- Added for Bug5102282
1971: -- Get the payment_schedule_id
1972: CURSOR csr_applied_ps_id( cv_customer_trx_id IN NUMBER, cv_receipt_id IN NUMBER, cv_claim_id IN NUMBER) IS
1973: SELECT distinct applied_payment_schedule_id
1974: FROM ar_receivable_applications_all
1975: WHERE cash_receipt_id = cv_receipt_id
1976: AND applied_customer_trx_id = cv_customer_trx_id
1977: AND application_ref_type = 'CLAIM'
1978: AND secondary_application_ref_id = cv_claim_id

Line 1986: FROM ar_receivable_applications_all

1982: -- Added for Bug5102282
1983: -- Get the count of applications
1984: CURSOR csr_cnt_apply(cv_ps_id IN NUMBER, cv_receipt_id IN NUMBER, cv_claim_id IN NUMBER) IS
1985: SELECT COUNT(*)
1986: FROM ar_receivable_applications_all
1987: WHERE applied_payment_schedule_id = cv_ps_id
1988: AND cash_receipt_id <> cv_receipt_id
1989: AND application_ref_type = 'CLAIM'
1990: AND secondary_application_ref_id = cv_claim_id

Line 2754: FROM ar_receivable_applications_all ra,

2750: CURSOR cur_active_receipt (p_claim_id IN NUMBER
2751: ,p_cash_receipt_id IN NUMBER ) IS
2752: SELECT ra.cash_receipt_id,
2753: cr.receipt_number
2754: FROM ar_receivable_applications_all ra,
2755: ar_cash_receipts_all cr
2756: WHERE ra.cash_receipt_id = cr.cash_receipt_id
2757: AND ra.cash_receipt_id <> p_cash_receipt_id
2758: AND ra.application_ref_type = 'CLAIM'