APPS.JAI_CMN_SETUP_PKG dependencies on QP_LIST_LINES_V

Line 1240: CURSOR Fetch_Assessable_Val_Cur(cp_item qp_List_Lines_v.product_attribute_context%type) IS

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: /*

Line 1246: FROM qp_List_Lines_v

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

Line 1342: supplier null site and the Client has some data where in QP_LIST_LINES_V.product_id clolumn has non numeric

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