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_CAMPAIGN_FACTS dependencies on JTF_LOC_HIERARCHIES_B

Line 1095: ,jtf_loc_hierarchies_b D

1091: ,metric.creation_date
1092: ) inner
1093: ,ams_campaigns_all_b A
1094: ,ams_source_codes C
1095: ,jtf_loc_hierarchies_b D
1096: WHERE
1097: a.campaign_id = inner.campaign_id
1098: AND A.campaign_id = C.source_code_for_id
1099: AND C.arc_source_code_for = 'CAMP'

Line 1679: ,jtf_loc_hierarchies_b D1

1675: ,ams_campaign_schedules_b E
1676: ,ams_campaigns_all_b A
1677: ,ams_source_codes B1
1678: ,ams_source_codes B2
1679: ,jtf_loc_hierarchies_b D1
1680: ,jtf_loc_hierarchies_b D2
1681: WHERE
1682: e.schedule_id = inner.schedule_id
1683: AND e.campaign_id = a.campaign_id

Line 1680: ,jtf_loc_hierarchies_b D2

1676: ,ams_campaigns_all_b A
1677: ,ams_source_codes B1
1678: ,ams_source_codes B2
1679: ,jtf_loc_hierarchies_b D1
1680: ,jtf_loc_hierarchies_b D2
1681: WHERE
1682: e.schedule_id = inner.schedule_id
1683: AND e.campaign_id = a.campaign_id
1684: AND e.country_id = d1.location_hierarchy_id

Line 1868: ,jtf_loc_hierarchies_b D

1864: ,a.budget_amount_fc campaign_budget_amount
1865: FROM ams_act_budgets S
1866: ,ams_campaigns_all_b A
1867: ,ams_source_codes B2
1868: ,jtf_loc_hierarchies_b D
1869: WHERE s.arc_act_budget_used_by = 'CAMP'
1870: AND s.budget_source_type = 'FUND'
1871: --AND s.transfer_type = 'REQUEST'
1872: AND s.act_budget_used_by_id = a.campaign_id

Line 1929: ,jtf_loc_hierarchies_b D

1925: ,a.budget_amount_fc campaign_budget_amount
1926: FROM ams_act_budgets S
1927: ,ams_campaigns_all_b A
1928: ,ams_source_codes B2
1929: ,jtf_loc_hierarchies_b D
1930: WHERE s.arc_act_budget_used_by = 'FUND'
1931: AND s.budget_source_type = 'CAMP'
1932: --AND s.transfer_type = 'REQUEST'
1933: AND s.budget_source_id = a.campaign_id

Line 2152: ,jtf_loc_hierarchies_b D1

2148: FROM ams_act_budgets S
2149: ,ams_campaigns_all_b A
2150: ,ams_source_codes B1
2151: ,ams_source_codes B2
2152: ,jtf_loc_hierarchies_b D1
2153: ,jtf_loc_hierarchies_b D2
2154: ,ams_campaign_schedules_b E
2155: WHERE s.arc_act_budget_used_by = 'CSCH'
2156: AND s.budget_source_type = 'FUND'

Line 2153: ,jtf_loc_hierarchies_b D2

2149: ,ams_campaigns_all_b A
2150: ,ams_source_codes B1
2151: ,ams_source_codes B2
2152: ,jtf_loc_hierarchies_b D1
2153: ,jtf_loc_hierarchies_b D2
2154: ,ams_campaign_schedules_b E
2155: WHERE s.arc_act_budget_used_by = 'CSCH'
2156: AND s.budget_source_type = 'FUND'
2157: --AND s.transfer_type = 'REQUEST'

Line 2240: ,jtf_loc_hierarchies_b D1

2236: FROM ams_act_budgets S
2237: ,ams_campaigns_all_b A
2238: ,ams_source_codes B1
2239: ,ams_source_codes B2
2240: ,jtf_loc_hierarchies_b D1
2241: ,jtf_loc_hierarchies_b D2
2242: ,ams_campaign_schedules_b E
2243: WHERE s.arc_act_budget_used_by = 'FUND'
2244: AND s.budget_source_type = 'CSCH'

