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 AMS_EVENT_OFFERS_ALL_B

Line 404: FROM ams_event_offers_all_b A,

400: a.event_venue_id event_venue_id,
401: a.currency_code_fc currency_code_fc,
402: a.fund_amount_fc fund_amount_fc,
403: e.source_code_id offer_source_code_id
404: FROM ams_event_offers_all_b A,
405: ams_event_headers_all_b B,
406: ams_source_codes E
407: WHERE e.source_code = a.source_code
408: AND a.event_header_id = b.event_header_id

Line 430: FROM ams_event_offers_all_b A,

426: a.event_venue_id event_venue_id,
427: a.currency_code_fc currency_code_fc,
428: a.fund_amount_fc fund_amount_fc,
429: e.source_code_id offer_source_code_id
430: FROM ams_event_offers_all_b A,
431: ams_source_codes E
432: WHERE e.source_code = a.source_code
433: AND a.event_standalone_flag = 'Y'
434: AND (a.parent_type is NULL or a.parent_type = 'RCAM')

Line 1027: FROM ams_event_offers_all_b A,

1023: a.currency_code_fc currency_code_fc,
1024: a.fund_amount_fc fund_amount_fc,
1025: e.source_code_id offer_source_code_id,
1026: trunc(dat.trdate) tr_date
1027: FROM ams_event_offers_all_b A,
1028: ams_event_headers_all_b B,
1029: ams_source_codes E,
1030: bim_intl_dates DAT
1031: WHERE dat.trdate between a.event_start_date and

Line 1082: ams_event_offers_all_b C,

1078: ,sum(decode(b.OPP_OPEN_STATUS_FLAG,'Y',decode(a.lead_rank_id,10000,1,0),0)) leads_hot
1079: ,sum(decode(b.OPP_OPEN_STATUS_FLAG,'Y',decode(a.status_code,'NEW',convert_currency(nvl(a.currency_code,'USD'),nvl(a.budget_amount,0)),0),0)) leads_new_amt
1080: FROM as_sales_leads A,
1081: as_statuses_b B,
1082: ams_event_offers_all_b C,
1083: ams_source_codes E
1084: WHERE a.status_code = b.status_code
1085: AND e.source_code = c.source_code
1086: AND b.lead_flag = 'Y'

Line 1099: ams_event_offers_all_b C,

1095: trunc(a.creation_date) creation_date,
1096: COUNT(A.lead_id) opportunities,
1097: SUM(convert_currency(nvl(currency_code, 'USD'), nvl(A.total_amount, 0))) opportunity_amt
1098: FROM as_leads_all A,
1099: ams_event_offers_all_b C,
1100: ams_event_headers_all_b D,
1101: ams_source_codes E
1102: where e.source_code = c.source_code
1103: AND c.event_header_id = d.event_header_id

Line 1340: FROM ams_event_offers_all_b A,

1336: ,0
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'

Line 1357: FROM ams_event_offers_all_b A,

1353: a.event_offer_id event_offer_id,
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'

Line 1365: ams_event_offers_all_b A,

1361: AND status_code ='APPROVED'
1362: AND b.budget_source_type in ('EVEO', 'EONE')
1363: AND b.act_budget_used_by_id = a.event_offer_id
1364: GROUP BY a.event_offer_id, trunc(nvl(b.approval_date,b.last_update_date))) AD,
1365: ams_event_offers_all_b A,
1366: ams_event_headers_all_b B
1367: where a.event_header_id = b.event_header_id
1368: and a.event_start_date >= p_start_datel
1369: and a.event_start_date <= p_end_datel

Line 1678: ,ams_event_offers_all_b a

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
1682: AND a.event_header_id is null

Line 1696: ,ams_event_offers_all_b a

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')
1700: AND a.event_offer_id = b.act_budget_used_by_id

Line 1735: ams_event_offers_all_b C,

1731: ,0 forecasted_revenue
1732: ,0 booked_orders
1733: ,0 booked_orders_amt
1734: FROM as_leads_all A,
1735: ams_event_offers_all_b C,
1736: ams_source_codes E
1737: WHERE e.source_code_for_id = c.event_offer_id
1738: AND c.event_standalone_flag = 'Y'
1739: AND (c.parent_type is null or c.parent_type ='RCAM')

Line 1773: ams_event_offers_all_b C,

1769: ,0 booked_orders
1770: ,0 booked_orders_amt
1771: FROM as_sales_leads A,
1772: as_statuses_b B,
1773: ams_event_offers_all_b C,
1774: ams_source_codes E
1775: WHERE e.source_code_for_id = c.event_offer_id
1776: AND c.event_standalone_flag = 'Y'
1777: AND (c.parent_type is null or c.parent_type ='RCAM')

Line 1847: FROM ams_event_offers_all_b B,

