APPS.OZF_CUST_FACTS_PVT dependencies on OZF_TIME_RPT_STRUCT

Line 200: FROM ozf_time_rpt_struct a,

196: p_bill_to_site_use_id NUMBER,
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

Line 240: FROM ozf_time_rpt_struct a,

236: p_bill_to_site_use_id NUMBER,
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,

Line 261: FROM ozf_time_rpt_struct a,

257: p_ship_to_site_use_id NUMBER,
258: p_item_id NUMBER ) IS
259: SELECT b.period_type_id,
260: NVL(SUM(b.baseline_sales),0) base_sales
261: FROM ozf_time_rpt_struct a,
262: ozf_baseline_sales_v b
263: WHERE a.report_date = p_report_date
264: AND BITAND(a.record_type_id, 119) = a.record_type_id
265: AND a.time_id = b.time_id

Line 1803: FROM ozf_time_rpt_struct a,

1799: CURSOR xtd_sales_csr ( p_record_type_id NUMBER,
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

Line 2091: FROM ozf_time_rpt_struct a,

2087: CURSOR xtd_sales_csr (p_fund_id NUMBER,
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

Line 3797: ozf_time_rpt_struct rpt

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
3801: and prod.attribute_value = sales.inventory_item_id

Line 3951: ozf_time_rpt_struct rpt

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 )
3955: = rpt.record_type_id