[Home] [Help]
APPS.BIM_EDW_OPRNTIES_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_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
20: WHERE ASL.LEAD_ID = ASLL.LEAD_ID
21: AND ASLL.LEAD_LINE_ID = INC.PRIMARY_KEY
Line 87: from EDW_BIM_SOURCE_CODE_DETAILS ;
83: select
84: avg(nvl(vsize(CAMPAIGN_FK), 0)),
85: avg(nvl(vsize(EVENT_FK), 0)),
86: avg(nvl(vsize(MEDIA_CHANNEL_FK), 0))
87: from EDW_BIM_SOURCE_CODE_DETAILS ;
88:
89:
90: CURSOR c_3 IS
91: select