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_CLAIM_LINES_UTIL

Line 2256: FROM ozf_claim_lines_util

2252: CURSOR csr_get_lines_util(cv_claim_line_id IN NUMBER) IS
2253: SELECT claim_line_util_id
2254: , object_version_number
2255: , currency_code
2256: FROM ozf_claim_lines_util
2257: WHERE claim_line_id = cv_claim_line_id;
2258:
2259: l_claim_id NUMBER;
2260: l_claim_amount NUMBER;

Line 3062: FROM ozf_claim_lines_util

3058: -- Cursor to sum of line util associations
3059: -- Chage the cursor for bug 7658894
3060: CURSOR csr_claim_line_util_amt(cv_claim_line_id IN NUMBER) IS
3061: SELECT nvl(SUM(acctd_amount),0), nvl(SUM(amount),0)
3062: FROM ozf_claim_lines_util
3063: WHERE claim_line_id = cv_claim_line_id;
3064:
3065: -- Cursor to sum of claim line amount
3066: CURSOR c_line_sum_amt(cv_claim_id IN NUMBER, cv_line_id IN NUMBER) IS

Line 3095: FROM ozf_claim_lines_util

3091: CURSOR csr_get_lines_util(cv_claim_line_id IN NUMBER) IS
3092: SELECT claim_line_util_id
3093: , object_version_number
3094: , currency_code
3095: FROM ozf_claim_lines_util
3096: WHERE claim_line_id = cv_claim_line_id;
3097:
3098: -- Fix for bug 7658894
3099: l_line_util_sum NUMBER :=0;

Line 5067: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util utl

5063: fu.product_id product_id,
5064: utl.amount amount,
5065: utl.acctd_amount acctd_amount,
5066: utl.util_curr_amount util_curr_amount
5067: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util utl
5068: WHERE utl.utilization_id = fu.utilization_id
5069: AND utl.claim_line_id = cv_line_id
5070: AND utl.utilization_id <> -1
5071: UNION ALL

Line 5079: FROM ams_act_products act, ozf_claim_lines_util utl

5075: NVL(act.inventory_item_id, act.category_id) product_id,
5076: utl.amount amount,
5077: utl.acctd_amount acctd_amount,
5078: NVL(utl.util_curr_amount,utl.amount) util_curr_amount
5079: FROM ams_act_products act, ozf_claim_lines_util utl
5080: WHERE utl.activity_product_id = act.activity_product_id
5081: AND utl.claim_line_id = cv_line_id
5082: AND utl.utilization_id = -1)
5083: GROUP BY offer_id,activity_type, product_level_type, product_id;

Line 5100: FROM ozf_claim_lines_util_all

5096:
5097: -- Fix for bug 7658894
5098: CURSOR csr_claim_line_util_sum(cv_claim_line_id IN NUMBER) IS
5099: SELECT sum(amount), sum(acctd_amount)
5100: FROM ozf_claim_lines_util_all
5101: WHERE claim_line_id = cv_claim_line_id;
5102:
5103: CURSOR csr_claim_line_sum(cv_claim_line_id IN NUMBER) IS
5104: SELECT nvl(amount,0), nvl(acctd_amount,0)

Line 5317: UPDATE ozf_claim_lines_util_all

5313:
5314: -- Point the utilizations to the new claim line
5315: IF l_util_product_id IS NULL AND l_util_product_level IS NULL THEN
5316: -- These are adjustment records without product info
5317: UPDATE ozf_claim_lines_util_all
5318: SET claim_line_id = l_claim_line_id
5319: WHERE claim_line_util_id IN ( SELECT util.claim_line_util_id
5320: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util
5321: WHERE fu.utilization_id = util.utilization_id

Line 5320: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util

5316: -- These are adjustment records without product info
5317: UPDATE ozf_claim_lines_util_all
5318: SET claim_line_id = l_claim_line_id
5319: WHERE claim_line_util_id IN ( SELECT util.claim_line_util_id
5320: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util
5321: WHERE fu.utilization_id = util.utilization_id
5322: AND fu.product_id IS NULL
5323: AND util.claim_line_id = p_claim_line_id
5324: AND fu.product_level_type IS NULL

Line 5328: UPDATE ozf_claim_lines_util_all

5324: AND fu.product_level_type IS NULL
5325: AND fu.plan_id = l_offer_id
5326: AND util.utilization_id > -1);
5327: ELSE
5328: UPDATE ozf_claim_lines_util_all
5329: SET claim_line_id = l_claim_line_id
5330: WHERE claim_line_util_id in ( SELECT util.claim_line_util_id
5331: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util
5332: WHERE fu.utilization_id = util.utilization_id

Line 5331: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util

5327: ELSE
5328: UPDATE ozf_claim_lines_util_all
5329: SET claim_line_id = l_claim_line_id
5330: WHERE claim_line_util_id in ( SELECT util.claim_line_util_id
5331: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util
5332: WHERE fu.utilization_id = util.utilization_id
5333: AND fu.product_id = l_util_product_id
5334: AND util.claim_line_id = p_claim_line_id
5335: AND fu.product_level_type = l_util_product_level

Line 5339: UPDATE ozf_claim_lines_util_all

5335: AND fu.product_level_type = l_util_product_level
5336: AND fu.plan_id = l_offer_id
5337: AND util.utilization_id > -1);
5338:
5339: UPDATE ozf_claim_lines_util_all
5340: SET claim_line_id = l_claim_line_id
5341: WHERE claim_line_util_id IN ( SELECT utl.claim_line_util_id
5342: FROM ams_act_products act, ozf_claim_lines_util_all utl
5343: WHERE utl.activity_product_id = act.activity_product_id

Line 5342: FROM ams_act_products act, ozf_claim_lines_util_all utl

5338:
5339: UPDATE ozf_claim_lines_util_all
5340: SET claim_line_id = l_claim_line_id
5341: WHERE claim_line_util_id IN ( SELECT utl.claim_line_util_id
5342: FROM ams_act_products act, ozf_claim_lines_util_all utl
5343: WHERE utl.activity_product_id = act.activity_product_id
5344: AND utl.claim_line_id = p_claim_line_id
5345: AND act.level_type_code = l_util_product_level
5346: AND NVL(act.inventory_item_id, act.category_id) = l_util_product_id