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_EVENT_FACTS dependencies on OZF_ACT_BUDGETS

Line 1341: ozf_act_budgets B

1337: ,'APPROVED'
1338: ,convert_currency(nvl(b.approved_in_currency,'USD'),nvl(b.approved_original_amount,0))
1339: )) budget_approved
1340: FROM ams_event_offers_all_b A,
1341: ozf_act_budgets B
1342: WHERE b.arc_act_budget_used_by in ('EVEO', 'EONE')
1343: AND b.transfer_type = 'REQUEST'
1344: AND b.budget_source_type ='FUND'
1345: AND b.act_budget_used_by_id = a.event_offer_id

Line 1358: ozf_act_budgets B

1354: trunc(nvl(b.approval_date,b.last_update_date)) creation_date,
1355: 0, --budget_requested
1356: 0-SUM(convert_currency(b.approved_in_currency,nvl(b.approved_original_amount,0))) budget_approved
1357: FROM ams_event_offers_all_b A,
1358: ozf_act_budgets B
1359: WHERE b.arc_act_budget_used_by ='FUND'
1360: AND transfer_type in ('TRANSFER','REQUEST')
1361: AND status_code ='APPROVED'
1362: AND b.budget_source_type in ('EVEO', 'EONE')

Line 1427: ozf_act_budgets B

1423: ,'APPROVED'
1424: ,convert_currency(nvl(b.approved_in_currency,'USD'),nvl(b.approved_original_amount,0))
1425: )) budget_approved
1426: FROM ams_event_headers_all_b A,
1427: ozf_act_budgets B
1428: WHERE b.arc_act_budget_used_by = 'EVEH'
1429: AND b.transfer_type = 'REQUEST'
1430: AND b.budget_source_type ='FUND'
1431: AND b.act_budget_used_by_id = a.event_header_id

Line 1444: ozf_act_budgets B

1440: trunc(nvl(b.approval_date,b.last_update_date)) creation_date,
1441: 0, --budget_requested
1442: 0-SUM(convert_currency(b.approved_in_currency,nvl(b.approved_original_amount,0))) budget_approved
1443: FROM ams_event_headers_all_b A,
1444: ozf_act_budgets B
1445: WHERE b.arc_act_budget_used_by ='FUND'
1446: AND transfer_type in ('TRANSFER','REQUEST')
1447: AND status_code ='APPROVED'
1448: AND b.budget_source_type = 'EVEH'

Line 1677: FROM ozf_act_budgets b

1673: ,0
1674: ,'APPROVED'
1675: ,convert_currency(nvl(b.approved_in_currency,'USD'),nvl(b.approved_original_amount,0))
1676: )) budget_approved
1677: FROM ozf_act_budgets b
1678: ,ams_event_offers_all_b a
1679: WHERE b.arc_act_budget_used_by in ('EONE')
1680: AND b.budget_source_type ='FUND'
1681: AND a.event_offer_id = b.act_budget_used_by_id

Line 1695: FROM ozf_act_budgets B

1691: b.budget_source_id event_offer_id,
1692: trunc(nvl(b.approval_date,b.last_update_date)) creation_date,
1693: 0, --budget_requested
1694: 0-SUM(convert_currency(b.approved_in_currency,nvl(b.approved_original_amount,0))) budget_approved
1695: FROM ozf_act_budgets B
1696: ,ams_event_offers_all_b a
1697: WHERE b.arc_act_budget_used_by ='FUND'
1698: AND status_code ='APPROVED'
1699: AND b.budget_source_type in ('EONE')

Line 3014: FROM ozf_act_budgets B

3010: ,0
3011: ,'APPROVED'
3012: ,convert_currency(nvl(b.approved_in_currency,'USD'),nvl(b.approved_original_amount,0))
3013: )) budget_approved
3014: FROM ozf_act_budgets B
3015: WHERE b.arc_act_budget_used_by in ('EVEO', 'EONE')
3016: -- AND b.transfer_type = 'REQUEST'
3017: AND b.budget_source_type ='FUND'
3018: GROUP BY b.act_budget_used_by_id,

Line 3030: FROM ozf_act_budgets B

3026: b.budget_source_id event_offer_id,
3027: trunc(nvl(b.approval_date,b.last_update_date)) creation_date,
3028: 0, --budget_requested
3029: 0-SUM(convert_currency(b.approved_in_currency,nvl(b.approved_original_amount,0))) budget_approved
3030: FROM ozf_act_budgets B
3031: WHERE b.arc_act_budget_used_by ='FUND'
3032: --AND transfer_type in ('TRANSFER','REQUEST')
3033: AND status_code ='APPROVED'
3034: AND b.budget_source_type in ('EVEO', 'EONE')

Line 3489: FROM ozf_act_budgets b

3485: ,0
3486: ,'APPROVED'
3487: ,convert_currency(nvl(b.approved_in_currency,'USD'),nvl(b.approved_original_amount,0))
3488: )) budget_approved
3489: FROM ozf_act_budgets b
3490: ,ams_event_offers_all_b a
3491: WHERE b.arc_act_budget_used_by in ('EONE')
3492: AND b.budget_source_type ='FUND'
3493: AND a.event_offer_id = b.act_budget_used_by_id

Line 3508: FROM ozf_act_budgets B

3504: b.budget_source_id event_offer_id,
3505: trunc(nvl(b.approval_date,b.last_update_date)) creation_date,
3506: 0, --budget_requested
3507: 0-SUM(convert_currency(b.approved_in_currency,nvl(b.approved_original_amount,0))) budget_approved
3508: FROM ozf_act_budgets B
3509: ,ams_event_offers_all_b a
3510: WHERE b.arc_act_budget_used_by ='FUND'
3511: AND status_code ='APPROVED'
3512: AND b.budget_source_type in ('EONE')

Line 3992: FROM ozf_act_budgets B

3988: ,0
3989: ,'APPROVED'
3990: ,convert_currency(nvl(b.approved_in_currency,'USD'),nvl(b.approved_original_amount,0))
3991: )) budget_approved
3992: FROM ozf_act_budgets B
3993: WHERE b.arc_act_budget_used_by = 'EVEH'
3994: --AND b.transfer_type = 'REQUEST'
3995: AND b.budget_source_type ='FUND'
3996: GROUP BY b.act_budget_used_by_id,

Line 4008: FROM ozf_act_budgets B

4004: b.budget_source_id event_header_id,
4005: trunc(nvl(b.approval_date,b.last_update_date)) creation_date,
4006: 0, --budget_requested
4007: 0-SUM(convert_currency(b.approved_in_currency,nvl(b.approved_original_amount,0))) budget_approved
4008: FROM ozf_act_budgets B
4009: WHERE b.arc_act_budget_used_by ='FUND'
4010: --AND transfer_type in ('TRANSFER','REQUEST')
4011: AND status_code ='APPROVED'
4012: AND b.budget_source_type = 'EVEH'