eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_CUST_FACTS_PVT dependencies on OZF_PRODUCT_ALLOCATIONS

Line 25: ,ozf_product_allocations c

21: c.item_id item_id ,
22: c.item_type item_type
23: FROM ozf_funds_all_b a
24: ,ozf_account_allocations b
25: ,ozf_product_allocations c
26: WHERE a.fund_type = 'QUOTA'
27: --AND p_report_date BETWEEN a.start_date_active
28: -- AND a.end_date_active
29: AND a.status_code <> 'CANCELLED'

Line 113: ozf_product_allocations prod,

109: acct.site_use_id SHIP_TO_SITE_USE_ID,
110: prod.item_type PRODUCT_ATTRIBUTE,
111: prod.item_id PRODUCT_ATTR_VALUE
112: FROM ozf_account_allocations acct,
113: ozf_product_allocations prod,
114: (SELECT DISTINCT a.owner
115: FROM ozf_funds_all_b a
116: WHERE a.fund_type = 'QUOTA'
117: AND a.status_code <> 'CANCELLED') fund

Line 975: ,ozf_product_allocations prod

971: p_report_date)
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

Line 1498: ozf_product_allocations prod

1494: SUM(fact.qtd_sales) QTD_SALES,
1495: SUM(fact.ytd_sales) YTD_SALES
1496: FROM ozf_cust_daily_facts fact,
1497: ozf_account_allocations site,
1498: ozf_product_allocations prod
1499: WHERE fact.report_date = p_report_date
1500: AND fact.ship_to_site_use_id = site.site_use_id
1501: AND fact.product_attribute <> 'OTHERS'
1502: AND fact.product_attribute = prod.item_type

Line 1771: FROM ozf_product_allocations

1767: CURSOR acct_prod_allocs_csr ( p_account_allocation_id NUMBER) IS
1768: SELECT product_allocation_id,
1769: item_type,
1770: item_id
1771: FROM ozf_product_allocations
1772: WHERE allocation_for = 'CUST'
1773: AND allocation_for_id = p_account_allocation_id
1774: ORDER BY item_id DESC ;
1775:

Line 1834: ozf_product_allocations b,

1830: CURSOR acct_time_sales_csr ( p_account_allocation_id NUMBER,
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

Line 1966: UPDATE ozf_product_allocations

1962: l_product_sales := l_product_sales + l_sales;
1963:
1964: END LOOP; -- End of prod_time_allocs_csr
1965: --
1966: UPDATE ozf_product_allocations
1967: SET lysp_sales = l_product_sales
1968: WHERE product_allocation_id = prod.product_allocation_id;
1969:
1970: l_acct_sales := l_acct_sales + l_product_sales;

Line 1987: FROM ozf_product_allocations a,

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'
1990: AND a.allocation_for_id = acct.account_allocation_id
1991: AND b.allocation_for = 'PROD'

Line 2333: ozf_product_allocations prod

2329: AND Kpi.report_date = c.report_date
2330: AND EXISTS (
2331: SELECT 1
2332: FROM ozf_account_allocations acct,
2333: ozf_product_allocations prod
2334: WHERE acct.site_use_id = c.ship_to_site_use_id
2335: AND prod.item_type = c.product_attribute
2336: AND prod.item_id = c.product_attr_value
2337: AND prod.allocation_for = 'CUST'

Line 2434: ozf_product_allocations prod

2430: AND Kpi.report_date = c.report_date
2431: AND EXISTS (
2432: SELECT 1
2433: FROM ozf_account_allocations acct,
2434: ozf_product_allocations prod
2435: WHERE acct.site_use_id = c.ship_to_site_use_id
2436: AND prod.item_type = c.product_attribute
2437: AND prod.item_id = c.product_attr_value
2438: AND prod.allocation_for = 'CUST'

Line 2535: ozf_product_allocations prod

2531: AND Kpi.report_date = c.report_date
2532: AND EXISTS (
2533: SELECT 1
2534: FROM ozf_account_allocations acct,
2535: ozf_product_allocations prod
2536: WHERE acct.site_use_id = c.ship_to_site_use_id
2537: AND prod.item_type = c.product_attribute
2538: AND prod.item_id = c.product_attr_value
2539: AND prod.allocation_for = 'CUST'

Line 2635: ozf_product_allocations prod

2631: AND c.product_attribute <> 'OTHERS'
2632: AND EXISTS (
2633: SELECT 1
2634: FROM ozf_account_allocations acct,
2635: ozf_product_allocations prod
2636: WHERE acct.site_use_id = c.ship_to_site_use_id
2637: AND prod.item_type = c.product_attribute
2638: AND prod.item_id = c.product_attr_value
2639: AND prod.allocation_for = 'CUST'

Line 3813: FROM ozf_product_allocations a

3809: SELECT ozf_cust_facts_pvt.get_cust_target ( b.site_use_id,
3810: b.bill_to_site_use_id,
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

Line 3949: ozf_product_allocations prod,

3945: CURSOR sales_csr (p_as_of_date IN DATE,
3946: p_record_type_id IN NUMBER) IS
3947: SELECT NVL(SUM(NVL(sales.sales,0)),0)
3948: FROM ozf_account_allocations acct,
3949: ozf_product_allocations prod,
3950: ozf_order_sales_v sales,
3951: ozf_time_rpt_struct rpt
3952: WHERE
3953: rpt.report_date = p_as_of_date