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 OZF_OFFERS

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 293: FROM OZF_OFFERS obj, qp_list_headers_b g

289: , obj.CREATION_DATE
290: , obj.LAST_UPDATED_BY
291: , obj.LAST_UPDATE_DATE
292: , obj.LAST_UPDATE_LOGIN
293: FROM OZF_OFFERS obj, qp_list_headers_b g
294: WHERE (obj.CUSTOM_SETUP_ID = DECODE(x_criteria_rec.CUSTOM_SETUP_ID, NULL, obj.CUSTOM_SETUP_ID, x_criteria_rec.CUSTOM_SETUP_ID)
295: AND obj.OFFER_TYPE = DECODE(x_criteria_rec.ACTIVITY_TYPE_CODE, NULL, obj.OFFER_TYPE, x_criteria_rec.ACTIVITY_TYPE_CODE)
296: AND obj.USER_STATUS_ID = DECODE(x_criteria_rec.STATUS_ID, NULL, obj.USER_STATUS_ID, x_criteria_rec.STATUS_ID)
297: AND obj.QP_LIST_HEADER_ID = DECODE(x_criteria_rec.OBJECT_ID, NULL, obj.QP_LIST_HEADER_ID, x_criteria_rec.OBJECT_ID)

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 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 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)