APPS.BIM_FUND_FACTS dependencies on OZF_ACT_BUDGETS

Line 1149: ozf_act_budgets BU1

1145: a.set_of_books_id,
1146: a.currency_code_fc,
1147: a.original_budget
1148: ) ad,
1149: ozf_act_budgets BU1
1150: WHERE bu1.approval_date(+) between ad.tr_date and ad.tr_date + 0.99999
1151: AND bu1.transfer_type in ('TRANSFER','REQUEST')
1152: AND bu1.status_code(+) = 'APPROVED'
1153: AND bu1.arc_act_budget_used_by(+) = 'FUND'

Line 1250: ozf_act_budgets BU2

1246: a.set_of_books_id,
1247: a.currency_code_fc,
1248: a.original_budget
1249: ) ad,
1250: ozf_act_budgets BU2
1251: WHERE bu2.approval_date(+) between ad.tr_date and ad.tr_date + 0.99999
1252: AND bu2.status_code(+) = 'APPROVED'
1253: AND bu2.arc_act_budget_used_by(+) = 'FUND'
1254: AND bu2.budget_source_type(+) ='FUND'

Line 1434: ozf_act_budgets BU1

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')
1438: AND bu1.approval_date

Line 1486: ozf_act_budgets BU2

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 1490: AND bu2.status_code(+) = 'APPROVED'

Line 1613: FROM ozf_act_budgets

1609: 0 standard_discount,
1610: 0 accrual,
1611: 0 market_expense,
1612: 0 paid_amt
1613: FROM ozf_act_budgets
1614: WHERE budget_source_type ='FUND'
1615: AND status_code ='PENDING'
1616: AND ARC_ACT_BUDGET_USED_BY <> 'FUND'
1617: GROUP BY trunc(nvl(request_date ,creation_date)),

Line 1632: FROM ozf_act_budgets

1628: 0 standard_discount,
1629: 0 accrual,
1630: 0 market_expense,
1631: 0 paid_amt
1632: FROM ozf_act_budgets
1633: WHERE budget_source_type ='FUND'
1634: AND ARC_ACT_BUDGET_USED_BY <> 'FUND'
1635: AND status_code ='APPROVED'
1636: GROUP BY trunc(nvl(approval_date,last_update_date)),

Line 1650: FROM ozf_act_budgets

1646: 0 standard_discount,
1647: 0 accrual,
1648: 0 market_expense,
1649: 0 paid_amt
1650: FROM ozf_act_budgets
1651: WHERE arc_act_budget_used_by ='FUND'
1652: AND budget_source_type<>'FUND'
1653: AND status_code ='APPROVED'
1654: GROUP BY trunc(nvl(approval_date,last_update_date)),

Line 2701: ozf_act_budgets BU1

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')
2705: AND bu1.status_code(+) = 'APPROVED'

Line 2750: ozf_act_budgets BU2

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'
2754: AND bu2.arc_act_budget_used_by = 'FUND'

Line 2935: ozf_act_budgets BU1

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
2939: AND bu1.transfer_type in ('TRANSFER','REQUEST')

Line 2985: ozf_act_budgets BU2

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
2989: AND bu2.status_code = 'APPROVED'

Line 3364: FROM ozf_act_budgets

3360: 0 standard_discount,
3361: 0 accrual,
3362: 0 market_expense,
3363: 0 paid_amt
3364: FROM ozf_act_budgets
3365: WHERE budget_source_type ='FUND'
3366: AND status_code ='PENDING'
3367: AND ARC_ACT_BUDGET_USED_BY <> 'FUND'
3368: GROUP BY trunc(nvl(request_date ,creation_date)),

Line 3382: FROM ozf_act_budgets

3378: 0 standard_discount,
3379: 0 accrual,
3380: 0 market_expense,
3381: 0 paid_amt
3382: FROM ozf_act_budgets
3383: WHERE budget_source_type ='FUND'
3384: AND ARC_ACT_BUDGET_USED_BY <> 'FUND'
3385: AND status_code ='APPROVED'
3386: GROUP BY trunc(nvl(approval_date,last_update_date)),

Line 3400: FROM ozf_act_budgets

3396: 0 standard_discount,
3397: 0 accrual,
3398: 0 market_expense,
3399: 0 paid_amt
3400: FROM ozf_act_budgets
3401: WHERE arc_act_budget_used_by ='FUND'
3402: AND budget_source_type<>'FUND'
3403: AND status_code ='APPROVED'
3404: GROUP BY trunc(nvl(approval_date,last_update_date)),