APPS.OZF_AR_PAYMENT_PVT dependencies on OZF_CLAIM_LINES

Line 2475: FROM ozf_claim_lines

2471: , credit_to
2472: , SUM(quantity) qty
2473: , AVG(rate) rate
2474: , SUM(NVL(claim_currency_amount,0)) amount
2475: FROM ozf_claim_lines
2476: WHERE claim_id = cv_claim_id
2477: AND source_object_id = cv_inv_id
2478: GROUP BY source_object_id,source_object_line_id,credit_to;
2479:

Line 2491: ozf_claim_lines_all cli

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'
2495: AND ar.display ='Y'

Line 2675: FROM ozf_claim_lines

2671: l_old_applied_invoice csr_old_applied_amount%ROWTYPE;
2672:
2673: CURSOR csr_count_claim_line(cv_claim_id IN NUMBER) IS
2674: SELECT COUNT(claim_line_id)
2675: FROM ozf_claim_lines
2676: WHERE claim_id = cv_claim_id;
2677:
2678: CURSOR csr_invoice_apply_receipt(cv_invoice_id IN NUMBER) IS
2679: SELECT rec.cash_receipt_id

Line 3343: FROM ozf_claim_lines

3339: l_old_applied_invoice csr_old_applied_amount%ROWTYPE;
3340:
3341: CURSOR csr_count_claim_line(cv_claim_id IN NUMBER) IS
3342: SELECT COUNT(claim_line_id)
3343: FROM ozf_claim_lines
3344: WHERE claim_id = cv_claim_id;
3345:
3346: CURSOR csr_claim_line_invoice(cv_claim_id IN NUMBER) IS
3347: SELECT source_object_class

Line 3350: FROM ozf_claim_lines

3346: CURSOR csr_claim_line_invoice(cv_claim_id IN NUMBER) IS
3347: SELECT source_object_class
3348: , source_object_id
3349: , source_object_line_id
3350: FROM ozf_claim_lines
3351: WHERE claim_id = cv_claim_id;
3352:
3353:
3354: CURSOR csr_invoice_apply_receipt(cv_invoice_id IN NUMBER) IS

Line 3379: FROM ozf_claim_lines_all

3375:
3376: --//Bug 12340283
3377: CURSOR csr_claim_lines(cv_claim_id IN NUMBER) IS
3378: SELECT source_object_id, sum(claim_currency_amount) amt
3379: FROM ozf_claim_lines_all
3380: WHERE claim_id = cv_claim_id
3381: GROUP BY source_object_id;
3382:
3383: /*CURSOR csr_claim_lines_ar(cv_claim_id IN NUMBER) IS

Line 3389: ozf_claim_lines_all cli

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'
3393: AND ar.display ='Y'

Line 3404: ozf_claim_lines_all cli

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;
3408:

Line 3413: ozf_claim_lines_all cli

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'
3417: AND ar.display ='Y'