APPS.BIM_FUND_FACTS dependencies on AMS_ACT_OFFERS

Line 1814: ams_act_offers D

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'
1818: UNION ALL

Line 2007: ams_act_offers D

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'
2011: UNION ALL

Line 3556: ams_act_offers D

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'
3560: UNION ALL

Line 3751: ams_act_offers D

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'
3755: UNION ALL