DBA Data[Home] [Help]

APPS.JTF_TTY_CAL_METRICS_PVT dependencies on AS_LEADS_ALL

Line 240: from as_leads_all l,

236: G_APPL_ID,
237: G_REQUEST_ID
238: from ( select na.named_account_id,
239: nvl(sum(l.total_amount),0) prior_sales
240: from as_leads_all l,
241: as_statuses_b s,
242: jtf_tty_named_accts na
243: where l.status = s.status_code
244: and s.win_loss_indicator = 'W'