APPS.BIM_CAMP_COLLECTION dependencies on AMS_ACT_ACCESS_DENORM

Line 755: NVL(b.business_unit_id, 0)),ams_act_access_denorm R

751: AND a.campaign_id = b.campaign_id
752: GROUP BY
753: a.campaign_id ,c.area2_code,
754: a.country_id,
755: NVL(b.business_unit_id, 0)),ams_act_access_denorm R
756: where campaign_id=r.object_id
757: and r.object_type='CAMP'
758: GROUP BY schedule_area2,
759: schedule_country,

Line 1478: b.fiscal_month),ams_act_access_denorm R

1474: a.country_id,
1475: NVL(d.business_unit_id, 0),
1476: b.fiscal_year,
1477: b.fiscal_qtr,
1478: b.fiscal_month),ams_act_access_denorm R
1479: where campaign_id=r.object_id
1480: and r.object_type='CAMP'
1481: GROUP BY schedule_area2,
1482: schedule_country,

Line 2016: 'N'),ams_act_access_denorm R

2012: a.country_id,
2013: NVL(d.business_unit_id, 0),
2014: b.fiscal_year,
2015: b.fiscal_qtr,
2016: 'N'),ams_act_access_denorm R
2017: where campaign_id=r.object_id
2018: and r.object_type='CAMP'
2019: GROUP BY schedule_area2,
2020: schedule_country,

Line 2555: 'N'),ams_act_access_denorm R

2551: a.country_id,
2552: NVL(d.business_unit_id, 0),
2553: b.fiscal_year,
2554: 'N',
2555: 'N'),ams_act_access_denorm R
2556: where campaign_id=r.object_id
2557: and r.object_type='CAMP'
2558: GROUP BY schedule_area2,
2559: schedule_country,

Line 4364: ),ams_act_access_denorm R

4360: GROUP BY a.campaign_id ,c.area2_code,
4361: a.schedule_country,
4362: NVL(a.business_unit_id, 0),
4363: a.schedule_activity_id
4364: ),ams_act_access_denorm R
4365: where campaign_id=r.object_id
4366: and r.object_type='CAMP'
4367: GROUP BY schedule_area2,
4368: schedule_country,

Line 6921: ),ams_act_access_denorm R

6917: GROUP BY c.area2_code,
6918: a.campaign_country,
6919: NVL(a.business_unit_id, 0),
6920: a.campaign_id
6921: ),ams_act_access_denorm R
6922: where campaign_id=r.object_id
6923: and r.object_type='CAMP'
6924: GROUP BY schedule_area2,
6925: schedule_country,

Line 8350: b.fiscal_month),ams_act_access_denorm R

8346: NVL(a.business_unit_id, 0),
8347: a.schedule_activity_id,
8348: b.fiscal_year,
8349: b.fiscal_qtr,
8350: b.fiscal_month),ams_act_access_denorm R
8351: where campaign_id=r.object_id
8352: and r.object_type='CAMP'
8353: GROUP BY schedule_area2,
8354: schedule_country,

Line 8996: b.fiscal_qtr) ,ams_act_access_denorm R

8992: a.schedule_country,
8993: NVL(a.business_unit_id, 0),
8994: a.schedule_activity_id,
8995: b.fiscal_year,
8996: b.fiscal_qtr) ,ams_act_access_denorm R
8997: where campaign_id=r.object_id
8998: and r.object_type='CAMP'
8999: GROUP BY schedule_area2,
9000: schedule_country,

Line 9646: b.fiscal_year),ams_act_access_denorm R

9642: c.area2_code,
9643: a.schedule_country,
9644: NVL(a.business_unit_id, 0),
9645: a.schedule_activity_id,
9646: b.fiscal_year),ams_act_access_denorm R
9647: where campaign_id=r.object_id
9648: and r.object_type='CAMP'
9649: GROUP BY schedule_area2,
9650: schedule_country,

Line 10132: ,ams_act_access_denorm R

10128: a.campaign_id,
10129: b.fiscal_year,
10130: b.fiscal_qtr,
10131: b.fiscal_month)
10132: ,ams_act_access_denorm R
10133: where campaign_id=r.object_id
10134: and r.object_type='CAMP'
10135: GROUP BY schedule_area2,
10136: schedule_country,

Line 10466: b.fiscal_qtr) ,ams_act_access_denorm R

10462: a.campaign_country,
10463: NVL(a.business_unit_id, 0),
10464: a.campaign_id,
10465: b.fiscal_year,
10466: b.fiscal_qtr) ,ams_act_access_denorm R
10467: where campaign_id=r.object_id
10468: and r.object_type='CAMP'
10469: GROUP BY schedule_area2,
10470: schedule_country,

Line 10797: b.fiscal_year),ams_act_access_denorm R

10793: GROUP BY c.area2_code,
10794: a.campaign_country,
10795: NVL(a.business_unit_id, 0),
10796: a.campaign_id,
10797: b.fiscal_year),ams_act_access_denorm R
10798: where campaign_id=r.object_id
10799: and r.object_type='CAMP'
10800: GROUP BY schedule_area2,
10801: schedule_country,