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_SYNC_CALENDAR_PVT dependencies on JTF_CAL_ITEMS_B

Line 21: FROM AMS_CAMPAIGN_SCHEDULES_B obj, AMS_CAMPAIGNS_ALL_B b, JTF_CAL_ITEMS_B cal

17: )
18: IS
19: CURSOR c_get_delete_csch_ids (x_criteria_rec cal_criteria_rec) IS
20: SELECT obj.SCHEDULE_ID
21: FROM AMS_CAMPAIGN_SCHEDULES_B obj, AMS_CAMPAIGNS_ALL_B b, JTF_CAL_ITEMS_B cal
22: WHERE (obj.CUSTOM_SETUP_ID = DECODE(x_criteria_rec.CUSTOM_SETUP_ID, NULL, obj.CUSTOM_SETUP_ID, x_criteria_rec.CUSTOM_SETUP_ID)
23: AND obj.schedule_id = cal.source_id
24: AND cal.source_code = 'AMS_CSCH'
25: AND obj.ACTIVITY_TYPE_CODE = DECODE(x_criteria_rec.ACTIVITY_TYPE_CODE, NULL, obj.ACTIVITY_TYPE_CODE, x_criteria_rec.ACTIVITY_TYPE_CODE)

Line 49: FROM ams_event_offers_all_b obj, jtf_cal_items_b cal

45: --BugFix 4256877 ams_event_offers_vl to ams_event_offers_all_b
46:
47: CURSOR c_get_delete_eveo_ids (x_criteria_rec cal_criteria_rec) IS
48: SELECT obj.EVENT_OFFER_ID
49: FROM ams_event_offers_all_b obj, jtf_cal_items_b cal
50: WHERE (obj.SETUP_TYPE_ID = DECODE(x_criteria_rec.CUSTOM_SETUP_ID, NULL, obj.SETUP_TYPE_ID, x_criteria_rec.CUSTOM_SETUP_ID)
51: AND obj.event_offer_id = cal.source_id
52: AND (cal.source_code = 'AMS_EVEO' or cal.source_code = 'AMS_EONE')
53: AND obj.EVENT_TYPE_CODE = DECODE(x_criteria_rec.ACTIVITY_TYPE_CODE, NULL, obj.EVENT_TYPE_CODE, x_criteria_rec.ACTIVITY_TYPE_CODE)

Line 76: FROM OZF_OFFERS obj, qp_list_headers_b g, jtf_cal_items_b cal

72: --BugFix 4256877 qp_list_headers_vl to qp_list_headers_b
73:
74: CURSOR c_get_delete_offr_ids (x_criteria_rec cal_criteria_rec) IS
75: SELECT obj.QP_LIST_HEADER_ID
76: FROM OZF_OFFERS obj, qp_list_headers_b g, jtf_cal_items_b cal
77: WHERE (obj.CUSTOM_SETUP_ID = DECODE(x_criteria_rec.CUSTOM_SETUP_ID, NULL, obj.CUSTOM_SETUP_ID, x_criteria_rec.CUSTOM_SETUP_ID)
78: AND obj.QP_LIST_HEADER_ID = cal.source_id
79: AND cal.source_code = 'AMS_OFFR'
80: AND obj.OFFER_TYPE = DECODE(x_criteria_rec.ACTIVITY_TYPE_CODE, NULL, obj.OFFER_TYPE, x_criteria_rec.ACTIVITY_TYPE_CODE)

Line 231: FROM JTF_CAL_ITEMS_B cal

227: AND b.ACTUAL_EXEC_END_DATE IS NOT NULL
228: AND obj.START_DATE_TIME <= nvl(obj.END_DATE_TIME, b.actual_exec_end_date)
229: AND obj.TIMEZONE_ID IS NOT NULL
230: AND NOT EXISTS ( SELECT 1
231: FROM JTF_CAL_ITEMS_B cal
232: WHERE cal.source_code = 'AMS_CSCH' --obj_type
233: AND cal.source_id = obj.SCHEDULE_ID
234: )
235: AND (

Line 272: FROM JTF_CAL_ITEMS_B cal

268: AND obj.EVENT_START_DATE_TIME <= obj.EVENT_END_DATE_TIME
269: AND obj.TIMEZONE_ID IS NOT NULL
270: AND (obj.EVENT_OBJECT_TYPE = 'EVEO' OR (obj.EVENT_OBJECT_TYPE = 'EONE' AND (obj.parent_type is NULL OR obj.parent_type <>'CAMP')))
271: AND NOT EXISTS ( SELECT 1
272: FROM JTF_CAL_ITEMS_B cal
273: WHERE ( (cal.source_code = 'AMS_EVEO') OR (cal.source_code = 'AMS_EONE') ) --obj_type
274: AND cal.source_id = obj.EVENT_OFFER_ID
275: )
276: AND (

Line 308: FROM JTF_CAL_ITEMS_B cal

304: (TRUNC(nvl(g.START_DATE_ACTIVE, obj.CREATION_DATE)) >= DECODE(x_criteria_rec.CRITERIA_START_DATE, NULL, TRUNC(nvl(g.START_DATE_ACTIVE, obj.CREATION_DATE)), TRUNC(x_criteria_rec.CRITERIA_START_DATE)))
305: AND (TRUNC(nvl(g.END_DATE_ACTIVE, add_months(SYSDATE, 60))) <= DECODE(x_criteria_rec.CRITERIA_END_DATE, NULL, TRUNC(nvl(g.END_DATE_ACTIVE, add_months(SYSDATE, 60))), TRUNC(x_criteria_rec.CRITERIA_END_DATE)))
306: )
307: AND NOT EXISTS ( SELECT 1
308: FROM JTF_CAL_ITEMS_B cal
309: WHERE cal.source_code = 'AMS_OFFR' --obj_type
310: AND cal.source_id = obj.QP_LIST_HEADER_ID
311: )
312: );

Line 517: FROM AMS_CAMPAIGN_SCHEDULES_B obj, AMS_CAMPAIGNS_ALL_B b, JTF_CAL_ITEMS_B cal

513: , obj.CREATION_DATE
514: , obj.LAST_UPDATED_BY
515: , obj.LAST_UPDATE_DATE
516: , obj.LAST_UPDATE_LOGIN
517: FROM AMS_CAMPAIGN_SCHEDULES_B obj, AMS_CAMPAIGNS_ALL_B b, JTF_CAL_ITEMS_B cal
518: WHERE (obj.CUSTOM_SETUP_ID = DECODE(x_criteria_rec.CUSTOM_SETUP_ID, NULL, obj.CUSTOM_SETUP_ID, x_criteria_rec.CUSTOM_SETUP_ID)
519: AND cal.source_code = 'AMS_CSCH'
520: AND cal.source_id = obj.SCHEDULE_ID
521: AND ( cal.start_date <> obj.START_DATE_TIME

Line 558: FROM ams_event_offers_all_b obj, JTF_CAL_ITEMS_B cal

554: , obj.CREATION_DATE
555: , obj.LAST_UPDATED_BY
556: , obj.LAST_UPDATE_DATE
557: , obj.LAST_UPDATE_LOGIN
558: FROM ams_event_offers_all_b obj, JTF_CAL_ITEMS_B cal
559: WHERE (obj.SETUP_TYPE_ID = DECODE(x_criteria_rec.CUSTOM_SETUP_ID, NULL, obj.SETUP_TYPE_ID, x_criteria_rec.CUSTOM_SETUP_ID)
560: AND (cal.source_code = 'AMS_EVEO' OR cal.source_code = 'AMS_EONE')
561: AND cal.source_id = obj.EVENT_OFFER_ID
562: AND ( cal.start_date <> obj.EVENT_START_DATE_TIME

Line 597: FROM OZF_OFFERS obj , qp_list_headers_b g, JTF_CAL_ITEMS_B cal

593: , obj.CREATION_DATE
594: , obj.LAST_UPDATED_BY
595: , obj.LAST_UPDATE_DATE
596: , obj.LAST_UPDATE_LOGIN
597: FROM OZF_OFFERS obj , qp_list_headers_b g, JTF_CAL_ITEMS_B cal
598: WHERE (obj.CUSTOM_SETUP_ID = DECODE(x_criteria_rec.CUSTOM_SETUP_ID, NULL, obj.CUSTOM_SETUP_ID, x_criteria_rec.CUSTOM_SETUP_ID)
599: AND cal.source_code = 'AMS_OFFR'
600: AND cal.source_id = obj.QP_LIST_HEADER_ID
601: AND ( cal.start_date <> nvl(g.START_DATE_ACTIVE, obj.CREATION_DATE)

Line 625: FROM JTF_CAL_ITEMS_B jcal, ams_campaign_schedules_b camp

621: l_cal_obj_ver_number NUMBER;
622: --BugFix 4676786 sikalyan
623: CURSOR c_get_cal_item_id (l_source_id NUMBER, l_resource_id NUMBER) IS
624: SELECT cal_item_id, resource_id, source_id, jcal.object_version_number
625: FROM JTF_CAL_ITEMS_B jcal, ams_campaign_schedules_b camp
626: where camp.schedule_id = jcal.source_id and jcal.source_id = l_source_id and jcal.resource_id = l_resource_id ;
627:
628: l_get_cal_item_rec c_get_cal_item_id%ROWTYPE;
629:

Line 632: FROM JTF_CAL_ITEMS_B jcal, ams_event_offers_all_b aevent

628: l_get_cal_item_rec c_get_cal_item_id%ROWTYPE;
629:
630: CURSOR c_get_e_cal_item_id (l_source_id NUMBER, l_resource_id NUMBER) IS
631: SELECT cal_item_id, resource_id, source_id, jcal.object_version_number
632: FROM JTF_CAL_ITEMS_B jcal, ams_event_offers_all_b aevent
633: where aevent.event_offer_id = jcal.source_id and jcal.source_id = l_source_id and jcal.resource_id = l_resource_id ;
634:
635: l_get_e_cal_item_rec c_get_e_cal_item_id%ROWTYPE;
636:

Line 639: FROM JTF_CAL_ITEMS_B jcal, ozf_offers qlh

635: l_get_e_cal_item_rec c_get_e_cal_item_id%ROWTYPE;
636:
637: CURSOR c_get_o_cal_item_id (l_source_id NUMBER, l_resource_id NUMBER) IS
638: SELECT cal_item_id, resource_id, source_id, jcal.object_version_number
639: FROM JTF_CAL_ITEMS_B jcal, ozf_offers qlh
640: where qlh.qp_list_header_id = jcal.source_id and jcal.source_id = l_source_id and jcal.resource_id = l_resource_id ;
641:
642: l_get_o_cal_item_rec c_get_o_cal_item_id%ROWTYPE;
643:

Line 870: FROM JTF_CAL_ITEMS_B cal

866: --------------------------------------------------------------------------------------------------------------------------------------
867: CURSOR c_get_del_item (x_obj_id NUMBER) IS
868: SELECT cal.cal_item_id
869: ,cal.object_version_number
870: FROM JTF_CAL_ITEMS_B cal
871: WHERE (cal.SOURCE_ID = x_obj_id);
872: l_get_del_item_rec c_get_del_item%ROWTYPE;
873: --------------------------------------------------------------------------------------------------------------------------------------
874:

Line 878: FROM AMS_CAMPAIGN_SCHEDULES_B obj, JTF_CAL_ITEMS_B cal, AMS_CAMPAIGNS_ALL_B b

874:
875: CURSOR c_get_del_csch_items (x_criteria_rec cal_criteria_rec) IS
876: SELECT cal.cal_item_id
877: , cal.object_version_number
878: FROM AMS_CAMPAIGN_SCHEDULES_B obj, JTF_CAL_ITEMS_B cal, AMS_CAMPAIGNS_ALL_B b
879: WHERE (obj.CUSTOM_SETUP_ID = DECODE(x_criteria_rec.CUSTOM_SETUP_ID, NULL, obj.CUSTOM_SETUP_ID, x_criteria_rec.CUSTOM_SETUP_ID)
880: AND obj.ACTIVITY_TYPE_CODE = DECODE(x_criteria_rec.ACTIVITY_TYPE_CODE, NULL, obj.ACTIVITY_TYPE_CODE, x_criteria_rec.ACTIVITY_TYPE_CODE)
881: AND DECODE(x_criteria_rec.ACTIVITY_ID,NULL,-9999,obj.ACTIVITY_ID) = DECODE(x_criteria_rec.ACTIVITY_ID, NULL, -9999, x_criteria_rec.ACTIVITY_ID)
882: AND obj.USER_STATUS_ID = DECODE(x_criteria_rec.STATUS_ID, NULL, obj.USER_STATUS_ID, x_criteria_rec.STATUS_ID)

Line 903: FROM ams_event_offers_all_b obj, JTF_CAL_ITEMS_B cal

899:
900: CURSOR c_get_del_eveo_items (x_criteria_rec cal_criteria_rec) IS
901: SELECT cal.cal_item_id
902: , cal.object_version_number
903: FROM ams_event_offers_all_b obj, JTF_CAL_ITEMS_B cal
904: WHERE (obj.SETUP_TYPE_ID = DECODE(x_criteria_rec.CUSTOM_SETUP_ID, NULL, obj.SETUP_TYPE_ID, x_criteria_rec.CUSTOM_SETUP_ID)
905: AND obj.EVENT_TYPE_CODE = DECODE(x_criteria_rec.ACTIVITY_TYPE_CODE, NULL, obj.EVENT_TYPE_CODE, x_criteria_rec.ACTIVITY_TYPE_CODE)
906: AND obj.USER_STATUS_ID = DECODE(x_criteria_rec.STATUS_ID, NULL, obj.USER_STATUS_ID, x_criteria_rec.STATUS_ID)
907: AND obj.EVENT_OFFER_ID = DECODE(x_criteria_rec.OBJECT_ID, NULL, obj.EVENT_OFFER_ID, x_criteria_rec.OBJECT_ID)

Line 925: FROM OZF_OFFERS obj, JTF_CAL_ITEMS_B cal, qp_list_headers_vl g

921:
922: CURSOR c_get_del_offr_items (x_criteria_rec cal_criteria_rec) IS
923: SELECT cal.cal_item_id
924: , cal.object_version_number
925: FROM OZF_OFFERS obj, JTF_CAL_ITEMS_B cal, qp_list_headers_vl g
926: WHERE (obj.CUSTOM_SETUP_ID = DECODE(x_criteria_rec.CUSTOM_SETUP_ID, NULL, obj.CUSTOM_SETUP_ID, x_criteria_rec.CUSTOM_SETUP_ID)
927: AND obj.OFFER_TYPE = DECODE(x_criteria_rec.ACTIVITY_TYPE_CODE, NULL, obj.OFFER_TYPE, x_criteria_rec.ACTIVITY_TYPE_CODE)
928: AND obj.USER_STATUS_ID = DECODE(x_criteria_rec.STATUS_ID, NULL, obj.USER_STATUS_ID, x_criteria_rec.STATUS_ID)
929: AND obj.QP_LIST_HEADER_ID = DECODE(x_criteria_rec.OBJECT_ID, NULL, obj.QP_LIST_HEADER_ID, x_criteria_rec.OBJECT_ID)