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 AMS_ACT_PRODUCTS

Line 5512: FROM ams_act_products act, ozf_claim_lines_util utl

5508: NVL(act.inventory_item_id, act.category_id) product_id,
5509: utl.amount amount,
5510: utl.acctd_amount acctd_amount,
5511: NVL(utl.util_curr_amount,utl.amount) util_curr_amount
5512: FROM ams_act_products act, ozf_claim_lines_util utl
5513: WHERE utl.activity_product_id = act.activity_product_id
5514: AND utl.claim_line_id = cv_line_id
5515: AND utl.utilization_id = -1)
5516: GROUP BY offer_id,activity_type, product_level_type, product_id;

Line 5775: FROM ams_act_products act, ozf_claim_lines_util_all utl

5771:
5772: UPDATE ozf_claim_lines_util_all
5773: SET claim_line_id = l_claim_line_id
5774: WHERE claim_line_util_id IN ( SELECT utl.claim_line_util_id
5775: FROM ams_act_products act, ozf_claim_lines_util_all utl
5776: WHERE utl.activity_product_id = act.activity_product_id
5777: AND utl.claim_line_id = p_claim_line_id
5778: AND act.level_type_code = l_util_product_level
5779: AND NVL(act.inventory_item_id, act.category_id) = l_util_product_id