DBA Data[Home] [Help]

APPS.OZF_CLAIM_LINE_PVT dependencies on AMS_ACT_PRODUCTS

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