[Home] [Help]
1236: FROM JAI_CMN_VENDOR_SITES
1237: WHERE vendor_Id = p_vendor_id
1238: AND Vendor_Site_Id = 0;
1239:
1240: CURSOR Fetch_Assessable_Val_Cur(cp_item qp_List_Lines_v.product_attribute_context%type) IS
1241:
1242: --Commented out by Eric Ma on 13-June-2011 for bug 12630041,begin
1243: --------------------------------------------------------------------------------
1244: /*
1242: --Commented out by Eric Ma on 13-June-2011 for bug 12630041,begin
1243: --------------------------------------------------------------------------------
1244: /*
1245: SELECT operand
1246: FROM qp_List_Lines_v
1247: WHERE List_header_id = v_price_list_id
1248: AND product_attribute_context = cp_item --'ITEM' -- cbabu for Bug# 3083335
1249: AND product_Id = p_inv_item_id
1250: AND product_uom_code = p_line_uom
1259: --------------------------------------------------------------------------------
1260: --SELECT operand
1261: /*SELECT /*+ no_expand * operand -- for bug 14787674 by anupgupt
1262: FROM
1263: QP_LIST_LINES QPLL
1264: , QP_PRICING_ATTRIBUTES QPPR
1265: WHERE QPLL.list_line_id = QPPR.list_line_id
1266: AND QPLL.List_header_id = v_price_list_id
1267: AND QPPR.product_attribute_context = cp_item
1272: AND NVL( End_Date_Active, SYSDATE + 1 ) >= SYSDATE; */
1273:
1274: /*Modofied cursor statement by mmurtuza for bug 16248381*/
1275: SELECT qpll.operand
1276: FROM qp_list_lines qpll,
1277: qp_pricing_attributes qppr
1278: WHERE qppr.list_line_id = qpll.list_line_id
1279: AND qpll.List_header_id = v_price_list_id
1280: AND qppr.product_attribute_context = cp_item --'ITEM'
1313: IS
1314: SELECT
1315: b.operand list_price
1316: FROM
1317: qp_list_lines b
1318: , qp_pricing_attributes c
1319: WHERE b.list_header_id = v_price_list_id
1320: AND c.list_line_id = b.list_line_id
1321: AND c.product_uom_code = pv_uom_code
1338: S.No dd/mm/yyyy Author and Details
1339: ---------------------------------------------------------------------------------------------------------------------------
1340: 1 05/08/2003 Vijay Shankar for Bug# 3083335, Version: 616.1
1341: Fetch_Assessable_Val_Cur is failing when assessable price list is not attached to the supplier site or
1342: supplier null site and the Client has some data where in QP_LIST_LINES_V.product_id clolumn has non numeric
1343: data. This is fixed by placing an additional condition in the where clause of the cursor to filter
1344: only product_attribute_context is 'ITEM'.
1345:
1346: 2. 08/30/2004 Ssumaith - bug# 3814739 - File version 115.1