[Home] [Help]
2086: CURSOR c_products(l_list_line_id NUMBER, l_excluder_flag VARCHAR2) IS
2087: SELECT product_attribute_context,
2088: product_attribute,
2089: product_attr_value
2090: FROM qp_pricing_attributes
2091: WHERE list_header_id = p_list_header_id
2092: AND list_line_id = l_list_line_id
2093: AND excluder_flag = l_excluder_flag;
2094:
2112: OR end_date_active >= SYSDATE);
2113:
2114: CURSOR c_no_excl_products(l_list_line_id NUMBER) IS
2115: SELECT COUNT(*)
2116: FROM qp_pricing_attributes
2117: WHERE list_header_id = p_list_header_id
2118: AND list_line_id = l_list_line_id
2119: AND excluder_flag = 'Y';
2120:
2439: SELECT 'Y'
2440: FROM DUAL
2441: WHERE EXISTS (
2442: SELECT 1
2443: FROM qp_pricing_attributes
2444: WHERE last_update_date > l_date
2445: AND list_header_id = l_list_header_id
2446: );
2447:
2556: FROM
2557: ozf_act_forecasts_all fc,
2558: ozf_act_metric_facts_all fm,
2559: ozf_forecast_dimentions fp,
2560: qp_pricing_attributes qa,
2561: qp_list_lines ql,
2562: ozf_offers ao
2563: WHERE fp.obj_id = l_offer_id
2564: and fp.obj_type = 'OFFR'
3044: /* the following has to modified to read from ozf_offer_discount_products to handle volume offers */
3045: IF l_stmt_product IS NOT NULL THEN
3046: -- FND_DSQL.add_text(' UNION SELECT distinct discount_line_id,apply_discount,include_volume, to_number(decode(product_attr_value,''ALL'',''-9999'',product_attr_value)) product_id, ');
3047: FND_DSQL.add_text(' UNION ALL SELECT distinct null items_category, to_number(decode(product_attr_value,''ALL'',''-9999'',product_attr_value)) product_id, ');
3048: FND_DSQL.add_text(' product_attribute product_type FROM qp_pricing_attributes ');
3049: FND_DSQL.add_text(' WHERE list_header_id = ');
3050: FND_DSQL.add_bind(i.object_id);
3051: FND_DSQL.add_text(' AND list_line_id = ');
3052: FND_DSQL.add_bind(x.lline_id);
3395: IF l_stmt_product IS NOT NULL THEN
3396: --FND_DSQL.add_text(')');
3397: --FND_DSQL.add_text(' UNION SELECT distinct discount_line_id,apply_discount,include_volume, to_number(decode(product_attr_value,''ALL'',''-9999'',product_attr_value)) product_id, ');
3398: FND_DSQL.add_text(' UNION ALL SELECT distinct null items_category, to_number(decode(product_attr_value,''ALL'',''-9999'',product_attr_value)) product_id, ');
3399: FND_DSQL.add_text(' product_attribute product_type FROM qp_pricing_attributes ');
3400: FND_DSQL.add_text(' WHERE list_header_id = ');
3401: FND_DSQL.add_bind(x.lline_id);
3402: FND_DSQL.add_text(' and product_attribute <> ''PRICING_ATTRIBUTE1'' AND excluder_flag = ''N'')');
3403:
3609: IF l_stmt_product IS NOT NULL THEN
3610: --FND_DSQL.add_text(')');
3611: -- FND_DSQL.add_text(' UNION SELECT distinct discount_line_id,apply_discount,include_volume,to_number(decode(product_attr_value,''ALL'',''-9999'',product_attr_value)) product_id, ');
3612: FND_DSQL.add_text(' UNION ALL SELECT distinct null items_category, to_number(decode(product_attr_value,''ALL'',''-9999'',product_attr_value)) product_id, ');
3613: FND_DSQL.add_text(' product_attribute product_type FROM qp_pricing_attributes ');
3614: FND_DSQL.add_text(' WHERE list_header_id = ');
3615: FND_DSQL.add_bind(i.object_id);
3616: FND_DSQL.add_text(' AND list_line_id = ');
3617: FND_DSQL.add_bind(x.lline_id);
4385: FROM
4386: ozf_act_forecasts_all fc,
4387: ozf_act_metric_facts_all fm,
4388: ozf_forecast_dimentions fp,
4389: qp_pricing_attributes qa,
4390: qp_list_lines ql,
4391: ozf_offers ao
4392: WHERE fp.obj_id = l_offer_id
4393: and fp.obj_type = 'OFFR'