DBA Data[Home] [Help]

APPS.QP_PREQ_GRP dependencies on MTL_SYSTEM_ITEMS_VL

Line 29988: FROM mtl_system_items_vl

29984:
29985: CURSOR get_request_inv_item_name_cur(p_item_id PLS_INTEGER) IS
29986: SELECT concatenated_segments
29987: --INTO l_request_item_name
29988: FROM mtl_system_items_vl
29989: WHERE inventory_item_id = p_item_id
29990: AND organization_id = QP_UTIL.Get_Item_Validation_Org;
29991: -- end shulin bug 1605829 fix
29992:

Line 30061: l_request_item_name mtl_system_items_vl.concatenated_segments%type;

30057: -- begin shulin bug 1605829 fix
30058: l_request_price_list_name qp_list_headers_v.name%type;
30059: l_request_uom VARCHAR2(30);
30060: l_request_item_id NUMBER;
30061: l_request_item_name mtl_system_items_vl.concatenated_segments%type;
30062: l_message VARCHAR2(240);
30063: -- end shulin bug 1605829 fix
30064:
30065: l_line_unit_price NUMBER:= NULL; -- shu, default to null, fix bug 2354422, avoid division zero