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_LINE_PVT dependencies on OZF_CLAIMS

Line 435: FROM ozf_claims

431: AND org.org_id = MO_GLOBAL.GET_CURRENT_ORG_ID();
432:
433: CURSOR csr_claim_currency(cv_claim_id IN NUMBER) IS
434: SELECT currency_code
435: FROM ozf_claims
436: WHERE claim_id = cv_claim_id;
437:
438: CURSOR csr_order_default_exc(cv_doc_id IN NUMBER) IS
439: SELECT transactional_curr_code

Line 646: FROM ozf_claims

642: , payment_method
643: , tax_code
644: , set_of_books_id
645: , amount -- Bug:2781186
646: FROM ozf_claims
647: WHERE claim_id = cv_claim_id;
648:
649: CURSOR csr_line_rec_upd(cv_claim_id IN NUMBER) IS
650: SELECT claim_line_id

Line 1004: FROM ozf_claims_all

1000: , amount
1001: , payment_method
1002: , vendor_id
1003: , vendor_site_id
1004: FROM ozf_claims_all
1005: WHERE claim_id = p_claim_id;
1006:
1007: CURSOR csr_line_rec_upd IS
1008: SELECT claim_line_id

Line 1244: FROM ozf_claims

1240:
1241: -- Cursor to get claim amount
1242: CURSOR c_claim_amount(cv_claim_id IN NUMBER) IS
1243: SELECT amount_remaining, claim_class
1244: FROM ozf_claims
1245: WHERE claim_id = cv_claim_id;
1246:
1247: -- Cursor to get claim amount
1248: CURSOR c_exist_total_line_amt(cv_claim_id IN NUMBER) IS

Line 1255: FROM ozf_claims

1251: WHERE claim_id = cv_claim_id;
1252:
1253: CURSOR c_claim(cv_claim_id IN NUMBER) IS
1254: SELECT currency_code
1255: FROM ozf_claims
1256: WHERE claim_id = cv_claim_id;
1257:
1258: -- Bug#9957893 (+)
1259: CURSOR c_old_line_qty(cv_src_obj_line_id IN NUMBER) IS

Line 1610: FROM ozf_claims

1606:
1607: -- Cursor to get set_of_books_id, and tax_code from Claim
1608: CURSOR csr_default_fm_claim(cv_claim_id IN NUMBER) IS
1609: SELECT set_of_books_id, tax_code, org_id
1610: FROM ozf_claims
1611: WHERE CLAIM_ID = cv_claim_id;
1612:
1613: -- Cursor to get claim amount
1614: CURSOR c_claim_amount(cv_claim_id IN NUMBER) IS

Line 1617: FROM ozf_claims

1613: -- Cursor to get claim amount
1614: CURSOR c_claim_amount(cv_claim_id IN NUMBER) IS
1615: SELECT amount_remaining
1616: , claim_class
1617: FROM ozf_claims
1618: WHERE claim_id = cv_claim_id;
1619:
1620: -- Cursor to sum of claim line amount
1621: CURSOR c_line_sum_amt(cv_claim_id IN NUMBER) IS

Line 1632: FROM ozf_claims

1628: SELECT currency_code
1629: , exchange_rate_type
1630: , exchange_rate_date
1631: , exchange_rate
1632: FROM ozf_claims
1633: WHERE claim_id = cv_claim_id;
1634:
1635: -- fix for bug 5042046
1636: -- Cursor to get functional currency

Line 1689: ozf_claims_all oc

1685: SELECT
1686: orb.batch_type
1687: FROM
1688: ozf_resale_batches_all orb,
1689: ozf_claims_all oc
1690: WHERE
1691: oc.batch_id = orb.resale_batch_id
1692: AND oc.claim_id = p_claim_id;
1693: --Bug# 7319828 fixed by ateotia(-)

Line 2347: FROM ozf_claims

2343:
2344:
2345: CURSOR csr_claim_amount(cv_claim_id IN NUMBER) IS
2346: SELECT amount_remaining, claim_class
2347: FROM ozf_claims
2348: WHERE claim_id = cv_claim_id;
2349:
2350: CURSOR csr_exist_total_line_amt(cv_claim_id IN NUMBER) IS
2351: SELECT nvl(sum(claim_currency_amount), 0)

Line 2591: FROM ozf_claims

2587:
2588: -- Cursor to get claim amount
2589: CURSOR c_claim_amount(cv_claim_id IN NUMBER) IS
2590: SELECT amount_remaining
2591: FROM ozf_claims
2592: WHERE claim_id = cv_claim_id;
2593:
2594: -- Cursor to sum of claim line amount
2595: CURSOR c_line_sum_amt(cv_claim_id IN NUMBER, cv_line_id IN NUMBER) IS

Line 3113: FROM ozf_claims

3109: , exchange_rate_date
3110: , exchange_rate
3111: , claim_class
3112: , offer_id
3113: FROM ozf_claims
3114: WHERE claim_id = cv_claim_id;
3115:
3116: -- Bug#9957893 (+)
3117: CURSOR c_old_line_qty(cv_src_obj_line_id IN NUMBER) IS

Line 3463: FROM ozf_claims

3459: -- ER#9453443
3460: CURSOR c_claim_amount(cv_claim_id IN NUMBER) IS
3461: SELECT amount_remaining
3462: , claim_class, offer_id
3463: FROM ozf_claims
3464: WHERE claim_id = cv_claim_id;
3465:
3466: -- cursor to get payment_method
3467: CURSOR c_claim_payment_method(cv_claim_id IN NUMBER) IS

Line 3469: FROM ozf_claims

3465:
3466: -- cursor to get payment_method
3467: CURSOR c_claim_payment_method(cv_claim_id IN NUMBER) IS
3468: SELECT payment_method
3469: FROM ozf_claims
3470: WHERE claim_id = cv_claim_id;
3471:
3472: -- Cursor to sum of line util associations
3473: -- Chage the cursor for bug 7658894

Line 3493: FROM ozf_claims

3489: , currency_code
3490: , exchange_rate_type
3491: , exchange_rate_date
3492: , exchange_rate
3493: FROM ozf_claims
3494: WHERE claim_id = cv_claim_id;
3495:
3496: -- fix for bug 5042046
3497: CURSOR csr_function_currency IS

Line 4607: ozf_claims_all oc

4603:
4604: CURSOR csr_claim_settle_method(cv_claim_id IN NUMBER) IS
4605: SELECT ocs.tax_for
4606: FROM ozf_claim_sttlmnt_methods_all ocs,
4607: ozf_claims_all oc
4608: WHERE claim_id = cv_claim_id
4609: AND ocs.claim_class = oc.claim_class
4610: AND NVL(ocs.source_object_class,'NULL') = NVL(oc.source_object_class,'NULL')
4611: AND ocs.settlement_method = oc.payment_method ;

Line 5521: FROM ozf_claims_all

5517:
5518:
5519: CURSOR csr_claim_status(cv_claim_id IN NUMBER) IS
5520: SELECT status_code
5521: FROM ozf_claims_all
5522: WHERE claim_id = cv_claim_id;
5523:
5524: -- added for bugfix 5075837 to get max line number
5525: CURSOR c_line_number(cv_claim_id IN NUMBER) IS