APPS.OZF_FORECAST_UTIL_PVT dependencies on AMS_ACT_PRODUCTS

Line 554: 'from ams_act_products a, '||

550: ' ''QUALIFIER_ATTRIBUTE2'' QUALIFIER_ATTRIBUTE, '||
551: ' b.qualifier_id QUALIFIER_ATTR_VALUE, '||
552: ' null QUALIFIER_ATTR_VALUE_TO, '||
553: ' ''='' COMPARISON_OPERATOR_CODE '||
554: 'from ams_act_products a, '||
555: 'ozf_offers b '||
556: 'where a.arc_act_product_used_by = :l_object_type '||
557: 'and a.act_product_used_by_id = :l_object_id '||
558: 'and a.act_product_used_by_id = b.qp_list_header_id '||

Line 576: 'from ams_act_products a, '||

572: ' ''PRICING_ATTRIBUTE2'') product_attribute_e , '||
573: ' DECODE(b.level_type_code,''PRODUCT'', '||
574: ' b.inventory_item_id, '||
575: ' b.category_id) product_attr_value_e '||
576: 'from ams_act_products a, '||
577: ' ams_act_products b '||
578: 'where a.arc_act_product_used_by = :l_object_type '||
579: 'and a.act_product_used_by_id = :l_object_id '||
580: 'and a.excluded_flag = ''N'' '||

Line 577: ' ams_act_products b '||

573: ' DECODE(b.level_type_code,''PRODUCT'', '||
574: ' b.inventory_item_id, '||
575: ' b.category_id) product_attr_value_e '||
576: 'from ams_act_products a, '||
577: ' ams_act_products b '||
578: 'where a.arc_act_product_used_by = :l_object_type '||
579: 'and a.act_product_used_by_id = :l_object_id '||
580: 'and a.excluded_flag = ''N'' '||
581: 'and b.arc_act_product_used_by = ''PROD'' '||

Line 8461: FROM ams_act_products a ,

8457:
8458: CURSOR c_offer_type IS
8459: SELECT min(b.offer_type) offer_type,
8460: sum(a.line_lumpsum_qty) total_qty
8461: FROM ams_act_products a ,
8462: ozf_offers b
8463: WHERE a.arc_act_product_used_by = p_obj_type
8464: AND a.act_product_used_by_id = p_obj_id
8465: AND b.qp_list_header_id = a.act_product_used_by_id ;

Line 8473: from ams_act_products a,

8469: SELECT DECODE(b.distribution_type,
8470: 'AMT', 100 * a.line_lumpsum_qty/b.lumpsum_amount,
8471: '%' , a.line_lumpsum_qty,
8472: 'QTY', 100 * a.line_lumpsum_qty/p_lumpsum_qty ) lumpsum_disc
8473: from ams_act_products a,
8474: ozf_offers b
8475: where a.arc_act_product_used_by = p_obj_type
8476: and a.act_product_used_by_id = p_obj_id
8477: and a.act_product_used_by_id = b.qp_list_header_id

Line 8777: FROM ams_act_products a ,

8773:
8774: CURSOR c_offer_type IS
8775: SELECT min(b.offer_type) offer_type,
8776: sum(a.line_lumpsum_qty) total_qty
8777: FROM ams_act_products a ,
8778: ozf_offers b
8779: WHERE a.arc_act_product_used_by = p_obj_type
8780: AND a.act_product_used_by_id = p_obj_id
8781: AND b.qp_list_header_id = a.act_product_used_by_id ;

Line 8794: from ams_act_products a,

8790: SELECT DECODE(b.distribution_type,
8791: 'AMT', a.line_lumpsum_qty,
8792: '%' , (b.lumpsum_amount*a.line_lumpsum_qty)/100 ,
8793: 'QTY', (a.line_lumpsum_qty * b.lumpsum_amount)/p_lumpsum_qty ) lumpsum_disc
8794: from ams_act_products a,
8795: ozf_offers b
8796: where a.arc_act_product_used_by = p_obj_type
8797: and a.act_product_used_by_id = p_obj_id
8798: and a.act_product_used_by_id = b.qp_list_header_id