DBA Data[Home] [Help]

APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on AMS_CAMPAIGNS_VL

Line 2334: ams_campaigns_vl ct,

2330: o.fund_request_curr_code curr_code
2331: FROM ozf_offers o,
2332: qp_list_headers l,
2333: ozf_act_offers ao,
2334: ams_campaigns_vl ct,
2335: ozf_act_forecasts_all af
2336: WHERE o.qp_list_header_id = NVL(p_offer_id,o.qp_list_header_id)
2337: and o.qp_list_header_id = l.list_header_id
2338: and ao.qp_list_header_id(+) = decode(o.reusable,'N', o.qp_list_header_id)