DBA Data[Home] [Help]

APPS.AMS_ACTMETRICS_ENGINE_PVT dependencies on FND_GLOBAL

Line 6529: select sysdate,Fnd_Global.User_Id,sysdate,Fnd_Global.User_Id,Fnd_Global.Conc_Login_Id,AMS_ACT_METRICS_ALL_DENORM_S.NEXTVAL,

6525: ,booked_revenue_forecast,invoiced_revenue_forecast,booked_rev_per_lead_forecast,invoiced_rev_per_lead_forecast
6526: ,cost_forecast,cost_per_lead_forecast,booked_roi_forecast,
6527: invoiced_roi_forecast,contact_group_size_forecast,target_group_size_forecast,responses_forecast
6528: )
6529: select sysdate,Fnd_Global.User_Id,sysdate,Fnd_Global.User_Id,Fnd_Global.Conc_Login_Id,AMS_ACT_METRICS_ALL_DENORM_S.NEXTVAL,
6530: sysdate,object_type,object_id
6531: ,leads,top_leads,top_leads_ratio,leads_accepted,lead_acceptance_rate
6532: ,dead_leads,dead_leads_ratio,opportunities,leads_to_opportunity_rate,quotes,quotes_amount,orders,orders_amount
6533: ,booked_revenue,invoiced_revenue,booked_revenue_per_lead,invoiced_revenue_per_lead,cost,cost_per_lead,booked_roi,

Line 6698: (select Fnd_Global.User_Id,sysdate,Fnd_Global.User_Id,sysdate,

6694: ,a.booked_revenue_forecast,a.invoiced_revenue_forecast,a.booked_rev_per_lead_forecast,a.invoiced_rev_per_lead_forecast
6695: ,a.cost_forecast,a.cost_per_lead_forecast,a.booked_roi_forecast
6696: ,a.invoiced_roi_forecast,a.responses_forecast,a.contact_group_size_forecast,a.target_group_size_forecast
6697: ) =
6698: (select Fnd_Global.User_Id,sysdate,Fnd_Global.User_Id,sysdate,
6699: nvl(a.object_version_number,1) + 1,
6700: sum(decode(met.denorm_code,'METRIC_01',h1.func_actual_value,0)) leads,
6701: sum(decode(met.denorm_code,'METRIC_02',h1.func_actual_value,0)) top_leads,
6702: sum(decode(met.denorm_code,'METRIC_03',h1.func_actual_value,0)) top_leads_ratio,

Line 6804: select sysdate,Fnd_Global.User_Id,sysdate,Fnd_Global.User_Id,Fnd_Global.Conc_Login_Id,AMS_ACT_METRICS_ALL_DENORM_S.NEXTVAL,

6800: ,booked_revenue_forecast,invoiced_revenue_forecast,booked_rev_per_lead_forecast,invoiced_rev_per_lead_forecast
6801: ,cost_forecast,cost_per_lead_forecast,booked_roi_forecast,
6802: invoiced_roi_forecast,contact_group_size_forecast,target_group_size_forecast,responses_forecast
6803: )
6804: select sysdate,Fnd_Global.User_Id,sysdate,Fnd_Global.User_Id,Fnd_Global.Conc_Login_Id,AMS_ACT_METRICS_ALL_DENORM_S.NEXTVAL,
6805: sysdate,object_type,object_id
6806: ,leads,top_leads,top_leads_ratio,leads_accepted,lead_acceptance_rate
6807: ,dead_leads,dead_leads_ratio,opportunities,leads_to_opportunity_rate,quotes,quotes_amount,orders,orders_amount
6808: ,booked_revenue,invoiced_revenue,booked_revenue_per_lead,invoiced_revenue_per_lead,cost,cost_per_lead,booked_roi,