APPS.BIM_EDW_LEADS_F_SIZE dependencies on EDW_BIM_SOURCE_CODE_DETAILS

Line 17: EDW_BIM_SOURCE_CODE_DETAILS BSCD,

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
21: AND ASLL.SALES_LEAD_LINE_ID = INC.PRIMARY_KEY

Line 80: from EDW_BIM_SOURCE_CODE_DETAILS ;

76: select
77: avg(nvl(vsize(CAMPAIGN_FK), 0)),
78: avg(nvl(vsize(EVENT_FK), 0)),
79: avg(nvl(vsize(MEDIA_CHANNEL_FK), 0))
80: from EDW_BIM_SOURCE_CODE_DETAILS ;
81:
82:
83: CURSOR c_3 IS
84: select