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_ACTMETRICS_ENGINE_PVT dependencies on AMS_EVENT_OFFERS_ALL_B

Line 2598: FROM ams_event_offers_all_b

2594:
2595: --check for the parent event
2596: CURSOR c_check_parent_event_o(l_act_metric_used_by_id NUMBER) IS
2597: SELECT event_header_id
2598: FROM ams_event_offers_all_b
2599: WHERE event_offer_id = l_act_metric_used_by_id;
2600:
2601: --check for the parent event
2602: -- BUG 3456849: Changed parent to be a program_id.

Line 2630: FROM ams_event_offers_all_b

2626: WHERE schedule_id = l_act_metric_used_by_id;
2627:
2628: CURSOR c_check_parent_one_event(l_act_metric_used_by_id NUMBER) IS
2629: SELECT parent_id
2630: FROM ams_event_offers_all_b
2631: WHERE event_offer_id = l_act_metric_used_by_id
2632: AND parent_type = G_RCAM;
2633: -- END
2634: **/

Line 3668: FROM ams_event_offers_all_b

3664: AND system_status_code = G_CANCELLED;
3665:
3666: CURSOR c_eveo(id NUMBER) IS
3667: SELECT Fnd_Api.G_TRUE
3668: FROM ams_event_offers_all_b
3669: WHERE event_offer_id = id
3670: AND system_status_code IN (G_CANCELLED);
3671: **/
3672: l_is_canceled VARCHAR2(1) := Fnd_Api.G_FALSE;

Line 4241: FROM ams_event_offers_all_b

4237: decode(parent_type,null,G_EVEH,parent_type) parent_type,
4238: decode(parent_type,null, event_header_id, parent_id) parent_id,
4239: decode(system_status_code, G_CANCELLED, Fnd_Api.G_TRUE, Fnd_Api.G_FALSE) cancelled_flag,
4240: G_SHOW
4241: FROM ams_event_offers_all_b
4242: WHERE event_offer_id = l_act_metric_used_by_id;
4243:
4244: CURSOR c_check_deliverable(l_act_metric_used_by_id NUMBER)
4245: return object_detail_type IS

Line 4406: FROM ams_event_offers_all_b

4402: FROM ams_event_headers_all_b
4403: WHERE PROGRAM_ID = l_act_metric_used_by_id
4404: UNION ALL
4405: SELECT EVENT_OFFER_ID obj_id, G_EONE obj_type, CURRENCY_CODE_TC currency
4406: FROM ams_event_offers_all_b
4407: WHERE parent_id = l_act_metric_used_by_id
4408: ORDER BY obj_type, obj_id;
4409:
4410: CURSOR c_get_campaign_family (l_act_metric_used_by_id number) IS

Line 4437: FROM ams_event_offers_all_b

4433: FROM ams_event_headers_all_b
4434: WHERE EVENT_HEADER_ID = l_act_metric_used_by_id
4435: UNION ALL
4436: SELECT EVENT_OFFER_ID obj_id, G_EVEO obj_type, CURRENCY_CODE_TC currency
4437: FROM ams_event_offers_all_b
4438: WHERE EVENT_HEADER_ID = l_act_metric_used_by_id
4439: ORDER BY obj_type, obj_id;
4440:
4441: CURSOR c_get_csch_family (l_act_metric_used_by_id number) IS

Line 4457: FROM ams_event_offers_all_b

4453: ORDER BY obj_type, obj_id;
4454:
4455: CURSOR c_get_eveo_family (l_act_metric_used_by_id number) IS
4456: SELECT EVENT_OFFER_ID obj_id, G_EVEO obj_type, CURRENCY_CODE_TC currency
4457: FROM ams_event_offers_all_b
4458: WHERE EVENT_OFFER_ID = l_act_metric_used_by_id
4459: UNION ALL
4460: SELECT EVENT_HEADER_ID obj_id, G_EVEH obj_type, CURRENCY_CODE_TC currency
4461: FROM ams_event_headers_all_b

