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 OZF_CLAIMS_ALL

Line 277: FROM ozf_claims_all

273: ,x_claim_rec.deduction_attribute15
274: ,x_claim_rec.org_id
275: ,x_claim_rec.wo_rec_trx_id
276: ,x_claim_rec.legal_entity_id
277: FROM ozf_claims_all
278: WHERE claim_id = p_claim_id ;
279: x_return_status := FND_API.g_ret_sts_success;
280: EXCEPTION
281: WHEN OTHERS THEN

Line 476: FROM ozf_claims_all

472: --Start:Bug:2781186
473: --Cursor to get customer reason,customer ref, reason code id
474: CURSOR csr_get_more_root_clm_dtls (cv_claim_id IN NUMBER) IS
475: SELECT claim_number, claim_id, customer_ref_number
476: FROM ozf_claims_all
477: WHERE claim_id = cv_claim_id;
478:
479:
480: --Cursor to get customer reason,customer ref, reason code id in case of child cliam

Line 506: FROM ozf_claims_all

502: , deduction_attribute12
503: , deduction_attribute13
504: , deduction_attribute14
505: , deduction_attribute15
506: FROM ozf_claims_all
507: WHERE claim_id = p_claim_id;
508: -- bug#9279072(-)
509:
510: BEGIN

Line 772: FROM ozf_claims_all

768:
769: -- Added For Rule Based Settlement ER
770: CURSOR csr_claim_trx(cv_claim_id IN NUMBER) IS
771: SELECT source_object_id, payment_method -- For bug#9279072
772: FROM ozf_claims_all
773: WHERE claim_id = cv_claim_id;
774:
775: CURSOR csr_rec_flex_flds (p_cash_receipt_id IN NUMBER, p_customer_trx_id IN NUMBER) IS
776: SELECT attribute_category

Line 815: FROM ozf_claims_all

811: , deduction_attribute12
812: , deduction_attribute13
813: , deduction_attribute14
814: , deduction_attribute15
815: FROM ozf_claims_all
816: WHERE claim_id = p_claim_id;
817: -- bug#9279072(-)
818:
819:

Line 1227: ozf_claims_all oc

1223: SELECT oc.customer_reason, oc.customer_ref_number,
1224: oc.reason_code_id, osp.post_to_gl,
1225: (SELECT SUBSTRB(name,1,30) FROM ozf_reason_codes_vl WHERE reason_code_id = oc.reason_code_id) as name
1226: FROM ozf_sys_parameters_all osp,
1227: ozf_claims_all oc
1228: WHERE
1229: NVL(osp.org_id, -99) = NVL(oc.org_id, -99)
1230: AND oc.claim_id = cv_claim_id;
1231: l_post_to_gl VARCHAR2(1);

Line 1586: FROM ozf_claims_all

1582: SELECT customer_reason, customer_ref_number, reason_code_id
1583: --, customer_ref_date --11.5.10 enhancements - TM should pass
1584: -- Uncomment and Corresponding change for this has to be done while assigning to code after
1585: -- AR enhancement for this is done.
1586: FROM ozf_claims_all
1587: WHERE claim_id = cv_claim_id;
1588:
1589: -- Cursor to get claim reason name
1590: CURSOR csr_get_reason_name (cv_reason_code_id IN NUMBER) IS

Line 1907: FROM ozf_claims_all

1903: --Start:Bug:2781186
1904: -- Cursor to get customer reason,customer ref, reason code id
1905: CURSOR csr_get_more_root_clm_dtls (cv_claim_id IN NUMBER) IS
1906: SELECT claim_number, claim_id, customer_ref_number
1907: FROM ozf_claims_all
1908: WHERE claim_id = cv_claim_id;
1909:
1910: --Cursor to get customer reason,customer ref, reason code id in case of child cliam
1911: CURSOR csr_get_more_chld_clm_dtls (cv_claim_id IN NUMBER) IS

Line 2340: UPDATE ozf_claims_all

2336:
2337: --//Bug 5345095 BK Modif
2338: IF l_receivables_trx_id IS NOT NULL THEN
2339: BEGIN
2340: UPDATE ozf_claims_all
2341: SET wo_rec_trx_id = l_receivables_trx_id
2342: WHERE claim_id = p_claim_rec.claim_id
2343: AND wo_rec_trx_id IS NULL;
2344:

Line 2490: ozf_claims_all cla,

2486: SUM(cli.quantity) qty,
2487: AVG(cli.rate) rate,
2488: SUM(NVL(cli.claim_currency_amount,0)) amount
2489: FROM ar_receivable_applications_all ar,
2490: ozf_claims_all cla,
2491: ozf_claim_lines_all cli
2492: WHERE cla.claim_id = cli.claim_id
2493: AND ar.cash_receipt_id = cla.receipt_id
2494: AND ar.status ='APP'

Line 3388: ozf_claims_all cla,

3384: SELECT ar.applied_customer_trx_id,
3385: cli.source_object_id,
3386: SUM(cli.claim_currency_amount) amt
3387: FROM ar_receivable_applications_all ar,
3388: ozf_claims_all cla,
3389: ozf_claim_lines_all cli
3390: WHERE cla.claim_id = cli.claim_id
3391: AND ar.cash_receipt_id = cla.receipt_id
3392: AND ar.status ='APP'

Line 3403: ozf_claims_all cla,

3399: SELECT
3400: cli.source_object_id,
3401: SUM(cli.claim_currency_amount) amt
3402: FROM
3403: ozf_claims_all cla,
3404: ozf_claim_lines_all cli
3405: WHERE cla.claim_id = cli.claim_id
3406: AND cla.claim_id = cv_claim_id
3407: GROUP BY cli.source_object_id;

Line 3412: ozf_claims_all cla,

3408:
3409: CURSOR get_applied_invoice_cnt(cv_claim_id IN NUMBER) IS
3410: SELECT count(*)
3411: FROM ar_receivable_applications_all ar,
3412: ozf_claims_all cla,
3413: ozf_claim_lines_all cli
3414: WHERE cla.claim_id = cli.claim_id
3415: AND ar.cash_receipt_id = cla.receipt_id
3416: AND ar.status ='APP'

Line 4603: SELECT claim_id, amount_due_remaining FROM ozf_claims_all, ar_payment_schedules_all

4599: l_settlement_amount NUMBER := NULL ;
4600:
4601: -- Start Fix for Bug4324426
4602: CURSOR csr_ded_details(p_customer_trx_id IN NUMBER) IS
4603: SELECT claim_id, amount_due_remaining FROM ozf_claims_all, ar_payment_schedules_all
4604: WHERE source_object_id = customer_trx_id
4605: AND source_object_class = class
4606: AND claim_class = 'DEDUCTION'
4607: AND cust_account_id = customer_id

Line 4655: FROM ozf_claims_all

4651: l_old_applied_invoice csr_old_applied_invoice%ROWTYPE;
4652:
4653: CURSOR csr_claim_src(cv_claim_id IN NUMBER) IS
4654: SELECT source_object_class
4655: FROM ozf_claims_all
4656: WHERE claim_id = cv_claim_id;
4657:
4658: CURSOR csr_receipt_amt(cv_claim_id IN NUMBER) IS
4659: SELECT amount_applied