APPS.AMS_ACTMETRICS_SEED_PVT dependencies on AMS_EVENT_REGISTRATIONS

Line 921: from ams_event_registrations r,

917: select sum(decode(system_status_code,'REGISTERED',1,0)) registered,
918: sum(decode(system_status_code||':'||attended_flag,'REGISTERED:Y',1,0)) attendee,
919: sum(decode(system_status_code,'CANCELLED',1,0)) cancelled,
920: object_id, object_type
921: from ams_event_registrations r,
922: (select distinct act_metric_used_by_id event_offer_id,
923: act_metric_used_by_id object_id,
924: arc_act_metric_used_by object_type
925: from ams_act_metrics_all a, ams_metrics_all_b b

Line 1475: from ams_event_registrations r,

1471: select sum(decode(system_status_code,'REGISTERED',1,0)) registered,
1472: sum(decode(system_status_code||':'||attended_flag,'REGISTERED:Y',1,0)) attendee,
1473: sum(decode(system_status_code,'CANCELLED',1,0)) cancelled,
1474: object_id, object_type
1475: from ams_event_registrations r,
1476: (select distinct related_event_id event_offer_id,
1477: act_metric_used_by_id object_id,
1478: arc_act_metric_used_by object_type
1479: from ams_act_metrics_all a, ams_metrics_all_b b, ams_campaign_schedules_b c

Line 1523: from ams_event_registrations r,

1519: select sum(decode(system_status_code,'REGISTERED',1,0)) registered,
1520: sum(decode(system_status_code||':'||attended_flag,'REGISTERED:Y',1,0)) attendee,
1521: sum(decode(system_status_code,'CANCELLED',1,0)) cancelled,
1522: object_id, object_type
1523: from ams_event_registrations r,
1524: (select distinct act_metric_used_by_id event_offer_id,
1525: act_metric_used_by_id object_id,
1526: arc_act_metric_used_by object_type
1527: from ams_act_metrics_all a, ams_metrics_all_b b