APPS.BIM_EDW_LEADS_F_SIZE dependencies on AS_SALES_LEADS

Line 16: AS_SALES_LEADS ASL,

12: select sum(cnt)
13: from (
14: select count(*) cnt
15: FROM AS_SALES_LEAD_LINES ASLL,
16: AS_SALES_LEADS ASL,
17: EDW_BIM_SOURCE_CODE_DETAILS BSCD,
18: BIM_EDW_LEADS_INC INC,
19: EDW_LOCAL_INSTANCE INST
20: WHERE ASL.SALES_LEAD_ID = ASLL.SALES_LEAD_ID

Line 89: from AS_SALES_LEADS

85: avg(nvl(vsize(STATUS_CODE), 0)),
86: avg(nvl(vsize(CUSTOMER_ID), 0)),
87: avg(nvl(vsize(CURRENCY_CODE), 0)),
88: avg(nvl(vsize(ADDRESS_ID), 0))
89: from AS_SALES_LEADS
90: where last_update_date between
91: p_from_date and p_to_date;
92:
93: