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_FUND_FACTS dependencies on AMS_CAMPAIGNS_ALL_B

Line 1779: FROM ams_campaigns_all_b D

1775: bim_r_fdsp_load AU,
1776: (SELECT
1777: D.business_unit_id business_unit_id,D.org_id org_id,
1778: 'CAMP' object_type_J,'CAMP' object_type, D.campaign_id object_id
1779: FROM ams_campaigns_all_b D
1780: UNION ALL
1781: SELECT
1782: D.business_unit_id business_unit_id,D.org_id org_id,
1783: 'CSCH' object_type_J,'CSCH' object_type,B.SCHEDULE_ID object_id

Line 1785: ams_campaigns_all_b D,

1781: SELECT
1782: D.business_unit_id business_unit_id,D.org_id org_id,
1783: 'CSCH' object_type_J,'CSCH' object_type,B.SCHEDULE_ID object_id
1784: FROM
1785: ams_campaigns_all_b D,
1786: ams_campaign_schedules_b B
1787: WHERE B.campaign_id = D.campaign_id (+)
1788: UNION ALL
1789: SELECT

Line 1813: ams_campaigns_all_b BC,

1809: SELECT
1810: BC.business_unit_id business_unit_id,BC.org_id org_id,
1811: 'OFFR' object_type_J, 'OFFR' object_type, D.qp_list_header_id object_id
1812: FROM
1813: ams_campaigns_all_b BC,
1814: ams_act_offers D
1815: WHERE
1816: D.arc_act_offer_used_by (+) = 'CAMP' AND D.act_offer_used_by_id =
1817: BC.campaign_id (+) AND BC.show_campaign_flag (+) = 'Y'

Line 1823: ams_campaigns_all_b BA,

1819: SELECT
1820: BA.business_unit_id business_unit_id,BA.org_id org_id,
1821: 'DELV' object_type_J, 'CAMPDELV' object_type, D.using_object_id object_id
1822: FROM
1823: ams_campaigns_all_b BA,
1824: ams_object_associations D
1825: WHERE
1826: D.using_object_type='DELV' AND
1827: D.master_object_type (+) = 'CAMP' AND

Line 1834: ams_campaigns_all_b BA,

1830: SELECT
1831: BA.business_unit_id business_unit_id,BA.org_id org_id,
1832: 'DELV' object_type_J, 'CSCHDELV' object_type, D.using_object_id object_id
1833: FROM
1834: ams_campaigns_all_b BA,
1835: ams_campaign_schedules_b E,
1836: ams_object_associations D
1837: WHERE
1838: D.master_object_type (+) = 'CSCH' AND D.master_object_id = E.SCHEDULE_ID

Line 1972: FROM ams_campaigns_all_b D

1968: bim_r_fdsp_load AU,
1969: (SELECT
1970: D.business_unit_id business_unit_id,D.org_id org_id,
1971: 'CAMP' object_type_J,'CAMP' object_type, D.campaign_id object_id
1972: FROM ams_campaigns_all_b D
1973: UNION ALL
1974: SELECT
1975: D.business_unit_id business_unit_id,D.org_id org_id,
1976: 'CSCH' object_type_J,'CSCH' object_type,B.SCHEDULE_ID object_id

Line 1978: ams_campaigns_all_b D,

1974: SELECT
1975: D.business_unit_id business_unit_id,D.org_id org_id,
1976: 'CSCH' object_type_J,'CSCH' object_type,B.SCHEDULE_ID object_id
1977: FROM
1978: ams_campaigns_all_b D,
1979: ams_campaign_schedules_b B
1980: WHERE B.campaign_id = D.campaign_id (+)
1981: UNION ALL
1982: SELECT

Line 2006: ams_campaigns_all_b BC,

2002: SELECT
2003: BC.business_unit_id business_unit_id,BC.org_id org_id,
2004: 'OFFR' object_type_J, 'OFFR' object_type, D.qp_list_header_id object_id
2005: FROM
2006: ams_campaigns_all_b BC,
2007: ams_act_offers D
2008: WHERE
2009: D.arc_act_offer_used_by (+) = 'CAMP' AND D.act_offer_used_by_id =
2010: BC.campaign_id (+) AND BC.show_campaign_flag (+) = 'Y'

Line 2016: ams_campaigns_all_b BA,

2012: SELECT
2013: BA.business_unit_id business_unit_id,BA.org_id org_id,
2014: 'DELV' object_type_J, 'CAMPDELV' object_type, D.using_object_id object_id
2015: FROM
2016: ams_campaigns_all_b BA,
2017: ams_object_associations D
2018: WHERE
2019: D.using_object_type='DELV' AND
2020: D.master_object_type (+) = 'CAMP' AND

Line 2027: ams_campaigns_all_b BA,

2023: SELECT
2024: BA.business_unit_id business_unit_id,BA.org_id org_id,
2025: 'DELV' object_type_J, 'CSCHDELV' object_type, D.using_object_id object_id
2026: FROM
2027: ams_campaigns_all_b BA,
2028: ams_campaign_schedules_b E,
2029: ams_object_associations D
2030: WHERE
2031: D.master_object_type (+) = 'CSCH' AND D.master_object_id = E.SCHEDULE_ID

Line 3521: FROM ams_campaigns_all_b D

3517: bim_r_fdsp_load AU,
3518: (SELECT
3519: D.business_unit_id business_unit_id,D.org_id org_id,
3520: 'CAMP' object_type_J,'CAMP' object_type, D.campaign_id object_id
3521: FROM ams_campaigns_all_b D
3522: UNION ALL
3523: SELECT
3524: D.business_unit_id business_unit_id,D.org_id org_id,
3525: 'CSCH' object_type_J,'CSCH' object_type,B.SCHEDULE_ID object_id

Line 3527: ams_campaigns_all_b D,

3523: SELECT
3524: D.business_unit_id business_unit_id,D.org_id org_id,
3525: 'CSCH' object_type_J,'CSCH' object_type,B.SCHEDULE_ID object_id
3526: FROM
3527: ams_campaigns_all_b D,
3528: ams_campaign_schedules_b B
3529: WHERE B.campaign_id = D.campaign_id (+)
3530: UNION ALL
3531: SELECT

Line 3555: ams_campaigns_all_b BC,

3551: SELECT
3552: BC.business_unit_id business_unit_id,BC.org_id org_id,
3553: 'OFFR' object_type_J, 'OFFR' object_type, D.qp_list_header_id object_id
3554: FROM
3555: ams_campaigns_all_b BC,
3556: ams_act_offers D
3557: WHERE
3558: D.arc_act_offer_used_by (+) = 'CAMP' AND D.act_offer_used_by_id =
3559: BC.campaign_id (+) AND BC.show_campaign_flag (+) = 'Y'

Line 3565: ams_campaigns_all_b BA,

3561: SELECT
3562: BA.business_unit_id business_unit_id,BA.org_id org_id,
3563: 'DELV' object_type_J, 'CAMPDELV' object_type, D.using_object_id object_id
3564: FROM
3565: ams_campaigns_all_b BA,
3566: ams_object_associations D
3567: WHERE
3568: D.using_object_type='DELV' AND
3569: D.master_object_type (+) = 'CAMP' AND

Line 3576: ams_campaigns_all_b BA,

3572: SELECT
3573: BA.business_unit_id business_unit_id,BA.org_id org_id,
3574: 'DELV' object_type_J, 'CSCHDELV' object_type, D.using_object_id object_id
3575: FROM
3576: ams_campaigns_all_b BA,
3577: ams_campaign_schedules_b E,
3578: ams_object_associations D
3579: WHERE
3580: D.master_object_type (+) = 'CSCH' AND D.master_object_id = E.SCHEDULE_ID

Line 3716: FROM ams_campaigns_all_b D

3712: bim_r_fdsp_load AU,
3713: (SELECT
3714: D.business_unit_id business_unit_id,D.org_id org_id,
3715: 'CAMP' object_type_J,'CAMP' object_type, D.campaign_id object_id
3716: FROM ams_campaigns_all_b D
3717: UNION ALL
3718: SELECT
3719: D.business_unit_id business_unit_id,D.org_id org_id,
3720: 'CSCH' object_type_J,'CSCH' object_type,B.SCHEDULE_ID object_id

Line 3722: ams_campaigns_all_b D,

3718: SELECT
3719: D.business_unit_id business_unit_id,D.org_id org_id,
3720: 'CSCH' object_type_J,'CSCH' object_type,B.SCHEDULE_ID object_id
3721: FROM
3722: ams_campaigns_all_b D,
3723: ams_campaign_schedules_b B
3724: WHERE B.campaign_id = D.campaign_id (+)
3725: UNION ALL
3726: SELECT

Line 3750: ams_campaigns_all_b BC,

3746: SELECT
3747: BC.business_unit_id business_unit_id,BC.org_id org_id,
3748: 'OFFR' object_type_J, 'OFFR' object_type, D.qp_list_header_id object_id
3749: FROM
3750: ams_campaigns_all_b BC,
3751: ams_act_offers D
3752: WHERE
3753: D.arc_act_offer_used_by (+) = 'CAMP' AND D.act_offer_used_by_id =
3754: BC.campaign_id (+) AND BC.show_campaign_flag (+) = 'Y'

Line 3760: ams_campaigns_all_b BA,

3756: SELECT
3757: BA.business_unit_id business_unit_id,BA.org_id org_id,
3758: 'DELV' object_type_J, 'CAMPDELV' object_type, D.using_object_id object_id
3759: FROM
3760: ams_campaigns_all_b BA,
3761: ams_object_associations D
3762: WHERE
3763: D.using_object_type='DELV' AND
3764: D.master_object_type (+) = 'CAMP' AND

Line 3771: ams_campaigns_all_b BA,

3767: SELECT
3768: BA.business_unit_id business_unit_id,BA.org_id org_id,
3769: 'DELV' object_type_J, 'CSCHDELV' object_type, D.using_object_id object_id
3770: FROM
3771: ams_campaigns_all_b BA,
3772: ams_campaign_schedules_b E,
3773: ams_object_associations D
3774: WHERE
3775: D.master_object_type (+) = 'CSCH' AND D.master_object_id = E.SCHEDULE_ID