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_FORECAST_UTIL_PVT dependencies on OZF_FORECAST_PERIODS

Line 91: FROM ozf_forecast_periods

87: SELECT period_number,
88: start_date,
89: end_date,
90: period_type_id
91: FROM ozf_forecast_periods
92: WHERE obj_type = p_obj_type
93: AND obj_id = p_object_id
94: AND period_number = NVL(p_period_number, period_number)
95: AND (forecast_id IS NULL -- inanaiah: For compatibility with older release

Line 1557: DELETE FROM ozf_forecast_periods

1553: return;
1554: END IF;
1555:
1556: -- inanaiah: R12 - delete records only of the forecast being refered otherwise the reference needed is lost when creating new version
1557: DELETE FROM ozf_forecast_periods
1558: WHERE obj_id = p_obj_id
1559: AND obj_type = p_obj_type
1560: AND forecast_id = p_forecast_id;
1561:

Line 1614: INSERT INTO ozf_forecast_periods (

1610: THEN
1611: l_temp_end_date := p_end_date;
1612: END IF;
1613:
1614: INSERT INTO ozf_forecast_periods (
1615: forecast_period_id,
1616: obj_type,
1617: obj_id,
1618: period_number,

Line 1629: VALUES ( ozf_forecast_periods_s.nextval,

1625: last_update_login,
1626: period_type_id,
1627: period_name,
1628: forecast_id)
1629: VALUES ( ozf_forecast_periods_s.nextval,
1630: p_obj_type,
1631: p_obj_id,
1632: l_period_number,
1633: l_temp_start_date,

Line 1761: ozf_forecast_periods time,

1757: )
1758: from ozf_forecast_dimentions dim,
1759: ozf_forecast_products prod,
1760: ozf_forecast_customers mkt,
1761: ozf_forecast_periods time,
1762: ams_base_sales_mv bs
1763: where dim.obj_type = p_obj_type
1764: and dim.obj_id = p_obj_id
1765: and dim.obj_type = prod.obj_type

Line 1832: FROM ozf_forecast_periods

1828: --ADD_MONTHS(start_date,12) start_date,
1829: --ADD_MONTHS(end_date,12) end_date
1830: start_date,
1831: end_date
1832: FROM ozf_forecast_periods
1833: --WHERE obj_type = p_obj_type
1834: WHERE obj_type = 'DISP'
1835: AND obj_id = p_obj_id
1836: AND (forecast_id IS NULL -- inanaiah: For compatibility with older release

Line 1842: FROM ozf_forecast_periods

1838:
1839: -- inanaiah: used to divide the time spread base sales
1840: CURSOR get_count_periods(p_id IN NUMBER) IS
1841: SELECT count(forecast_period_id)
1842: FROM ozf_forecast_periods
1843: WHERE obj_type = p_obj_type
1844: AND obj_id = p_id
1845: AND (forecast_id IS NULL -- inanaiah: For compatibility with older release
1846: OR forecast_id = p_forecast_id); -- inanaiah: making periods bound to forecast_id as is the case when creating new version

Line 1851: FROM ozf_forecast_periods

1847:
1848: -- inanaiah: used to get the time spread base sales
1849: CURSOR get_sales_period(p_id IN NUMBER) IS
1850: SELECT period_number
1851: FROM ozf_forecast_periods
1852: WHERE obj_type = p_obj_type -- 'OFFR'
1853: AND obj_id = p_id
1854: AND (forecast_id IS NULL -- inanaiah: For compatibility with older release
1855: OR forecast_id = p_forecast_id); -- inanaiah: making periods bound to forecast_id as is the case when creating new version

Line 3139: FROM ozf_forecast_periods

3135: SELECT period_number,
3136: start_date,
3137: end_date,
3138: period_type_id
3139: FROM ozf_forecast_periods
3140: WHERE obj_type = p_obj_type
3141: AND obj_id = p_obj_id;
3142:
3143: CURSOR get_sales_period IS

Line 3145: FROM ozf_forecast_periods

3141: AND obj_id = p_obj_id;
3142:
3143: CURSOR get_sales_period IS
3144: SELECT period_number
3145: FROM ozf_forecast_periods
3146: WHERE obj_type = p_obj_type -- 'OFFR'
3147: AND obj_id = p_obj_id
3148: AND (forecast_id IS NULL -- inanaiah: For compatibility with older release
3149: OR forecast_id = p_forecast_id); -- inanaiah: making periods bound to forecast_id as is the case when creating new version ;

Line 3348: ozf_forecast_periods period

3344: and prod.obj_id = cust.obj_id
3345: and cust.site_use_code = 'SHIP_TO'
3346: ) cust_prod,
3347: ozf_forecast_dimentions dim,
3348: ozf_forecast_periods period
3349: where dim.obj_type = p_obj_type
3350: and dim.obj_id = p_obj_id
3351: AND dim.forecast_id = p_forecast_id
3352: and dim.product_attribute_context = cust_prod.product_attribute_context

Line 3644: FROM ozf_forecast_periods

3640: SELECT period_number,
3641: start_date,
3642: end_date,
3643: period_type_id
3644: FROM ozf_forecast_periods
3645: WHERE obj_type = p_obj_type
3646: AND obj_id = p_obj_id;
3647:
3648: CURSOR get_sales_period IS

Line 3650: FROM ozf_forecast_periods

3646: AND obj_id = p_obj_id;
3647:
3648: CURSOR get_sales_period IS
3649: SELECT period_number
3650: FROM ozf_forecast_periods
3651: WHERE obj_type = p_obj_type -- 'OFFR'
3652: AND obj_id = p_obj_id
3653: AND (forecast_id IS NULL -- inanaiah: For compatibility with older release
3654: OR forecast_id = p_forecast_id); -- inanaiah: making periods bound to forecast_id as is the case when creating new version ;

Line 4021: ozf_forecast_periods period

4017: and prod.obj_id = cust.obj_id
4018: and cust.site_use_code = 'SHIP_TO'
4019: ) cust_prod,
4020: ozf_forecast_dimentions dim,
4021: ozf_forecast_periods period
4022: where dim.obj_type = p_obj_type
4023: and dim.obj_id = p_obj_id
4024: AND dim.forecast_id = p_forecast_id
4025: and dim.product_attribute_context = cust_prod.product_attribute_context