4983: ) IS
4984: query_str VARCHAR2(10000);
4985: query_hdl NUMBER;
4986: rows_processed NUMBER;
4987: status_id mtl_material_statuses_vl.status_id%TYPE;
4988: status_code mtl_material_statuses_vl.status_code%TYPE;
4989: i NUMBER := x_tbl_index;
4990: j NUMBER := x_node_value;
4991: serial_control NUMBER;
4984: query_str VARCHAR2(10000);
4985: query_hdl NUMBER;
4986: rows_processed NUMBER;
4987: status_id mtl_material_statuses_vl.status_id%TYPE;
4988: status_code mtl_material_statuses_vl.status_code%TYPE;
4989: i NUMBER := x_tbl_index;
4990: j NUMBER := x_node_value;
4991: serial_control NUMBER;
4992: table_required VARCHAR2(300);
5020: END IF ;
5021: -- NSRIVAST, INVCONV, End
5022:
5023: query_str := 'SELECT mms.status_id, mms.status_code ';
5024: query_str := query_str || 'FROM mtl_material_statuses_vl mms ';
5025: query_str := query_str || ' WHERE exists (';
5026:
5027: IF inv_mwb_globals.g_organization_id IS NOT NULL
5028: AND inv_mwb_globals.g_inventory_item_id IS NOT NULL THEN