Line 2241: ,jtf_loc_hierarchies_b D2

2237: ,ams_campaigns_all_b A
2238: ,ams_source_codes B1
2239: ,ams_source_codes B2
2240: ,jtf_loc_hierarchies_b D1
2241: ,jtf_loc_hierarchies_b D2
2242: ,ams_campaign_schedules_b E
2243: WHERE s.arc_act_budget_used_by = 'FUND'
2244: AND s.budget_source_type = 'CSCH'
2245: --AND s.transfer_type = 'REQUEST'

Line 3306: ,jtf_loc_hierarchies_b D

3302: ,metric.creation_date
3303: ) inner
3304: ,ams_campaigns_all_b A
3305: ,ams_source_codes C
3306: ,jtf_loc_hierarchies_b D
3307: WHERE
3308: a.campaign_id = inner.campaign_id
3309: AND A.campaign_id = C.source_code_for_id
3310: AND C.arc_source_code_for = 'CAMP'

Line 3891: ,jtf_loc_hierarchies_b D1

3887: ,ams_campaign_schedules_b E
3888: ,ams_campaigns_all_b A
3889: ,ams_source_codes B1
3890: ,ams_source_codes B2
3891: ,jtf_loc_hierarchies_b D1
3892: ,jtf_loc_hierarchies_b D2
3893: WHERE
3894: e.schedule_id = inner.schedule_id
3895: AND e.campaign_id = a.campaign_id

Line 3892: ,jtf_loc_hierarchies_b D2

3888: ,ams_campaigns_all_b A
3889: ,ams_source_codes B1
3890: ,ams_source_codes B2
3891: ,jtf_loc_hierarchies_b D1
3892: ,jtf_loc_hierarchies_b D2
3893: WHERE
3894: e.schedule_id = inner.schedule_id
3895: AND e.campaign_id = a.campaign_id
3896: AND e.country_id = d1.location_hierarchy_id

Line 4083: ,jtf_loc_hierarchies_b D

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'
4085: AND s.budget_source_type = 'FUND'
4086: --AND s.transfer_type = 'REQUEST'
4087: AND s.act_budget_used_by_id = a.campaign_id

Line 4144: ,jtf_loc_hierarchies_b D

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'
4146: AND s.budget_source_type = 'CAMP'
4147: --AND s.transfer_type = 'REQUEST'
4148: AND s.budget_source_id = a.campaign_id

Line 4367: ,jtf_loc_hierarchies_b D1

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
4368: ,jtf_loc_hierarchies_b D2
4369: ,ams_campaign_schedules_b E
4370: WHERE s.arc_act_budget_used_by = 'CSCH'
4371: AND s.budget_source_type = 'FUND'

Line 4368: ,jtf_loc_hierarchies_b D2

4364: ,ams_campaigns_all_b A
4365: ,ams_source_codes B1
4366: ,ams_source_codes B2
4367: ,jtf_loc_hierarchies_b D1
4368: ,jtf_loc_hierarchies_b D2
4369: ,ams_campaign_schedules_b E
4370: WHERE s.arc_act_budget_used_by = 'CSCH'
4371: AND s.budget_source_type = 'FUND'
4372: --AND s.transfer_type = 'REQUEST'

Line 4457: ,jtf_loc_hierarchies_b D1

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
4458: ,jtf_loc_hierarchies_b D2
4459: ,ams_campaign_schedules_b E
4460: WHERE s.arc_act_budget_used_by = 'FUND'
4461: AND s.budget_source_type = 'CSCH'

Line 4458: ,jtf_loc_hierarchies_b D2

4454: ,ams_campaigns_all_b A
4455: ,ams_source_codes B1
4456: ,ams_source_codes B2
4457: ,jtf_loc_hierarchies_b D1
4458: ,jtf_loc_hierarchies_b D2
4459: ,ams_campaign_schedules_b E
4460: WHERE s.arc_act_budget_used_by = 'FUND'
4461: AND s.budget_source_type = 'CSCH'
4462: --AND s.transfer_type = 'REQUEST'