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.OZF_FUND_RECONCILE_PVT dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 1132: FROM ozf_funds_utilized_all_b

1128: ,p_start_date IN DATE
1129: ,p_end_date IN DATE
1130: ) IS
1131: SELECT SUM (NVL(plan_curr_amount,0)) utilized_amt
1132: FROM ozf_funds_utilized_all_b
1133: WHERE plan_id = p_object_id
1134: AND plan_type = 'OFFR'
1135: AND fund_id = p_budget_id
1136: -- AND utilization_type NOT IN ('TRANSFER', 'REQUEST')

Line 1712: FROM ozf_funds_utilized_all_b a1

1708: a1.activity_product_id,a1.cust_account_id,a1.gl_posted_flag,a1.utilization_id orig_utilization_id
1709: ,a1.exchange_rate_type ,a1.exchange_rate_date,a1.org_id --Added for bug 7030415
1710: ,a1.fund_request_currency_code,a1.plan_currency_code
1711: ,a1.object_type, a1.object_id, a1.order_line_id -- Added for FP 13252796
1712: FROM ozf_funds_utilized_all_b a1
1713: WHERE a1.component_id = p_budget_used_by_id
1714: AND a1.component_type = p_budget_used_by_type
1715: AND a1.utilization_type IN -- feliu on 11/11/05: remove UTILIZED and SALES ACCRUAL.
1716: ('ADJUSTMENT', 'ACCRUAL','CHARGEBACK','LEAD_ACCRUAL') -- yzhao: 11.5.10 added chargeback