APPS.OZF_OFFER_PVT dependencies on QP_PRICING_ATTRIBUTES

Line 758: FROM qp_pricing_attributes

754: product_attribute ,
755: product_attr_value,
756: product_uom_code ,
757: pricing_attribute_context
758: FROM qp_pricing_attributes
759: WHERE list_line_id = parent_list_line_id;
760:
761: -- fix for accrual_flag for multi-tier lines
762: CURSOR c_offer_type(p_list_header_id NUMBER) IS

Line 771: FROM qp_rltd_modifiers a, qp_pricing_attributes b, qp_pricing_attributes c

767:
768: CURSOR c_pbh_pricing_attr_id(l_id NUMBER) IS
769: SELECT c.pricing_attribute_id,
770: c.list_line_id
771: FROM qp_rltd_modifiers a, qp_pricing_attributes b, qp_pricing_attributes c
772: WHERE c.list_line_id = a.from_rltd_modifier_id
773: AND a.to_rltd_modifier_id = b.list_line_id
774: AND b.pricing_attribute_id = l_id;
775:

Line 982: FROM qp_pricing_attributes

978: WHERE a.modifier_id = cp_listLineId;
979:
980: CURSOR c_pricingAttrId (cp_listLineId NUMBER, cp_productAttr VARCHAR2, cp_productAttrValue VARCHAR2) IS
981: SELECT pricing_attribute_id
982: FROM qp_pricing_attributes
983: WHERE list_line_id = cp_listLineId
984: AND product_attribute = cp_productAttr
985: AND product_attr_value = cp_productAttrValue
986: AND excluder_flag = 'Y';

Line 5132: SELECT pricing_attribute_id FROM qp_pricing_attributes

5128: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
5129: )
5130: IS
5131: CURSOR c_pricingAttr(cp_listLineId NUMBER) IS
5132: SELECT pricing_attribute_id FROM qp_pricing_attributes
5133: WHERE list_line_id = cp_listLineId
5134: OR list_line_id IN (select to_rltd_modifier_id FROM qp_rltd_modifiers WHERE from_rltd_modifier_id = cp_listLineId AND rltd_modifier_grp_type = 'PRICE BREAK');
5135: i NUMBER;
5136: BEGIN

Line 7524: FROM qp_pricing_attributes

7520: l_related_modifier_id NUMBER;
7521:
7522: CURSOR get_accr_pricing_attribute_id (p_list_line_id NUMBER) IS
7523: SELECT pricing_attribute_id
7524: FROM qp_pricing_attributes
7525: WHERE list_line_id = p_list_line_id
7526: AND excluder_flag = 'N';
7527:
7528: l_object_version_number NUMBER;

Line 9701: Relations between ozf products and qp products ie ozf_discount_products and qp_pricing_attributes are stored for every product irrespective of the apply discount flag or the include volume flag

9697: -- This line can be related to the ozf_product since the ozf product in this case has a one to one relation with qp pricing attribute.
9698: If the ozf product is an exclusion no qp_list_line is created for it. A qp pricing attribute is created for every PBH discount line created for the ozf discount line.
9699:
9700: 2. Products.
9701: Relations between ozf products and qp products ie ozf_discount_products and qp_pricing_attributes are stored for every product irrespective of the apply discount flag or the include volume flag
9702: */
9703:
9704:
9705: --===================================Push Discount Rules to QP===========================

Line 10746: columns in tables qp_list_lines and qp_pricing_attributes

10742:
10743: /*
10744: This procedure creates SD offer discount line records.
10745: The mapping b/w QP and SDR lines is stored in orig_sys_line_ref and orig_sys_header_ref
10746: columns in tables qp_list_lines and qp_pricing_attributes
10747: */
10748:
10749: PROCEDURE populateSDDiscountRulesRec(
10750: x_return_status OUT NOCOPY VARCHAR2