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_FUND_FACTS dependencies on OZF_FUNDS_ALL_B

Line 667: from ozf_funds_all_b

663: INTO l_start_date
664: FROM gl_periods
665: WHERE start_date <
666: (select nvl(min(start_date_active),sysdate)
667: from ozf_funds_all_b
668: )
669: AND rownum < 2;
670:
671: IF (l_start_date IS NULL) THEN

Line 1125: FROM ozf_funds_all_b a,

1121: a.currency_code_fc currency_code_fc,
1122: -- decode(trunc(d.trdate),trunc(a.PROGRAM_UPDATE_DATE),a.original_budget,0) original_budget,
1123: a.original_budget original_budget,
1124: trunc(d.trdate) tr_date
1125: FROM ozf_funds_all_b a,
1126: bim_intl_dates d
1127: WHERE a.status_code in ('ACTIVE', 'CANCELLED', 'CLOSED')
1128: AND d.trdate between a.start_date_active and least(nvl(a.end_date_active,sysdate-1),p_end_datel)
1129: AND a.start_date_active between p_start_datel and p_end_datel

Line 1226: FROM ozf_funds_all_b a,

1222: a.currency_code_fc currency_code_fc,
1223: -- decode(trunc(d.trdate),trunc(a.PROGRAM_UPDATE_DATE),a.original_budget,0) original_budget,
1224: a.original_budget original_budget,
1225: trunc(d.trdate) tr_date
1226: FROM ozf_funds_all_b a,
1227: bim_intl_dates d
1228: WHERE a.status_code in ('ACTIVE', 'CANCELLED', 'CLOSED')
1229: AND d.trdate between a.start_date_active and least(nvl(a.end_date_active,sysdate-1),p_end_datel)
1230: AND a.start_date_active between p_start_datel and p_end_datel

Line 1433: FROM ozf_funds_all_b o,

1429: o.org_id org_id,
1430: o.set_of_books_id set_of_books_id,
1431: o.currency_code_fc currency_code_fc,
1432: o.original_budget original_budget
1433: FROM ozf_funds_all_b o,
1434: ozf_act_budgets BU1
1435: WHERE o.start_date_active between p_start_datel and p_end_datel
1436: AND o.status_code in ('ACTIVE','CANCELLED', 'CLOSED')
1437: AND bu1.transfer_type in ('TRANSFER', 'REQUEST')

Line 1485: FROM ozf_funds_all_b o,

1481: o.org_id org_id,
1482: o.set_of_books_id set_of_books_id,
1483: o.currency_code_fc currency_code_fc,
1484: o.original_budget original_budget
1485: FROM ozf_funds_all_b o,
1486: ozf_act_budgets BU2
1487: WHERE o.start_date_active between p_start_datel and p_end_datel
1488: AND o.status_code in ('ACTIVE','CANCEL', 'CLOSED')
1489: AND bu2.approval_date

Line 1768: FROM ozf_funds_all_b A,

