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.AMS_RUNTIME_CAMP_PVT dependencies on AMS_CAMPAIGNS_ALL_B

Line 122: FROM ozf_act_offers aao,qp_list_headers_b qlhv,ams_campaign_schedules_b csch,ams_campaigns_all_b camp

118: IS
119:
120: CURSOR c_act_offer(l_activity_id NUMBER) IS
121: SELECT aao.activity_offer_id,aao.qp_list_header_id,aao.act_offer_used_by_id
122: FROM ozf_act_offers aao,qp_list_headers_b qlhv,ams_campaign_schedules_b csch,ams_campaigns_all_b camp
123: WHERE aao.arc_act_offer_used_by = 'CSCH' AND aao.qp_list_header_id = qlhv.list_header_id
124: AND aao.act_offer_used_by_id = csch.schedule_id AND camp.campaign_id = csch.campaign_id
125: AND qlhv.active_flag = 'Y' AND TRUNC(sysdate) BETWEEN NVL(TRUNC(qlhv.start_date_active),TRUNC(sysdate)-1) and NVL(TRUNC(qlhv.end_date_active),trunc(sysdate)+1)
126: AND qlhv.ask_for_flag= 'Y' AND csch.status_code= 'ACTIVE' AND csch.activity_id=40 AND aao.activity_offer_id = l_activity_id;

Line 1448: --FROM ozf_act_offers aao,qp_list_headers_b qlhv,ams_campaign_schedules_b csch,ams_campaigns_all_b camp

1444: AND qlhv.ask_for_flag = ''Y'' AND csch.status_code = ''ACTIVE'' AND csch.activity_id=40';
1445:
1446:
1447: --'Select qlhv.list_header_id
1448: --FROM ozf_act_offers aao,qp_list_headers_b qlhv,ams_campaign_schedules_b csch,ams_campaigns_all_b camp
1449: --WHERE aao.arc_act_offer_used_by = ''CSCH'' AND aao.qp_list_header_id = qlhv.list_header_id
1450: --AND aao.act_offer_used_by_id = csch.schedule_id AND camp.campaign_id = csch.campaign_id
1451: --AND qlhv.active_flag =''Y'' AND TRUNC(sysdate) BETWEEN NVL(TRUNC(qlhv.start_date_active),TRUNC(sysdate)-1)
1452: --and NVL(TRUNC(qlhv.end_date_active),trunc(sysdate)+1)

Line 1905: --FROM ozf_act_offers aao,qp_list_headers_b qlhv,ams_campaign_schedules_b csch,ams_campaigns_all_b camp

1901: AND qlhv.ask_for_flag = ''Y'' AND csch.status_code = ''ACTIVE'' AND csch.activity_id=40';
1902:
1903:
1904: --'Select qlhv.list_header_id
1905: --FROM ozf_act_offers aao,qp_list_headers_b qlhv,ams_campaign_schedules_b csch,ams_campaigns_all_b camp
1906: --WHERE aao.arc_act_offer_used_by = ''CSCH'' AND aao.qp_list_header_id = qlhv.list_header_id
1907: --AND aao.act_offer_used_by_id = csch.schedule_id AND camp.campaign_id = csch.campaign_id
1908: --AND qlhv.active_flag = ''Y'' AND TRUNC(sysdate) BETWEEN NVL(TRUNC(qlhv.start_date_active),TRUNC(sysdate)-1) and NVL(TRUNC(qlhv.end_date_active),trunc(sysdate)+1)
1909: --AND qlhv.ask_for_flag = ''Y'' AND csch.status_code = ''ACTIVE'' AND csch.activity_id=40

Line 1916: FROM ozf_act_offers aao,qp_list_headers_b qlhv,ams_campaign_schedules_b csch,ams_campaigns_all_b camp

1912: -- BugFix 3684266 Replaced IN clause
1913:
1914: CURSOR c_act_qp_offer(l_qp_list_header_id NUMBER) IS
1915: select aao.activity_offer_id,qlhv.list_header_id
1916: FROM ozf_act_offers aao,qp_list_headers_b qlhv,ams_campaign_schedules_b csch,ams_campaigns_all_b camp
1917: WHERE aao.arc_act_offer_used_by = 'CSCH' AND aao.qp_list_header_id = qlhv.list_header_id
1918: AND aao.act_offer_used_by_id = csch.schedule_id AND camp.campaign_id = csch.campaign_id
1919: AND qlhv.active_flag = 'Y' AND TRUNC(sysdate) BETWEEN NVL(TRUNC(qlhv.start_date_active),TRUNC(sysdate)-1) and NVL(TRUNC(qlhv.end_date_active),trunc(sysdate)+1)
1920: AND qlhv.ask_for_flag= 'Y' AND csch.status_code= 'ACTIVE'

Line 2306: FROM ozf_act_offers aao,qp_list_headers_b qlhv,ams_campaign_schedules_b csch,ams_campaigns_all_b camp

2302: --l_offer_tbl AMS_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
2303: l_prod_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
2304: l_offer_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
2305: l_offer_stmt VARCHAR2(2000) := 'SELECT qlhv.list_header_id
2306: FROM ozf_act_offers aao,qp_list_headers_b qlhv,ams_campaign_schedules_b csch,ams_campaigns_all_b camp
2307: WHERE aao.arc_act_offer_used_by = ''CSCH'' AND aao.qp_list_header_id = qlhv.list_header_id
2308: AND aao.act_offer_used_by_id = csch.schedule_id AND camp.campaign_id = csch.campaign_id
2309: AND qlhv.active_flag = ''Y'' AND TRUNC(sysdate) BETWEEN NVL(TRUNC(qlhv.start_date_active),TRUNC(sysdate)-1) and NVL(TRUNC(qlhv.end_date_active),trunc(sysdate)+1)
2310: AND qlhv.ask_for_flag= ''Y'' AND csch.status_code= ''ACTIVE'' AND csch.activity_id=40

Line 2315: FROM ozf_act_offers aao,qp_list_headers_b qlhv,ams_campaign_schedules_b csch,ams_campaigns_all_b camp

2311: AND qlhv.list_header_id IN (';
2312:
2313: CURSOR c_act_qp_offer(l_qp_list_header_id NUMBER) IS
2314: SELECT aao.activity_offer_id,qlhv.list_header_id
2315: FROM ozf_act_offers aao,qp_list_headers_b qlhv,ams_campaign_schedules_b csch,ams_campaigns_all_b camp
2316: WHERE aao.arc_act_offer_used_by = 'CSCH' AND aao.qp_list_header_id = qlhv.list_header_id
2317: AND aao.act_offer_used_by_id = csch.schedule_id AND camp.campaign_id = csch.campaign_id
2318: AND qlhv.active_flag = 'Y' AND TRUNC(sysdate) BETWEEN NVL(TRUNC(qlhv.start_date_active),TRUNC(sysdate)-1) and NVL(TRUNC(qlhv.end_date_active),trunc(sysdate)+1)
2319: AND qlhv.ask_for_flag= 'Y' AND qlhv.source_system_code = 'AMS' AND csch.status_code= 'ACTIVE'