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 5500: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util utl

5496: fu.product_id product_id,
5497: utl.amount amount,
5498: utl.acctd_amount acctd_amount,
5499: utl.util_curr_amount util_curr_amount
5500: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util utl
5501: WHERE utl.utilization_id = fu.utilization_id
5502: AND utl.claim_line_id = cv_line_id
5503: AND utl.utilization_id <> -1
5504: UNION ALL

Line 5753: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util

5749: -- These are adjustment records without product info
5750: UPDATE ozf_claim_lines_util_all
5751: SET claim_line_id = l_claim_line_id
5752: WHERE claim_line_util_id IN ( SELECT util.claim_line_util_id
5753: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util
5754: WHERE fu.utilization_id = util.utilization_id
5755: AND fu.product_id IS NULL
5756: AND util.claim_line_id = p_claim_line_id
5757: AND fu.product_level_type IS NULL

Line 5764: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util

5760: ELSE
5761: UPDATE ozf_claim_lines_util_all
5762: SET claim_line_id = l_claim_line_id
5763: WHERE claim_line_util_id in ( SELECT util.claim_line_util_id
5764: FROM ozf_funds_utilized_all_b fu, ozf_claim_lines_util_all util
5765: WHERE fu.utilization_id = util.utilization_id
5766: AND fu.product_id = l_util_product_id
5767: AND util.claim_line_id = p_claim_line_id
5768: AND fu.product_level_type = l_util_product_level