APPS.OZF_CUST_FACTS_PVT dependencies on OZF_TIME_ALLOCATIONS

Line 890: ,ozf_time_allocations c1

886:
887: CURSOR target_csr IS
888: SELECT NVL(SUM(NVL(c1.target,0)),0)
889: FROM ozf_account_allocations b1
890: ,ozf_time_allocations c1
891: ,ozf_funds_all_b d1
892: WHERE b1.allocation_for = 'FUND'
893: AND b1.allocation_for_id = d1.fund_id
894: AND b1.site_use_id = p_site_use_id

Line 976: ,ozf_time_allocations time

972: , NVL(time.target,0) )
973: )
974: FROM ozf_account_allocations cust
975: ,ozf_product_allocations prod
976: ,ozf_time_allocations time
977: ,ozf_funds_all_b quota
978: WHERE
979: -- Customer Filter
980: -- cust.site_use_code = 'SHIP_TO'

Line 1433: ozf_time_allocations b

1429: p_period_type_id NUMBER,
1430: p_time_id NUMBER ) IS
1431: SELECT SUM(b.target)
1432: FROM ozf_account_allocations a,
1433: ozf_time_allocations b
1434: WHERE
1435: b.allocation_for = 'CUST'
1436: AND b.allocation_for_id = a.account_allocation_id
1437: AND b.period_type_id = p_period_type_id

Line 1780: FROM ozf_time_allocations

1776: CURSOR prod_time_allocs_csr ( p_product_allocation_id NUMBER) IS
1777: SELECT time_allocation_id,
1778: time_id,
1779: period_type_id
1780: FROM ozf_time_allocations
1781: WHERE allocation_for = 'PROD'
1782: AND allocation_for_id = p_product_allocation_id;
1783:
1784: CURSOR current_periods_csr IS

Line 1835: ozf_time_allocations c

1831: p_time_id NUMBER ) IS
1832: SELECT NVL(SUM(c.lysp_sales),0)
1833: FROM ozf_account_allocations a,
1834: ozf_product_allocations b,
1835: ozf_time_allocations c
1836: WHERE a.account_allocation_id = p_account_allocation_id
1837: AND b.allocation_for = 'CUST'
1838: AND b.allocation_for_id = a.account_allocation_id
1839: AND b.item_type <> 'OTHERS'

Line 1958: UPDATE ozf_time_allocations

1954: -- dbms_output.put_line('l_sales for others '|| l_sales );
1955:
1956: END IF;
1957:
1958: UPDATE ozf_time_allocations
1959: SET lysp_sales = l_sales
1960: WHERE time_allocation_id = time.time_allocation_id;
1961:
1962: l_product_sales := l_product_sales + l_sales;

Line 1985: UPDATE ozf_time_allocations c

1981: -- dbms_output.put_line('l_acct_sales '|| acct.account_allocation_id || ' ' || l_acct_sales);
1982: -- Before moving to next acccout, update the time allocations
1983: -- for this account.
1984:
1985: UPDATE ozf_time_allocations c
1986: SET lysp_sales = ( SELECT sum(b.lysp_sales)
1987: FROM ozf_product_allocations a,
1988: ozf_time_allocations b
1989: WHERE a.allocation_for = 'CUST'

Line 1988: ozf_time_allocations b

1984:
1985: UPDATE ozf_time_allocations c
1986: SET lysp_sales = ( SELECT sum(b.lysp_sales)
1987: FROM ozf_product_allocations a,
1988: ozf_time_allocations b
1989: WHERE a.allocation_for = 'CUST'
1990: AND a.allocation_for_id = acct.account_allocation_id
1991: AND b.allocation_for = 'PROD'
1992: AND b.allocation_for_id = a.product_allocation_id

Line 3815: ,ozf_time_allocations c

3811: c.period_type_id ,
3812: c.time_id) target
3813: FROM ozf_product_allocations a
3814: ,ozf_account_allocations b
3815: ,ozf_time_allocations c
3816: ,ozf_search_selections_t acct
3817: ,ozf_search_selections_t prod
3818: WHERE acct.search_type = 'QUALIFIER'
3819: AND prod.search_type = 'ITEM'

Line 3835: ozf_time_allocations b

3831:
3832: CURSOR quota_csr IS
3833: SELECT SUM(NVL(b.target,0))
3834: FROM ozf_account_allocations a,
3835: ozf_time_allocations b
3836: WHERE a.allocation_for = 'FUND'
3837: AND a.allocation_for_id IN (
3838: SELECT fund_id
3839: FROM ozf_funds_all_b

Line 3993: ozf_time_allocations b

3989: -- Same cursor as refesh_kpi
3990: CURSOR quota_csr IS
3991: SELECT SUM(b.target)
3992: FROM ozf_account_allocations a,
3993: ozf_time_allocations b
3994: WHERE
3995: b.allocation_for = 'CUST'
3996: AND b.allocation_for_id = a.account_allocation_id
3997: AND b.period_type_id = p_period_type_id