APPS.BIM_CAMPAIGN_FACTS dependencies on OZF_ACT_BUDGETS

Line 4080: FROM ozf_act_budgets S

4076: ,a.business_unit_id business_unit_id
4077: ,a.city_id campaign_country_code
4078: ,d.area2_code campaign_region_code
4079: ,a.budget_amount_fc campaign_budget_amount
4080: FROM ozf_act_budgets S
4081: ,ams_campaigns_all_b A
4082: ,ams_source_codes B2
4083: ,jtf_loc_hierarchies_b D
4084: WHERE s.arc_act_budget_used_by = 'CAMP'

Line 4141: FROM ozf_act_budgets S

4137: ,a.business_unit_id business_unit_id
4138: ,a.city_id campaign_country_code
4139: ,d.area2_code campaign_region_code
4140: ,a.budget_amount_fc campaign_budget_amount
4141: FROM ozf_act_budgets S
4142: ,ams_campaigns_all_b A
4143: ,ams_source_codes B2
4144: ,jtf_loc_hierarchies_b D
4145: WHERE s.arc_act_budget_used_by = 'FUND'

Line 4363: FROM ozf_act_budgets S

4359: ,a.business_unit_id business_unit_id
4360: ,a.city_id campaign_country_code
4361: ,e.budget_amount_fc schedule_budget_amount
4362: ,d2.area2_code campaign_region_code
4363: FROM ozf_act_budgets S
4364: ,ams_campaigns_all_b A
4365: ,ams_source_codes B1
4366: ,ams_source_codes B2
4367: ,jtf_loc_hierarchies_b D1

Line 4453: FROM ozf_act_budgets S

4449: ,a.business_unit_id business_unit_id
4450: ,a.city_id campaign_country_code
4451: ,e.budget_amount_fc schedule_budget_amount
4452: ,d2.area2_code campaign_region_code
4453: FROM ozf_act_budgets S
4454: ,ams_campaigns_all_b A
4455: ,ams_source_codes B1
4456: ,ams_source_codes B2
4457: ,jtf_loc_hierarchies_b D1