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_OPRNTIES_F_SIZE dependencies on AS_LEAD_LINES_ALL

Line 15: FROM AS_LEAD_LINES_ALL ASLL,

11: CURSOR c_cnt_rows IS
12: select sum(cnt)
13: from (
14: select count(*) cnt
15: FROM AS_LEAD_LINES_ALL ASLL,
16: AS_LEADS_ALL ASL,
17: EDW_BIM_SOURCE_CODE_DETAILS BSCD,
18: BIM_EDW_OPRNTIES_INC INC,
19: EDW_LOCAL_INSTANCE INST

Line 78: FROM AS_LEAD_LINES_ALL

74: avg(nvl(vsize( OFFER_ID ), 0)),
75: avg(nvl(vsize( ORG_ID ), 0)),
76: avg(nvl(vsize( TOTAL_AMOUNT ), 0)),
77: avg(nvl(vsize( QUANTITY ), 0))
78: FROM AS_LEAD_LINES_ALL
79: where last_update_date between
80: p_from_date and p_to_date;
81:
82: CURSOR c_2 IS