APPS.OZF_CUST_FACTS_PVT dependencies on OZF_ORDER_SALES_V

Line 201: ozf_order_sales_v b

197: p_inventory_item_id NUMBER ) IS
198: SELECT a.period_type_id,
199: NVL(SUM(b.sales),0) tot_sales
200: FROM ozf_time_rpt_struct a,
201: ozf_order_sales_v b
202: WHERE a.report_date = p_report_date
203: AND BITAND(a.record_type_id, 119) = a.record_type_id
204: AND a.time_id = b.time_id
205: AND b.cust_account_id = p_cust_account_id

Line 241: ozf_order_sales_v b,

237: p_inventory_item_id NUMBER,
238: p_period_type_id NUMBER ) IS
239: SELECT NVL(SUM(b.sales),0) tot_sales
240: FROM ozf_time_rpt_struct a,
241: ozf_order_sales_v b,
242: ozf_time_day c
243: WHERE c.report_date = p_report_date
244: AND a.time_id = decode(p_period_type_id,32,c.ent_period_id,
245: 64, c.ent_qtr_id,

Line 1794: FROM ozf_order_sales_v

1790: CURSOR sales_csr( p_time_id NUMBER,
1791: p_site_use_id NUMBER,
1792: p_inventory_item_id NUMBER ) IS
1793: SELECT NVL(SUM(sales),0)
1794: FROM ozf_order_sales_v
1795: WHERE time_id = p_time_id
1796: AND ship_to_site_use_id = p_site_use_id
1797: AND inventory_item_id = DECODE(p_inventory_item_id,-9999,inventory_item_id,p_inventory_item_id);
1798:

Line 1804: ozf_order_sales_v b

1800: p_site_use_id NUMBER,
1801: p_inventory_item_id NUMBER) IS
1802: SELECT NVL(SUM(sales),0)
1803: FROM ozf_time_rpt_struct a,
1804: ozf_order_sales_v b
1805: WHERE a.report_date = p_report_date
1806: AND BITAND(a.record_type_id, p_record_type_id) = a.record_type_id
1807: AND a.time_id = b.time_id
1808: AND b.ship_to_site_use_id = p_site_use_id

Line 2092: ozf_order_sales_v b,

2088: p_as_of_date DATE )
2089: IS
2090: SELECT NVL(SUM(b.sales),0) tot_sales
2091: FROM ozf_time_rpt_struct a,
2092: ozf_order_sales_v b,
2093: ozf_account_allocations c
2094: WHERE c.allocation_for = 'FUND'
2095: AND c.allocation_for_id = p_fund_id
2096: AND b.ship_to_site_use_id = c.site_use_id

Line 3796: ozf_order_sales_v sales,

3792: p_record_type_id IN NUMBER) IS
3793: SELECT SUM(sales.sales)
3794: FROM ozf_search_selections_t acct,
3795: ozf_search_selections_t prod,
3796: ozf_order_sales_v sales,
3797: ozf_time_rpt_struct rpt
3798: where acct.search_type = 'QUALIFIER'
3799: and prod.search_type = 'ITEM'
3800: and acct.attribute_value = sales.ship_to_site_use_id

Line 3950: ozf_order_sales_v sales,

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
3954: AND BITAND(rpt.record_type_id, p_record_type_id )