APPS.JAI_CMN_SETUP_PKG dependencies on QP_LIST_LINES_V

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

1181: FROM JAI_CMN_VENDOR_SITES
1182: WHERE vendor_Id = p_vendor_id
1183: AND Vendor_Site_Id = 0;
1184:
1185: CURSOR Fetch_Assessable_Val_Cur(cp_item qp_List_Lines_v.product_attribute_context%type) IS
1186: SELECT operand
1187: FROM qp_List_Lines_v
1188: WHERE List_header_id = v_price_list_id
1189: AND product_attribute_context = cp_item --'ITEM' -- cbabu for Bug# 3083335

Line 1187: FROM qp_List_Lines_v

1183: AND Vendor_Site_Id = 0;
1184:
1185: CURSOR Fetch_Assessable_Val_Cur(cp_item qp_List_Lines_v.product_attribute_context%type) IS
1186: SELECT operand
1187: FROM qp_List_Lines_v
1188: WHERE List_header_id = v_price_list_id
1189: AND product_attribute_context = cp_item --'ITEM' -- cbabu for Bug# 3083335
1190: AND product_Id = p_inv_item_id
1191: AND product_uom_code = p_line_uom

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

1199: S.No dd/mm/yyyy Author and Details
1200: ---------------------------------------------------------------------------------------------------------------------------
1201: 1 05/08/2003 Vijay Shankar for Bug# 3083335, Version: 616.1
1202: Fetch_Assessable_Val_Cur is failing when assessable price list is not attached to the supplier site or
1203: supplier null site and the Client has some data where in QP_LIST_LINES_V.product_id clolumn has non numeric
1204: data. This is fixed by placing an additional condition in the where clause of the cursor to filter
1205: only product_attribute_context is 'ITEM'.
1206:
1207: 2. 08/30/2004 Ssumaith - bug# 3814739 - File version 115.1