1764: AU.object_id object_id,
1765: U.object_type object_type,
1766: AD.trdate transaction_create_date
1767: FROM (SELECT A.fund_id fund_id,TRUNC(DA.trdate) trdate
1768: FROM ozf_funds_all_b A,
1769: bim_intl_dates DA
1770: WHERE A.status_code IN ( 'ACTIVE','CANCELLED','CLOSED' )
1771: AND DA.trdate between A.start_date_active
1772: and least(nvl(A.end_date_active,sysdate-1),p_end_datel)

Line 1967: FROM ozf_funds_all_b AD,

1963: NVL(AU.paid_amt,0) paid_amt,
1964: AU.object_id object_id,
1965: U.object_type object_type,
1966: AU.transaction_create_date transaction_create_date
1967: FROM ozf_funds_all_b AD,
1968: bim_r_fdsp_load AU,
1969: (SELECT
1970: D.business_unit_id business_unit_id,D.org_id org_id,
1971: 'CAMP' object_type_J,'CAMP' object_type, D.campaign_id object_id

Line 2184: FROM ozf_funds_all_b a,

2180: b2.fis_month,
2181: b2.fis_qtr,
2182: b2.fis_year,
2183: a.business_unit_id
2184: FROM ozf_funds_all_b a,
2185: (SELECT distinct(fund_id) fund_id,
2186: fis_month fis_month,
2187: fis_qtr fis_qtr,
2188: fis_year fis_year,

Line 2700: FROM ozf_funds_all_b ad,

2696: trunc(bu1.approval_date) transaction_create_date,
2697: nvl(SUM(convert_currency(bu1.approved_in_currency,nvl(bu1.approved_original_amount,0))),0) transfer_in,
2698: 0 transfer_out,
2699: 0 holdback
2700: FROM ozf_funds_all_b ad,
2701: ozf_act_budgets BU1
2702: WHERE bu1.approval_date between p_start_datel and p_end_datel + 0.99999
2703: AND ad.status_code in ('ACTIVE', 'CANCELLED', 'CLOSED')
2704: AND bu1.transfer_type in ('TRANSFER','REQUEST')

Line 2749: FROM ozf_funds_all_b ad,

2745: nvl(SUM(decode(bu2.transfer_type,'TRANSFER', convert_currency(bu2.approved_in_currency,nvl(bu2.approved_original_amount,0)))),0)
2746: +nvl(SUM(decode(bu2.transfer_type,'REQUEST', convert_currency(bu2.approved_in_currency,nvl(bu2.approved_original_amount,0)))),0) transfer_out,
2747: nvl(SUM(decode(bu2.transfer_type, 'RESERVE', convert_currency(bu2.approved_in_currency,nvl(bu2.approved_original_amount,0)))),0)-
2748: nvl(SUM(decode(bu2.transfer_type, 'RELEASE', convert_currency(bu2.approved_in_currency,nvl(bu2.approved_original_amount,0)))),0) holdback
2749: FROM ozf_funds_all_b ad,
2750: ozf_act_budgets BU2
2751: WHERE bu2.approval_date between p_start_datel and p_end_datel + 0.99999
2752: AND ad.status_code in ('ACTIVE', 'CANCELLED', 'CLOSED')
2753: AND bu2.status_code = 'APPROVED'

Line 2934: FROM ozf_funds_all_b ad,

2930: trunc(bu1.approval_date) transaction_create_date,
2931: nvl(SUM(convert_currency(bu1.approved_in_currency,nvl(bu1.approved_original_amount,0))),0) transfer_in,
2932: 0 transfer_out,
2933: 0 holdback
2934: FROM ozf_funds_all_b ad,
2935: ozf_act_budgets BU1
2936: WHERE bu1.approval_date < p_start_datel
2937: AND ad.status_code in ('ACTIVE', 'CANCELLED', 'CLOSED')
2938: AND ad.start_date_active between p_start_datel and p_end_datel

Line 2984: FROM ozf_funds_all_b ad,

2980: nvl(SUM(decode(bu2.transfer_type,'TRANSFER', convert_currency(bu2.approved_in_currency,nvl(bu2.approved_original_amount,0)))),0)
2981: +nvl(SUM(decode(bu2.transfer_type,'REQUEST', convert_currency(bu2.approved_in_currency,nvl(bu2.approved_original_amount,0)))),0) transfer_out,
2982: nvl(SUM(decode(bu2.transfer_type, 'RESERVE', convert_currency(bu2.approved_in_currency,nvl(bu2.approved_original_amount,0)))),0)-
2983: nvl(SUM(decode(bu2.transfer_type, 'RELEASE', convert_currency(bu2.approved_in_currency,nvl(bu2.approved_original_amount,0)))),0) holdback
2984: FROM ozf_funds_all_b ad,
2985: ozf_act_budgets BU2
2986: WHERE bu2.approval_date < p_start_datel
2987: AND ad.status_code in ('ACTIVE', 'CANCELLED', 'CLOSED')
2988: AND ad.start_date_active between p_start_datel and p_end_datel

Line 3270: FROM ozf_funds_all_b ad,

3266: trunc(b.trdate) trdate,
3267: 0 transfer_in,
3268: 0 transfer_out,
3269: 0 holdback
3270: FROM ozf_funds_all_b ad,
3271: bim_intl_dates b
3272: WHERE ad.status_code in ('ACTIVE', 'CANCELLED', 'CLOSED')
3273: AND ad.start_date_active between p_start_datel and p_end_datel
3274: AND b.trdate between p_start_datel and p_end_datel+0.99999

Line 3516: FROM ozf_funds_all_b AD,

3512: NVL(AU.paid_amt,0) paid_amt,
3513: AU.object_id object_id,
3514: U.object_type object_type,
3515: AU.transaction_create_date transaction_create_date
3516: FROM ozf_funds_all_b AD,
3517: bim_r_fdsp_load AU,
3518: (SELECT
3519: D.business_unit_id business_unit_id,D.org_id org_id,
3520: 'CAMP' object_type_J,'CAMP' object_type, D.campaign_id object_id

Line 3711: FROM ozf_funds_all_b AD,

3707: NVL(AU.paid_amt,0) paid_amt,
3708: AU.object_id object_id,
3709: U.object_type object_type,
3710: AU.transaction_create_date transaction_create_date
3711: FROM ozf_funds_all_b AD,
3712: bim_r_fdsp_load AU,
3713: (SELECT
3714: D.business_unit_id business_unit_id,D.org_id org_id,
3715: 'CAMP' object_type_J,'CAMP' object_type, D.campaign_id object_id

Line 3898: ozf_funds_all_b f,

3894: FROM (
3895: SELECT distinct a.fund_id fund_id,
3896: TRUNC(b.trdate) trdate
3897: FROM bim_r_fdsp_daily_facts a,
3898: ozf_funds_all_b f,
3899: bim_intl_dates b
3900: WHERE b.trdate between greatest(p_start_datel, f.start_date_active)
3901: and least(p_end_datel, nvl(f.end_date_active,p_end_datel))
3902: and f.fund_id = a.fund_id

Line 4082: FROM ozf_funds_all_b a,

4078: b2.fis_month,
4079: b2.fis_qtr,
4080: b2.fis_year,
4081: a.business_unit_id
4082: FROM ozf_funds_all_b a,
4083: (SELECT distinct(fund_id) fund_id,
4084: fis_month fis_month,
4085: fis_qtr fis_qtr,
4086: fis_year fis_year,