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

Line 623: ozf_act_budgets BU1

619: 0 utilized_s,
620: 0 accrual_s,
621: 0 paid_s
622: FROM ozf_funds_all_b ad,
623: ozf_act_budgets BU1
624: WHERE nvl(ad.end_date_active,sysdate) >p_start_date
625: AND bu1.approval_date <= p_end_date
626: AND bu1.transfer_type in ('TRANSFER','REQUEST')
627: AND bu1.status_code = 'APPROVED'

Line 691: ozf_act_budgets BU2

687: 0 utilized_s,
688: 0 accrual_s,
689: 0 paid_s
690: FROM ozf_funds_all_b ad,
691: ozf_act_budgets BU2
692: WHERE nvl(ad.end_date_active,sysdate) >p_start_date
693: AND bu2.approval_date<=p_end_date
694: AND bu2.status_code = 'APPROVED'
695: AND bu2.arc_act_budget_used_by = 'FUND'

Line 756: ozf_act_budgets BU2

752: 0 utilized_s,
753: 0 accrual_s,
754: 0 paid_s
755: FROM ozf_funds_all_b ad,
756: ozf_act_budgets BU2
757: WHERE nvl(ad.end_date_active,sysdate) >p_start_date
758: AND bu2.budget_source_type ='FUND'
759: AND bu2.ARC_ACT_BUDGET_USED_BY <> 'FUND'
760: AND nvl(bu2.request_date,bu2.creation_date) <=p_end_date

Line 820: ozf_act_budgets BU2

816: 0 utilized_s,
817: 0 accrual_s,
818: 0 paid_s
819: FROM ozf_funds_all_b ad,
820: ozf_act_budgets BU2
821: WHERE nvl(ad.end_date_active,sysdate) >p_start_date
822: AND bu2.arc_act_budget_used_by ='FUND'
823: AND bu2.budget_source_type<>'FUND'
824: AND bu2.status_code ='APPROVED'

Line 885: ozf_act_budgets BU2

881: 0 utilized_s,
882: 0 accrual_s,
883: 0 paid_s
884: FROM ozf_funds_all_b ad,
885: ozf_act_budgets BU2
886: WHERE nvl(ad.end_date_active,sysdate) >p_start_date
887: AND bu2.budget_source_type ='FUND'
888: AND bu2.ARC_ACT_BUDGET_USED_BY <> 'FUND'
889: AND bu2.approval_date <=p_end_date

Line 949: ozf_act_budgets BU2

945: 0 utilized_s,
946: 0 accrual_s,
947: 0 paid_s
948: FROM ozf_funds_all_b ad,
949: ozf_act_budgets BU2
950: WHERE nvl(ad.end_date_active,sysdate) >p_start_date
951: AND bu2.arc_act_budget_used_by ='FUND'
952: AND bu2.budget_source_type<>'FUND'
953: AND bu2.status_code ='APPROVED'

Line 1910: ozf_act_budgets BU1

1906: 0 utilized_s,
1907: 0 accrual_s,
1908: 0 paid_s
1909: FROM ozf_funds_all_b ad,
1910: ozf_act_budgets BU1
1911: WHERE bu1.approval_date between p_start_date and p_end_date
1912: AND bu1.transfer_type in ('TRANSFER','REQUEST')
1913: AND bu1.status_code = 'APPROVED'
1914: AND bu1.arc_act_budget_used_by = 'FUND'

Line 1977: ozf_act_budgets BU2

1973: 0 utilized_s,
1974: 0 accrual_s,
1975: 0 paid_s
1976: FROM ozf_funds_all_b ad,
1977: ozf_act_budgets BU2
1978: WHERE bu2.approval_date between p_start_date and p_end_date
1979: AND bu2.status_code = 'APPROVED'
1980: AND bu2.arc_act_budget_used_by = 'FUND'
1981: AND bu2.budget_source_type='FUND'

Line 2041: ozf_act_budgets BU2

2037: 0 utilized_s,
2038: 0 accrual_s,
2039: 0 paid_s
2040: FROM ozf_funds_all_b ad,
2041: ozf_act_budgets BU2
2042: WHERE bu2.request_date between p_start_date and p_end_date
2043: AND bu2.budget_source_type='FUND'
2044: AND bu2.ARC_ACT_BUDGET_USED_BY <> 'FUND'
2045: AND nvl(bu2.request_date,bu2.creation_date) <=p_end_date

Line 2105: ozf_act_budgets BU2

2101: 0 utilized_s,
2102: 0 accrual_s,
2103: 0 paid_s
2104: FROM ozf_funds_all_b ad,
2105: ozf_act_budgets BU2
2106: WHERE bu2.approval_date between p_start_date and p_end_date
2107: AND bu2.arc_act_budget_used_by ='FUND'
2108: AND bu2.budget_source_type<>'FUND'
2109: AND bu2.status_code ='APPROVED'

Line 2169: ozf_act_budgets BU2

2165: 0 utilized_s,
2166: 0 accrual_s,
2167: 0 paid_s
2168: FROM ozf_funds_all_b ad,
2169: ozf_act_budgets BU2
2170: WHERE bu2.approval_date between p_start_date and p_end_date
2171: AND bu2.budget_source_type ='FUND'
2172: AND bu2.ARC_ACT_BUDGET_USED_BY <> 'FUND'
2173: AND bu2.budget_source_id = ad.fund_id

Line 2232: ozf_act_budgets BU2

2228: 0 utilized_s,
2229: 0 accrual_s,
2230: 0 paid_s
2231: FROM ozf_funds_all_b ad,
2232: ozf_act_budgets BU2
2233: WHERE bu2.approval_date between p_start_date and p_end_date
2234: AND bu2.arc_act_budget_used_by ='FUND'
2235: AND bu2.budget_source_type<>'FUND'
2236: AND bu2.status_code ='APPROVED'