APPS.OZF_FORECAST_UTIL_PVT dependencies on OZF_FORECAST_PRODUCTS

Line 117: ozf_forecast_products prod

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
121: and prod.obj_id = cust.obj_id

Line 1033: delete from ozf_forecast_products

1029: END IF;
1030:
1031: x_return_status := FND_API.g_ret_sts_success;
1032:
1033: delete from ozf_forecast_products
1034: where obj_type = p_obj_type
1035: and obj_id = p_obj_id ;
1036:
1037: /*

Line 1046: FND_DSQL.add_text('INSERT INTO ozf_forecast_products( ');

1042: l_prod_index := 1;
1043: */
1044: FOR i IN c_products LOOP
1045: FND_DSQL.init;
1046: FND_DSQL.add_text('INSERT INTO ozf_forecast_products( ');
1047: FND_DSQL.add_text('forecast_product_id, ');
1048: FND_DSQL.add_text('obj_type, ');
1049: FND_DSQL.add_text('obj_id, ');
1050: FND_DSQL.add_text('product_attribute_context, ');

Line 1061: FND_DSQL.add_text('ozf_forecast_products_s.nextval,');

1057: FND_DSQL.add_text('last_updated_by , ');
1058: FND_DSQL.add_text('last_update_login )');
1059:
1060: FND_DSQL.add_text(' SELECT ');
1061: FND_DSQL.add_text('ozf_forecast_products_s.nextval,');
1062: FND_DSQL.add_bind(p_obj_type);
1063: FND_DSQL.add_text(',');
1064: FND_DSQL.add_bind(p_obj_id);
1065: FND_DSQL.add_text(',');

Line 1759: ozf_forecast_products prod,

1755: p_fcst_uom,
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

Line 3340: ozf_forecast_products prod

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
3344: and prod.obj_id = cust.obj_id

Line 4013: ozf_forecast_products prod

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
4017: and prod.obj_id = cust.obj_id

Line 8140: FROM ozf_forecast_products

8136: l_flag_error boolean := false;
8137: /*
8138: CURSOR c_products IS
8139: SELECT product_id
8140: FROM ozf_forecast_products
8141: WHERE obj_type = p_obj_type
8142: AND obj_id = p_obj_id
8143: AND product_attribute_context = 'ITEM'
8144: AND product_attribute = p_product_attribute

Line 8150: FROM ozf_forecast_products prod,

8146: */
8147: CURSOR c_products (p_org_id NUMBER) IS
8148: SELECT prod.product_id,
8149: inv_prod.primary_uom_code
8150: FROM ozf_forecast_products prod,
8151: mtl_system_items_b inv_prod
8152: WHERE prod.obj_type = p_obj_type
8153: AND prod.obj_id = p_obj_id
8154: AND product_attribute_context = 'ITEM'

Line 9262: FROM ozf_forecast_products p,

9258: DECODE(line.line_category_code,
9259: 'ORDER', -adj.adjusted_amount
9260: , adj.adjusted_amount) adjusted_amount,
9261: adj.accrual_flag
9262: FROM ozf_forecast_products p,
9263: ozf_offers o,
9264: oe_price_adjustments adj,
9265: oe_order_lines_all line
9266: WHERE p.obj_type = p_obj_type