1843: ,0 forecasted_revenue
1844: ,count(distinct(decode(h.flow_status_code,'BOOKED',h.header_id,0))) -1 booked_orders
1845: ,sum(decode(h.flow_status_code,'BOOKED',convert_currency(nvl(H.transactional_curr_code,'USD'),
1846: nvl(I.unit_selling_price * I.ordered_quantity,0)),0)) booked_orders_amt
1847: FROM ams_event_offers_all_b B,
1848: ams_source_codes C ,
1849: as_sales_leads D,
1850: as_sales_lead_opportunity A,
1851: as_leads_all E,

Line 1875: ams_event_offers_all_b A,

1871: ,trunc(i.creation_date)) --orders
1872: )
1873: GROUP BY event_offer_id ,creation_date
1874: ) AD,
1875: ams_event_offers_all_b A,
1876: ams_source_codes E
1877: WHERE ad.event_offer_id = a.event_offer_id
1878: AND a.event_standalone_flag = 'Y'
1879: AND (a.parent_type is null or a.parent_type = 'RCAM')

Line 3141: ams_event_offers_all_b C,

3137: ,0 --forecasted_revenue
3138: ,0 booked_orders
3139: ,0 booked_orders_amt
3140: FROM as_leads_all A,
3141: ams_event_offers_all_b C,
3142: ams_source_codes E
3143: where e.source_code_for_id = c.event_offer_id
3144: and e.source_code_id = a.source_promotion_id
3145: and e.arc_source_code_for in ('EONE','EVEO')

Line 3178: ams_event_offers_all_b C,

3174: ,0 booked_orders
3175: ,0 booked_orders_amt
3176: FROM as_sales_leads A,
3177: as_statuses_b B,
3178: ams_event_offers_all_b C,
3179: ams_source_codes E
3180: WHERE e.source_code_for_id = c.event_offer_id
3181: and e.source_code_id = a.source_promotion_id
3182: and a.status_code = b.status_code

Line 3250: from ams_event_offers_all_b B,

3246: ,0 forecasted_revenue
3247: ,count(distinct(h.header_id)) booked_orders
3248: ,sum(decode(h.flow_status_code,'BOOKED',convert_currency(nvl(H.transactional_curr_code,'USD'),
3249: nvl(I.unit_selling_price * I.ordered_quantity,0)),0)) booked_orders_amt
3250: from ams_event_offers_all_b B,
3251: ams_source_codes C ,
3252: as_sales_leads D,
3253: as_sales_lead_opportunity A,
3254: as_leads_all E,

Line 3278: ams_event_offers_all_b A,

3274: ,trunc(i.creation_date)) --orders
3275: )
3276: group by event_offer_id ,
3277: creation_date) AD,
3278: ams_event_offers_all_b A,
3279: ams_event_headers_all_b B,
3280: ams_source_codes E
3281: where
3282: e.source_code = a.source_code

Line 3490: ,ams_event_offers_all_b a

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
3494: AND a.event_header_id is null

Line 3509: ,ams_event_offers_all_b a

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')
3513: AND a.event_offer_id = b.act_budget_used_by_id

Line 3622: ams_event_offers_all_b C,

3618: ,0 forecasted_revenue
3619: ,0 booked_orders
3620: ,0 booked_orders_amt
3621: FROM as_leads_all A,
3622: ams_event_offers_all_b C,
3623: ams_source_codes E
3624: WHERE e.source_code_for_id = c.event_offer_id
3625: AND c.event_standalone_flag = 'Y'
3626: AND (c.parent_type is null or c.parent_type ='RCAM')

Line 3660: ams_event_offers_all_b C,

3656: ,0 booked_orders
3657: ,0 booked_orders_amt
3658: FROM as_sales_leads A,
3659: as_statuses_b B,
3660: ams_event_offers_all_b C,
3661: ams_source_codes E
3662: WHERE e.source_code_for_id = c.event_offer_id
3663: AND c.event_standalone_flag = 'Y'
3664: AND (c.parent_type is null or c.parent_type ='RCAM')

Line 3734: FROM ams_event_offers_all_b B,

3730: ,0 forecasted_revenue
3731: ,count(distinct(h.header_id)) booked_orders
3732: ,sum(decode(h.flow_status_code,'BOOKED',convert_currency(nvl(H.transactional_curr_code,'USD'),
3733: nvl(I.unit_selling_price * I.ordered_quantity,0)),0)) booked_orders_amt
3734: FROM ams_event_offers_all_b B,
3735: ams_source_codes C ,
3736: as_sales_leads D,
3737: as_sales_lead_opportunity A,
3738: as_leads_all E,

Line 3764: ams_event_offers_all_b A,

3760: ,trunc(i.creation_date)) --orders
3761: )
3762: GROUP BY event_offer_id ,creation_date
3763: ) AD,
3764: ams_event_offers_all_b A,
3765: ams_source_codes E
3766: WHERE ad.event_offer_id = a.event_offer_id
3767: AND a.event_standalone_flag = 'Y'
3768: AND (a.parent_type is null or a.parent_type = 'RCAM')