APPS.BIM_FUND_FACTS dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 1669: FROM ozf_funds_utilized_all_b

1665: SUM(decode(component_type,'OFFR', decode(utilization_type, 'ACCRUAL', convert_currency(currency_code,nvl(amount,0)), 0),0) +
1666: decode(component_type,'OFFR', decode(utilization_type, 'ADJUSTMENT', convert_currency(currency_code,nvl(amount,0)), 0),0)) accrual,
1667: SUM(decode(component_type,'OFFR',0, decode(utilization_type, 'UTILIZED', convert_currency(currency_code,nvl(amount,0)), 0))) market_expense,
1668: sum(decode(component_type,'OFFR',0,convert_currency(currency_code,(nvl(amount,0)-NVL(amount_remaining,0))))) paid_amt
1669: FROM ozf_funds_utilized_all_b
1670: WHERE utilization_type in ('UTILIZED','ACCRUAL','ADJUSTMENT')
1671: GROUP BY trunc(creation_date),fund_id,plan_id,plan_type
1672: )
1673: GROUP BY creation_date, fund_id, object_id,object_type

Line 3419: FROM ozf_funds_utilized_all_b

3415: SUM(decode(component_type,'OFFR', decode(utilization_type, 'ACCRUAL', convert_currency(currency_code,nvl(amount,0)), 0),0) +
3416: decode(component_type,'OFFR', decode(utilization_type, 'ADJUSTMENT', convert_currency(currency_code,nvl(amount,0)), 0),0)) accrual,
3417: SUM(decode(component_type,'OFFR',0, decode(utilization_type, 'UTILIZED', convert_currency(currency_code,nvl(amount,0)), 0))) market_expense,
3418: sum(decode(component_type,'OFFR',0,convert_currency(currency_code,(nvl(amount,0)-NVL(amount_remaining,0))))) paid_amt
3419: FROM ozf_funds_utilized_all_b
3420: WHERE utilization_type in ('UTILIZED','ACCRUAL','ADJUSTMENT')
3421: GROUP BY trunc(creation_date),fund_id,plan_id,plan_type
3422: )
3423: GROUP BY creation_date, fund_id, object_id,object_type