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_MARKET_FACTS_PKG dependencies on AMS_SOURCE_CODES

Line 1436: ,ams_source_codes B

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
1439: AND b.source_code_id = a.source_code_id
1440: AND a.object_type NOT IN ('RCAM')

Line 1539: ,ams_source_codes B

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
1542: AND s.budget_source_type = b.arc_source_code_for
1543: AND s.budget_source_id = b.source_code_for_id

Line 1637: ,ams_source_codes B

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
1640: AND b.source_code_id = a.source_code_id
1641: AND a.child_object_type IN ('CSCH','EVEO')

Line 1734: ,ams_source_codes B

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
1737: AND s.budget_source_id = b.source_code_for_id
1738: AND b.source_code_id = a.source_code_id

Line 4100: ,ams_source_codes B

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
4103: AND b.source_code_id = a.source_code_id
4104: AND a.object_type NOT IN ('RCAM')

Line 4191: ,ams_source_codes B

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
4194: AND s.budget_source_type = b.arc_source_code_for
4195: AND s.budget_source_id = b.source_code_for_id

Line 4280: ,ams_source_codes B

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
4283: AND b.source_code_id = a.source_code_id
4284: AND a.child_object_type IN ('CSCH','EVEO')

Line 4370: ,ams_source_codes B

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
4373: AND s.budget_source_id = b.source_code_for_id
4374: AND b.source_code_id = a.source_code_id