Line 4462: WHERE EVENT_HEADER_ID = (SELECT event_header_id FROM ams_event_offers_all_b

4458: WHERE EVENT_OFFER_ID = l_act_metric_used_by_id
4459: UNION ALL
4460: SELECT EVENT_HEADER_ID obj_id, G_EVEH obj_type, CURRENCY_CODE_TC currency
4461: FROM ams_event_headers_all_b
4462: WHERE EVENT_HEADER_ID = (SELECT event_header_id FROM ams_event_offers_all_b
4463: WHERE event_offer_id = l_act_metric_used_by_id)
4464: UNION ALL
4465: SELECT campaign_id obj_id, G_RCAM obj_type, TRANSACTION_CURRENCY_CODE currency
4466: FROM ams_campaigns_all_b

Line 4468: WHERE event_header_id = (SELECT event_header_id FROM ams_event_offers_all_b

4464: UNION ALL
4465: SELECT campaign_id obj_id, G_RCAM obj_type, TRANSACTION_CURRENCY_CODE currency
4466: FROM ams_campaigns_all_b
4467: START WITH campaign_id = (SELECT PROGRAM_ID FROM ams_event_headers_all_b
4468: WHERE event_header_id = (SELECT event_header_id FROM ams_event_offers_all_b
4469: WHERE event_offer_id = l_act_metric_used_by_id))
4470: CONNECT BY campaign_id = PRIOR PARENT_CAMPAIGN_ID
4471: ORDER BY obj_type, obj_id;
4472:

Line 4477: START WITH campaign_id = (SELECT PARENT_ID FROM ams_event_offers_all_b

4473: CURSOR c_get_eone_family (l_act_metric_used_by_id number) IS
4474: SELECT campaign_id obj_id, G_RCAM obj_type,
4475: TRANSACTION_CURRENCY_CODE currency
4476: FROM ams_campaigns_all_b
4477: START WITH campaign_id = (SELECT PARENT_ID FROM ams_event_offers_all_b
4478: WHERE event_offer_id = l_act_metric_used_by_id)
4479: CONNECT BY campaign_id = PRIOR PARENT_CAMPAIGN_ID
4480: UNION ALL
4481: SELECT event_offer_id obj_id, G_EONE obj_type, CURRENCY_CODE_TC currency

Line 4482: FROM ams_event_offers_all_b

4478: WHERE event_offer_id = l_act_metric_used_by_id)
4479: CONNECT BY campaign_id = PRIOR PARENT_CAMPAIGN_ID
4480: UNION ALL
4481: SELECT event_offer_id obj_id, G_EONE obj_type, CURRENCY_CODE_TC currency
4482: FROM ams_event_offers_all_b
4483: WHERE event_offer_id = l_act_metric_used_by_id
4484: ORDER BY obj_type, obj_id;
4485:
4486: CURSOR c_get_deliv (p_deliverable_id NUMBER) IS

Line 4683: SELECT event_offer_id INTO l_eveo_id FROM ams_event_offers_all_b

4679: write_object_list(l_object_list,l_output);
4680: p_output := p_output || l_output;
4681: l_object_list.delete;
4682:
4683: SELECT event_offer_id INTO l_eveo_id FROM ams_event_offers_all_b
4684: WHERE event_header_id IS NOT NULL
4685: AND ROWNUM = 1;
4686: Get_Object_List(G_EVEO,l_eveo_id,
4687: l_return_status, l_msg_count, l_msg_data, l_object_list);

Line 4694: SELECT event_offer_id INTO l_eone_id FROM ams_event_offers_all_b

4690: write_object_list(l_object_list,l_output);
4691: p_output := p_output || l_output;
4692: l_object_list.delete;
4693:
4694: SELECT event_offer_id INTO l_eone_id FROM ams_event_offers_all_b
4695: WHERE PARENT_ID IS NOT NULL
4696: AND ROWNUM = 1;
4697: Get_Object_List(G_EONE,l_eone_id,
4698: l_return_status, l_msg_count, l_msg_data, l_object_list);