[Home] [Help]
2052: CURSOR c_products(l_list_line_id NUMBER, l_excluder_flag VARCHAR2) IS
2053: SELECT product_attribute_context,
2054: product_attribute,
2055: product_attr_value
2056: FROM qp_pricing_attributes
2057: WHERE list_header_id = p_list_header_id
2058: AND list_line_id = l_list_line_id
2059: AND excluder_flag = l_excluder_flag;
2060:
2078: OR end_date_active >= SYSDATE);
2079:
2080: CURSOR c_no_excl_products(l_list_line_id NUMBER) IS
2081: SELECT COUNT(*)
2082: FROM qp_pricing_attributes
2083: WHERE list_header_id = p_list_header_id
2084: AND list_line_id = l_list_line_id
2085: AND excluder_flag = 'Y';
2086:
2382: SELECT 'Y'
2383: FROM DUAL
2384: WHERE EXISTS (
2385: SELECT 1
2386: FROM qp_pricing_attributes
2387: WHERE last_update_date > l_date
2388: AND list_header_id = l_list_header_id
2389: );
2390:
2499: FROM
2500: ozf_act_forecasts_all fc,
2501: ozf_act_metric_facts_all fm,
2502: ozf_forecast_dimentions fp,
2503: qp_pricing_attributes qa,
2504: qp_list_lines ql,
2505: ozf_offers ao
2506: WHERE fp.obj_id = l_offer_id
2507: and fp.obj_type = 'OFFR'
2985: /* the following has to modified to read from ozf_offer_discount_products to handle volume offers */
2986: IF l_stmt_product IS NOT NULL THEN
2987: -- 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, ');
2988: FND_DSQL.add_text(' UNION ALL SELECT distinct null items_category, to_number(decode(product_attr_value,''ALL'',''-9999'',product_attr_value)) product_id, ');
2989: FND_DSQL.add_text(' product_attribute product_type FROM qp_pricing_attributes ');
2990: FND_DSQL.add_text(' WHERE list_header_id = ');
2991: FND_DSQL.add_bind(i.object_id);
2992: FND_DSQL.add_text(' AND list_line_id = ');
2993: FND_DSQL.add_bind(x.lline_id);
3335: IF l_stmt_product IS NOT NULL THEN
3336: --FND_DSQL.add_text(')');
3337: --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, ');
3338: FND_DSQL.add_text(' UNION ALL SELECT distinct null items_category, to_number(decode(product_attr_value,''ALL'',''-9999'',product_attr_value)) product_id, ');
3339: FND_DSQL.add_text(' product_attribute product_type FROM qp_pricing_attributes ');
3340: FND_DSQL.add_text(' WHERE list_header_id = ');
3341: FND_DSQL.add_bind(x.lline_id);
3342: FND_DSQL.add_text(' and product_attribute <> ''PRICING_ATTRIBUTE1'' AND excluder_flag = ''N'')');
3343:
3549: IF l_stmt_product IS NOT NULL THEN
3550: --FND_DSQL.add_text(')');
3551: -- 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, ');
3552: FND_DSQL.add_text(' UNION ALL SELECT distinct null items_category, to_number(decode(product_attr_value,''ALL'',''-9999'',product_attr_value)) product_id, ');
3553: FND_DSQL.add_text(' product_attribute product_type FROM qp_pricing_attributes ');
3554: FND_DSQL.add_text(' WHERE list_header_id = ');
3555: FND_DSQL.add_bind(i.object_id);
3556: FND_DSQL.add_text(' AND list_line_id = ');
3557: FND_DSQL.add_bind(x.lline_id);
4322: FROM
4323: ozf_act_forecasts_all fc,
4324: ozf_act_metric_facts_all fm,
4325: ozf_forecast_dimentions fp,
4326: qp_pricing_attributes qa,
4327: qp_list_lines ql,
4328: ozf_offers ao
4329: WHERE fp.obj_id = l_offer_id
4330: and fp.obj_type = 'OFFR'