APPS.BIM_EVENT_FACTS dependencies on AMS_EVENT_REGISTRATIONS

Line 1063: FROM ams_event_registrations A

1059: trunc(A.last_reg_status_date) creation_date,
1060: SUM(decode(A.system_status_code,'REGISTERED',1,'CANCELLED',1,0)) registered,
1061: SUM(decode(A.system_status_code,'CANCELLED',1,0)) cancelled,
1062: SUM(decode(A.system_status_code,'REGISTERED',decode(attended_flag,'Y',1,0),0)) attended
1063: FROM ams_event_registrations A
1064: GROUP BY A.event_offer_id,
1065: TRUNC(A.last_reg_status_date)
1066: )OH,
1067: ( SELECT

Line 1816: FROM ams_event_registrations A

1812: ,0 actual_revenue
1813: ,0 forecasted_revenue
1814: ,0 booked_orders
1815: ,0 booked_orders_amt
1816: FROM ams_event_registrations A
1817: WHERE trunc(A.last_reg_status_date) between p_start_datel and p_end_datel + 0.9999
1818: GROUP BY A.event_offer_id,trunc(A.last_reg_status_date))
1819: UNION ALL
1820: (SELECT

Line 1903: FROM ams_event_registrations

1899:
1900: BEGIN
1901: SELECT min(last_reg_status_date)
1902: INTO l_min_date
1903: FROM ams_event_registrations
1904: WHERE event_offer_id = y.event_offer_id;
1905: EXCEPTION
1906: WHEN OTHERS THEN
1907: NULL;

Line 2038: FROM ams_event_registrations A

2034: trunc(a.last_reg_status_date) transaction_create_date,
2035: SUM(decode(A.system_status_code,'REGISTERED',1,'CANCELLED',1,0)) registered,
2036: SUM(decode(A.system_status_code,'CANCELLED',1,0)) cancelled,
2037: SUM(decode(A.system_status_code,'REGISTERED',decode(attended_flag,'Y',1,0),0)) attended
2038: FROM ams_event_registrations A
2039: WHERE a.last_reg_status_date between trunc(l_min_date) and trunc(y.event_start_date)-1 +0.9999
2040: AND y.event_start_date >= p_start_datel
2041: AND y.event_start_date <= p_end_datel
2042: AND a.event_offer_id = y.event_offer_id

Line 2090: FROM ams_event_registrations

2086:
2087: BEGIN
2088: SELECT min(last_reg_status_date)
2089: INTO l_min_date
2090: FROM ams_event_registrations
2091: WHERE event_offer_id = x.event_offer_id;
2092: EXCEPTION
2093: WHEN OTHERS THEN
2094: NULL;

Line 2230: ams_event_registrations A

2226: SUM(decode(A.system_status_code,'REGISTERED',1,'CANCELLED',1,0)) registered,
2227: SUM(decode(A.system_status_code,'CANCELLED',1,0)) cancelled,
2228: SUM(decode(A.system_status_code,'REGISTERED',decode(attended_flag,'Y',1,0),0)) attended
2229: FROM
2230: ams_event_registrations A
2231: where a.last_reg_status_date between trunc(l_min_date) and trunc(x.event_start_date)-1 +0.9999
2232: and x.event_start_date >= p_start_datel
2233: and x.event_start_date <= p_end_datel
2234: and a.event_offer_id = x.event_offer_id

Line 3218: FROM ams_event_registrations A

3214: ,0 --actual_revenue
3215: ,0 --forecasted_revenue
3216: ,0 booked_orders
3217: ,0 booked_orders_amt
3218: FROM ams_event_registrations A
3219: where trunc(A.last_reg_status_date) between p_start_datel and p_end_datel + 0.9999
3220: GROUP BY A.event_offer_id,
3221: trunc(A.last_reg_status_date)) --REGISTRATION
3222: union all

Line 3703: FROM ams_event_registrations A

3699: ,0 actual_revenue
3700: ,0 forecasted_revenue
3701: ,0 booked_orders
3702: ,0 booked_orders_amt
3703: FROM ams_event_registrations A
3704: WHERE trunc(A.last_reg_status_date) between p_start_datel and p_end_datel + 0.9999
3705: GROUP BY A.event_offer_id,trunc(A.last_reg_status_date))
3706: UNION ALL
3707: (SELECT