APPS.OZF_SPECIAL_PRICING_PVT dependencies on OZF_CLAIM_LINES_UTIL_ALL

Line 1051: ozf_claim_lines_util_all l,

1047: p_product_id NUMBER) IS
1048: SELECT sum(l.scan_unit) * a.quantity quantity_remaining,
1049: a.uom_code
1050: FROM ozf_funds_utilized_all_b u,
1051: ozf_claim_lines_util_all l,
1052: ams_act_products a
1053: WHERE u.utilization_id = l.utilization_id
1054: AND u.activity_product_id = a.activity_product_id
1055: AND u.plan_type = 'OFFR'