APPS.OZF_ALLOCATION_ENGINE_PVT dependencies on OZF_FUNDS_ALL_B

Line 10560: FROM OZF_FUNDS_ALL_b FF

10556: CURSOR terr_list_csr
10557: IS
10558: SELECT DISTINCT
10559: FF.NODE_ID
10560: FROM OZF_FUNDS_ALL_b FF
10561: WHERE
10562: FF.FUND_TYPE = 'QUOTA'
10563: AND FF.STATUS_CODE <> 'CANCELLED'
10564: AND FF.NODE_ID = NVL(p_terr_id, FF.NODE_ID)

Line 10580: FROM OZF_FUNDS_ALL_b FF

10576: -- also change terr denorm such that adjust_acct is called only from LOAD_ procedure
10577: ------------------------------------------------------------------------------------
10578:
10579: SELECT DISTINCT FF.NODE_ID
10580: FROM OZF_FUNDS_ALL_b FF
10581: WHERE
10582: FF.FUND_TYPE = 'QUOTA'
10583: AND FF.STATUS_CODE <> 'CANCELLED'
10584: AND FF.NODE_ID = NVL(p_terr_id, FF.NODE_ID)

Line 10595: FROM OZF_FUNDS_ALL_b FF

10591: ----------
10592: UNION ALL
10593: ----------
10594: SELECT DISTINCT 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 EXISTS

Line 10608: from ozf_funds_all_b outer

10604: )
10605: AND FF.NODE_ID IN
10606: (
10607: select distinct node_id
10608: from ozf_funds_all_b outer
10609: where not exists (select 'x' from ozf_funds_all_b inner where inner.parent_fund_id = outer.fund_id)
10610: connect by prior fund_id = parent_fund_id
10611: start with parent_fund_id = (select inner2.fund_id
10612: from ozf_funds_all_b inner2

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

10605: AND FF.NODE_ID IN
10606: (
10607: select distinct node_id
10608: from ozf_funds_all_b outer
10609: where not exists (select 'x' from ozf_funds_all_b inner where inner.parent_fund_id = outer.fund_id)
10610: connect by prior fund_id = parent_fund_id
10611: start with parent_fund_id = (select inner2.fund_id
10612: from ozf_funds_all_b inner2
10613: where inner2.node_id = p_terr_id -- 3104

Line 10612: from ozf_funds_all_b inner2

10608: from ozf_funds_all_b outer
10609: where not exists (select 'x' from ozf_funds_all_b inner where inner.parent_fund_id = outer.fund_id)
10610: connect by prior fund_id = parent_fund_id
10611: start with parent_fund_id = (select inner2.fund_id
10612: from ozf_funds_all_b inner2
10613: where inner2.node_id = p_terr_id -- 3104
10614: and inner2.fund_type = 'QUOTA'
10615: and inner2.status_code <> 'CANCELLED'
10616: and rownum = 1

Line 10721: FROM OZF_FUNDS_ALL_b FF

10717:
10718: CURSOR add_quota_list_csr (l_terr_id NUMBER, l_ship_to_id NUMBER) IS
10719: SELECT
10720: FF.FUND_ID
10721: FROM OZF_FUNDS_ALL_b FF
10722: WHERE
10723: FF.FUND_TYPE = 'QUOTA'
10724: AND FF.STATUS_CODE <> 'CANCELLED'
10725: AND FF.NODE_ID = l_terr_id

Line 10737: FROM OZF_FUNDS_ALL_b FF

10733:
10734: CURSOR del_quota_list_csr (l_terr_id NUMBER, l_ship_to_id NUMBER) IS
10735: SELECT
10736: FF.FUND_ID
10737: FROM OZF_FUNDS_ALL_b FF
10738: WHERE
10739: FF.FUND_TYPE = 'QUOTA'
10740: AND FF.STATUS_CODE <> 'CANCELLED'
10741: AND FF.NODE_ID = l_terr_id

Line 10774: from ozf_act_metric_facts_all a, OZF_FUNDS_ALL_b FF

10770: a.act_metric_used_by_id,
10771: a.node_id,
10772: a.previous_fact_id,
10773: a.activity_metric_fact_id
10774: from ozf_act_metric_facts_all a, OZF_FUNDS_ALL_b FF
10775: where a.arc_act_metric_used_by = 'FUND'
10776: and a.activity_metric_id = l_allocation_id
10777: --and a.level_depth = l_level_depth
10778: and a.node_id = FF.NODE_ID

Line 10942: FROM ozf_account_allocations aa, ozf_funds_all_b ff

10938: aa.bill_to_site_use_id,
10939: aa.bill_to_location_id,
10940: aa.parent_party_id,
10941: aa.rollup_party_id
10942: FROM ozf_account_allocations aa, ozf_funds_all_b ff
10943: WHERE FF.FUND_TYPE = 'QUOTA'
10944: AND FF.STATUS_CODE <> 'CANCELLED'
10945: AND aa.allocation_for = 'FUND'
10946: AND aa.allocation_for_id = FF.FUND_ID