APPS.BIM_MARKET_FACTS_PKG dependencies on OZF_ACT_BUDGETS

Line 1434: FROM ozf_act_budgets S

1430: ,0 BUDGET_APPROVED_S
1431: ,0 conversion_rate_s
1432: ,0 metric1
1433: ,0 metric2
1434: FROM ozf_act_budgets S
1435: ,bim_i_source_codes A
1436: ,ams_source_codes B
1437: WHERE s.act_budget_used_by_id = b.source_code_for_id
1438: AND s.arc_act_budget_used_by = b.arc_source_code_for

Line 1537: FROM ozf_act_budgets S

1533: ,0 BUDGET_APPROVED_S
1534: ,0 conversion_rate_s
1535: ,0 metric1
1536: ,0 metric2
1537: FROM ozf_act_budgets S
1538: ,bim_i_source_codes A
1539: ,ams_source_codes B
1540: WHERE s.arc_act_budget_used_by = 'FUND'
1541: AND s.parent_act_budget_id IS NULL

Line 1635: FROM ozf_act_budgets S

1631: ,0 BUDGET_APPROVED_S
1632: ,0 conversion_rate_s
1633: ,sum(nvl(s.approved_amount,0)) metric1
1634: ,0 metric2
1635: FROM ozf_act_budgets S
1636: ,bim_i_source_codes A
1637: ,ams_source_codes B
1638: WHERE s.act_budget_used_by_id = b.source_code_for_id
1639: AND s.arc_act_budget_used_by = b.arc_source_code_for

Line 1732: FROM ozf_act_budgets S

1728: ,0 BUDGET_APPROVED_S
1729: ,0 conversion_rate_s
1730: ,0-sum(nvl(s.approved_amount,0)) metric1
1731: ,0 metric2
1732: FROM ozf_act_budgets S
1733: ,bim_i_source_codes A
1734: ,ams_source_codes B
1735: WHERE s.arc_act_budget_used_by = 'FUND'
1736: AND s.budget_source_type = b.arc_source_code_for

Line 4098: FROM ozf_act_budgets S

4094: ,0 BUDGET_APPROVED_S
4095: ,0 conversion_rate_s
4096: ,0 metric1
4097: ,0 metric2
4098: FROM ozf_act_budgets S
4099: ,bim_i_source_codes A
4100: ,ams_source_codes B
4101: WHERE s.act_budget_used_by_id = b.source_code_for_id
4102: AND s.arc_act_budget_used_by = b.arc_source_code_for

Line 4189: FROM ozf_act_budgets S

4185: ,0 BUDGET_APPROVED_S
4186: ,0 conversion_rate_s
4187: ,0 metric1
4188: ,0 metric2
4189: FROM ozf_act_budgets S
4190: ,bim_i_source_codes A
4191: ,ams_source_codes B
4192: WHERE s.arc_act_budget_used_by = 'FUND'
4193: AND s.parent_act_budget_id IS NULL

Line 4278: FROM ozf_act_budgets S

4274: ,0 BUDGET_APPROVED_S
4275: ,0 conversion_rate_s
4276: ,sum(nvl(s.approved_amount,0)) metric1
4277: ,0 metric2
4278: FROM ozf_act_budgets S
4279: ,bim_i_source_codes A
4280: ,ams_source_codes B
4281: WHERE s.act_budget_used_by_id = b.source_code_for_id
4282: AND s.arc_act_budget_used_by = b.arc_source_code_for

Line 4368: FROM ozf_act_budgets S

4364: ,0 BUDGET_APPROVED_S
4365: ,0 conversion_rate_s
4366: ,0-sum(nvl(s.approved_amount,0)) metric1
4367: ,0 metric2
4368: FROM ozf_act_budgets S
4369: ,bim_i_source_codes A
4370: ,ams_source_codes B
4371: WHERE s.arc_act_budget_used_by = 'FUND'
4372: AND s.budget_source_type = b.arc_source_code_for