eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIM_EDW_LEADS_M_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_LOCAL_INSTANCE INST
18: WHERE ASLL.SALES_LEAD_ID = ASL.SALES_LEAD_ID AND
19: ( (ASL.LAST_UPDATE_DATE > TO_DATE('1000/01/01', 'YYYY/MM/DD') )
20: OR (ASLL.LAST_UPDATE_DATE > TO_DATE('1000/01/01', 'YYYY/MM/DD') ) )

Line 57: AS_SALES_LEADS ASL ,

53: SELECT
54: avg(nvl(vsize( ASLL.SALES_LEAD_LINE_ID ), 0)),
55: avg(nvl(vsize( ASL.SALES_LEAD_ID), 0))
56: FROM AS_SALES_LEAD_LINES ASLL ,
57: AS_SALES_LEADS ASL ,
58: EDW_LOCAL_INSTANCE INST
59: WHERE ASLL.SALES_LEAD_ID = ASL.SALES_LEAD_ID AND
60: ( (ASL.LAST_UPDATE_DATE > TO_DATE('1000/01/01', 'YYYY/MM/DD') )
61: OR (ASLL.LAST_UPDATE_DATE > TO_DATE('1000/01/01', 'YYYY/MM/DD') ) )