APPS.OZF_PRICELIST_PVT dependencies on QP_PRICING_ATTRIBUTES

Line 1161: FROM qp_pricing_attributes

1157: CURSOR c_item_in_prl IS
1158: SELECT 'Y'
1159: FROM DUAL
1160: WHERE EXISTS(SELECT 1
1161: FROM qp_pricing_attributes
1162: WHERE product_attribute = 'PRICING_ATTRIBUTE1'
1163: AND product_attr_value = p_inv_item_id
1164: AND list_header_id = p_list_header_id);
1165:

Line 1209: FROM qp_pricing_attributes qpa, qp_list_lines qll, qp_list_headers_b qlh

1205: v_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
1206:
1207: CURSOR c_list_header_line_id (l_source_system_code VARCHAR2) IS
1208: SELECT DISTINCT qpa.list_header_id, qpa.list_line_id
1209: FROM qp_pricing_attributes qpa, qp_list_lines qll, qp_list_headers_b qlh
1210: WHERE qll.list_line_id = qpa.list_line_id
1211: AND qpa.product_attribute = 'PRICING_ATTRIBUTE1'
1212: AND qpa.product_attr_value = TO_CHAR(p_org_inv_item_id)
1213: AND qlh.list_header_id = qpa.list_header_id

Line 1231: FROM qp_pricing_attributes

1227: l_list_line_detail c_list_line_detail%ROWTYPE;
1228:
1229: CURSOR c_pricing_detail (l_list_line_id NUMBER) IS
1230: SELECT *
1231: FROM qp_pricing_attributes
1232: WHERE list_line_id = l_list_line_id;
1233: l_pricing_detail c_pricing_detail%ROWTYPE;
1234:
1235:

Line 1241: SELECT qp_pricing_attributes_s.NEXTVAL

1237: SELECT qp_list_lines_s.NEXTVAL
1238: FROM DUAL;
1239:
1240: CURSOR c_pricing_attr_id IS
1241: SELECT qp_pricing_attributes_s.NEXTVAL
1242: FROM DUAL;
1243:
1244: l_list_line_id NUMBER;
1245: l_pricing_attr_id NUMBER;

Line 1422: INSERT INTO qp_pricing_attributes(pricing_attribute_id

1418: ,l_list_line_detail.pricing_group_sequence
1419: ,l_list_line_detail.incompatibility_grp_code
1420: ,l_list_line_detail.product_precedence);
1421:
1422: INSERT INTO qp_pricing_attributes(pricing_attribute_id
1423: ,accumulate_flag
1424: ,attribute1
1425: ,attribute2
1426: ,attribute3