DBA Data[Home] [Help]

APPS.AS_LLOG_SUMMARY_PKG dependencies on AS_LEADS_ALL

Line 203: AS_LEADS_ALL ld

199: max(log.LOG_END_DATE) STATUS_END_DATE,
200: sum(log.LOG_ACTIVE_DAYS) STATUS_DAYS,
201: sum(log.CURRENT_LOG) CURRENT_STATUS
202: FROM AS_LEADS_LOG log,
203: AS_LEADS_ALL ld
204: WHERE log.ENDDAY_LOG_FLAG = 'Y'
205: AND ld.LEAD_ID = log.LEAD_ID
206: AND log.LEAD_ID IN
207: ( select lead_id