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_FUNDS_UTILIZED_ALL_B

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 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 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