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_CUSTOMERS

Line 116: from ozf_forecast_customers cust,

112: prod.product_attribute_context,
113: prod.product_attribute,
114: prod.product_attr_value,
115: prod.product_id inventory_item_id
116: from ozf_forecast_customers cust,
117: ozf_forecast_products prod
118: where prod.obj_type = p_obj_type
119: and prod.obj_id = p_obj_id
120: and prod.obj_type = cust.obj_type

Line 1321: DELETE FROM ozf_forecast_customers

1317: END IF;
1318:
1319: x_return_status := FND_API.g_ret_sts_success;
1320:
1321: DELETE FROM ozf_forecast_customers
1322: WHERE obj_type = p_obj_type
1323: AND obj_id = p_obj_id ;
1324:
1325: FOR i IN c_groups LOOP

Line 1328: FND_DSQL.add_text('INSERT INTO ozf_forecast_customers( ');

1324:
1325: FOR i IN c_groups LOOP
1326:
1327: FND_DSQL.init;
1328: FND_DSQL.add_text('INSERT INTO ozf_forecast_customers( ');
1329: FND_DSQL.add_text('forecast_customer_id, ');
1330: FND_DSQL.add_text('obj_type, ');
1331: FND_DSQL.add_text('obj_id, ');
1332: FND_DSQL.add_text('qualifier_grouping_no, ');

Line 1362: FND_DSQL.add_text('ozf_forecast_customers_s.nextval ,');

1358: END IF ;
1359: END LOOP;
1360: */
1361: FND_DSQL.add_text(' SELECT ');
1362: FND_DSQL.add_text('ozf_forecast_customers_s.nextval ,');
1363: FND_DSQL.add_bind(p_obj_type);
1364: FND_DSQL.add_text(',');
1365: FND_DSQL.add_bind(p_obj_id);
1366: FND_DSQL.add_text(',');

Line 1760: ozf_forecast_customers mkt,

1756: null, null)
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

Line 3339: from ozf_forecast_customers cust,

3335: prod.product_attribute_context,
3336: prod.product_attribute,
3337: prod.product_attr_value,
3338: prod.product_id inventory_item_id
3339: from ozf_forecast_customers cust,
3340: ozf_forecast_products prod
3341: where prod.obj_type = p_obj_type
3342: and prod.obj_id = p_obj_id
3343: and prod.obj_type = cust.obj_type

Line 4012: from ozf_forecast_customers cust,

4008: prod.product_attribute_context,
4009: prod.product_attribute,
4010: prod.product_attr_value,
4011: prod.product_id inventory_item_id
4012: from ozf_forecast_customers cust,
4013: ozf_forecast_products prod
4014: where prod.obj_type = p_obj_type
4015: and prod.obj_id = p_obj_id
4016: and prod.obj_type = cust.obj_type