APPS.QP_PREQ_GRP dependencies on MTL_SYSTEM_ITEMS_VL

Line 35560: FROM mtl_system_items_vl

35556:
35557: CURSOR get_request_inv_item_name_cur(p_item_id PLS_INTEGER) IS
35558: SELECT concatenated_segments
35559: --INTO l_request_item_name
35560: FROM mtl_system_items_vl
35561: WHERE inventory_item_id = p_item_id
35562: AND organization_id = QP_UTIL.Get_Item_Validation_Org;
35563: -- end shulin bug 1605829 fix
35564:

Line 35634: l_request_item_name mtl_system_items_vl.concatenated_segments%type;

35630: -- begin shulin bug 1605829 fix
35631: l_request_price_list_name qp_list_headers_v.name%type;
35632: l_request_uom VARCHAR2(30);
35633: l_request_item_id NUMBER;
35634: l_request_item_name mtl_system_items_vl.concatenated_segments%type;
35635: l_message VARCHAR2(240);
35636: -- end shulin bug 1605829 fix
35637:
35638: l_line_unit_price NUMBER:= NULL; -- shu, default to null, fix bug 2354422, avoid division zero