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_CAMPAIGN_SCHEDULES_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 234: FROM ams_campaign_schedules_b acsb

230: l_api_version CONSTANT NUMBER := 1.0;
231:
232: l_sched_stmt_pre VARCHAR2(2000) :=
233: ' SELECT acsb.schedule_id
234: FROM ams_campaign_schedules_b acsb
235: WHERE acsb.status_code = ''ACTIVE''
236: AND acsb.active_flag = ''Y''
237: AND NVL(acsb.start_date_time,SYSDATE) <= SYSDATE
238: AND NVL(acsb.end_date_time,SYSDATE) >= SYSDATE

Line 246: FROM ams_campaign_schedules_b acsb,

242: --BugFix 3537558 Replaced the IN values
243:
244: l_sched_prior_stmt_pre VARCHAR2(2000) :=
245: ' SELECT acsb.schedule_id
246: FROM ams_campaign_schedules_b acsb,
247: ams_lookups LO
248: WHERE acsb.status_code = ''ACTIVE''
249: AND acsb.active_flag = ''Y''
250: AND NVL(acsb.start_date_time,SYSDATE) <= SYSDATE

Line 604: FROM ams_campaign_schedules_b acsb,

600: l_api_version CONSTANT NUMBER := 1.0;
601:
602: l_sched_stmt_pre VARCHAR2(2000) :=
603: ' SELECT acsb.schedule_id
604: FROM ams_campaign_schedules_b acsb,
605: ams_iba_cpn_items_denorm D
606: WHERE acsb.schedule_id = D.object_used_by_id
607: AND acsb.status_code = ''ACTIVE''
608: AND acsb.active_flag = ''Y''

Line 615: FROM ams_campaign_schedules_b acsb,

611: AND D.item_id IN (';
612:
613: l_sched_prior_stmt_pre VARCHAR2(2000) :=
614: ' SELECT acsb.schedule_id
615: FROM ams_campaign_schedules_b acsb,
616: ams_iba_cpn_items_denorm D,
617: ams_lookups LO
618: WHERE acsb.schedule_id = D.object_used_by_id
619: AND acsb.status_code = ''ACTIVE''

Line 989: FROM ams_campaign_schedules_b acsb,

985: l_api_version CONSTANT NUMBER := 1.0;
986:
987: l_sched_stmt_pre VARCHAR2(2000) :=
988: ' SELECT acsb.schedule_id
989: FROM ams_campaign_schedules_b acsb,
990: ams_iba_cpn_items_denorm D
991: WHERE acsb.schedule_id = D.object_used_by_id
992: AND D.object_used_by_type = ''CSCH''
993: AND acsb.status_code = ''ACTIVE''

Line 1001: FROM ams_campaign_schedules_b acsb,

997: AND D.item_id IN (';
998:
999: l_sched_prior_stmt_pre VARCHAR2(2000) :=
1000: ' SELECT acsb.schedule_id
1001: FROM ams_campaign_schedules_b acsb,
1002: ams_iba_cpn_items_denorm D,
1003: ams_lookups LO
1004: WHERE acsb.schedule_id = D.object_used_by_id
1005: AND D.object_used_by_type = ''CSCH''

Line 1438: FROM ozf_act_offers aao,qp_list_headers_b qlhv,ams_campaign_schedules_b csch

1434: x_offers_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
1435:
1436: --fix for SQL Repository issue 11755480
1437: l_offer_stmt VARCHAR2(2500) := 'Select qlhv.list_header_id
1438: FROM ozf_act_offers aao,qp_list_headers_b qlhv,ams_campaign_schedules_b csch
1439: WHERE aao.arc_act_offer_used_by = ''CSCH'' AND aao.qp_list_header_id = qlhv.list_header_id
1440: and aao.qp_list_header_id in (SELECT COLUMN_VALUE FROM TABLE(CAST(:l_in_offer_lst AS JTF_NUMBER_TABLE)) )
1441: AND aao.act_offer_used_by_id = csch.schedule_id
1442: AND qlhv.active_flag =''Y'' AND TRUNC(sysdate) BETWEEN NVL(TRUNC(qlhv.start_date_active),TRUNC(sysdate)-1)

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 1895: FROM ozf_act_offers aao,qp_list_headers_b qlhv,ams_campaign_schedules_b csch

1891: l_bus_prior VARCHAR2(30) := NULL;
1892:
1893: --fix for SQL Repository issue 11755493
1894: l_offer_stmt VARCHAR2(2500) := 'Select qlhv.list_header_id
1895: FROM ozf_act_offers aao,qp_list_headers_b qlhv,ams_campaign_schedules_b csch
1896: WHERE aao.arc_act_offer_used_by = ''CSCH'' AND aao.qp_list_header_id = qlhv.list_header_id
1897: and aao.qp_list_header_id in (SELECT COLUMN_VALUE FROM TABLE(CAST(:l_in_offer_lst AS JTF_NUMBER_TABLE)) )
1898: AND aao.act_offer_used_by_id = csch.schedule_id
1899: AND qlhv.active_flag =''Y'' AND TRUNC(sysdate) BETWEEN NVL(TRUNC(qlhv.start_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'