APPS.OZF_ALLOCATION_ENGINE_PVT dependencies on OZF_FUNDS_ALL_B

Line 10595: FROM OZF_FUNDS_ALL_b FF

10591: CURSOR terr_list_csr
10592: IS
10593: SELECT DISTINCT
10594: FF.NODE_ID
10595: FROM OZF_FUNDS_ALL_b FF
10596: WHERE
10597: FF.FUND_TYPE = 'QUOTA'
10598: AND FF.STATUS_CODE <> 'CANCELLED'
10599: AND FF.NODE_ID = NVL(p_terr_id, FF.NODE_ID)

Line 10615: FROM OZF_FUNDS_ALL_b FF

10611: -- also change terr denorm such that adjust_acct is called only from LOAD_ procedure
10612: ------------------------------------------------------------------------------------
10613:
10614: SELECT DISTINCT FF.NODE_ID
10615: FROM OZF_FUNDS_ALL_b FF
10616: WHERE
10617: FF.FUND_TYPE = 'QUOTA'
10618: AND FF.STATUS_CODE <> 'CANCELLED'
10619: AND FF.NODE_ID = NVL(p_terr_id, FF.NODE_ID)

Line 10630: FROM OZF_FUNDS_ALL_b FF

10626: ----------
10627: UNION ALL
10628: ----------
10629: SELECT DISTINCT FF.NODE_ID
10630: FROM OZF_FUNDS_ALL_b FF
10631: WHERE
10632: FF.FUND_TYPE = 'QUOTA'
10633: AND FF.STATUS_CODE <> 'CANCELLED'
10634: AND EXISTS

Line 10643: from ozf_funds_all_b outer

10639: )
10640: AND FF.NODE_ID IN
10641: (
10642: select distinct node_id
10643: from ozf_funds_all_b outer
10644: where not exists (select 'x' from ozf_funds_all_b inner where inner.parent_fund_id = outer.fund_id)
10645: connect by prior fund_id = parent_fund_id
10646: start with parent_fund_id = (select inner2.fund_id
10647: from ozf_funds_all_b inner2

Line 10644: where not exists (select 'x' from ozf_funds_all_b inner where inner.parent_fund_id = outer.fund_id)

10640: AND FF.NODE_ID IN
10641: (
10642: select distinct node_id
10643: from ozf_funds_all_b outer
10644: where not exists (select 'x' from ozf_funds_all_b inner where inner.parent_fund_id = outer.fund_id)
10645: connect by prior fund_id = parent_fund_id
10646: start with parent_fund_id = (select inner2.fund_id
10647: from ozf_funds_all_b inner2
10648: where inner2.node_id = p_terr_id -- 3104

Line 10647: from ozf_funds_all_b inner2

10643: from ozf_funds_all_b outer
10644: where not exists (select 'x' from ozf_funds_all_b inner where inner.parent_fund_id = outer.fund_id)
10645: connect by prior fund_id = parent_fund_id
10646: start with parent_fund_id = (select inner2.fund_id
10647: from ozf_funds_all_b inner2
10648: where inner2.node_id = p_terr_id -- 3104
10649: and inner2.fund_type = 'QUOTA'
10650: and inner2.status_code <> 'CANCELLED'
10651: and rownum = 1

Line 10756: FROM OZF_FUNDS_ALL_b FF

10752:
10753: CURSOR add_quota_list_csr (l_terr_id NUMBER, l_ship_to_id NUMBER) IS
10754: SELECT
10755: FF.FUND_ID
10756: FROM OZF_FUNDS_ALL_b FF
10757: WHERE
10758: FF.FUND_TYPE = 'QUOTA'
10759: AND FF.STATUS_CODE <> 'CANCELLED'
10760: AND FF.NODE_ID = l_terr_id

Line 10772: FROM OZF_FUNDS_ALL_b FF

10768:
10769: CURSOR del_quota_list_csr (l_terr_id NUMBER, l_ship_to_id NUMBER) IS
10770: SELECT
10771: FF.FUND_ID
10772: FROM OZF_FUNDS_ALL_b FF
10773: WHERE
10774: FF.FUND_TYPE = 'QUOTA'
10775: AND FF.STATUS_CODE <> 'CANCELLED'
10776: AND FF.NODE_ID = l_terr_id

Line 10809: from ozf_act_metric_facts_all a, OZF_FUNDS_ALL_b FF

10805: a.act_metric_used_by_id,
10806: a.node_id,
10807: a.previous_fact_id,
10808: a.activity_metric_fact_id
10809: from ozf_act_metric_facts_all a, OZF_FUNDS_ALL_b FF
10810: where a.arc_act_metric_used_by = 'FUND'
10811: and a.activity_metric_id = l_allocation_id
10812: --and a.level_depth = l_level_depth
10813: and a.node_id = FF.NODE_ID

Line 10977: FROM ozf_account_allocations aa, ozf_funds_all_b ff

10973: aa.bill_to_site_use_id,
10974: aa.bill_to_location_id,
10975: aa.parent_party_id,
10976: aa.rollup_party_id
10977: FROM ozf_account_allocations aa, ozf_funds_all_b ff
10978: WHERE FF.FUND_TYPE = 'QUOTA'
10979: AND FF.STATUS_CODE <> 'CANCELLED'
10980: AND aa.allocation_for = 'FUND'
10981: AND aa.allocation_for_id = FF.FUND_ID